[안드로이드/android] sns 친구맺기 데이터 스트럭쳐

user 테이블

create table user(
id varchar(20),
password varchar(20) not null default null,
nickname varchar(10) not null unique,
sex char(1) not null default 'm',
Api_Token varchar(20) default 'ERYON',
primary key(id,Api_Token));

 

 

relationship 테이블

create table relationship(
one_name varchar(10),
two_name varchar(10),
status enum('0','1','2') default '0',    //    0: 대기중인 친구요청   1: 수락   2: 거부(차단)
primary key(one_name,two_name),
constraint fk_name1 foreign key(one_name) references user(nickname) on delete cascade,
constraint fk_name2 foreign key(two_name) references user(nickname) on delete cascade);