#民族
create table minzu
(
daihao varchar(50) primary key,
minzu varchar (50)
);
#称谓
create table chengwei
(
daihao varchar (50) primary key,
chengwei varchar (50)
);
#人员
create table renyuan
(
daihao varchar (50) primary key ,
xingming varchar (50),
nianling int ,
xingbie bit ,
minzu varchar (50) references minzu (daihao),
foreign key (minzu) references minzu(daihao)
);
#家庭
create table jaiting
(
xingming varchar (50) references renyuan(daihao),
chengyuan varchar (50)primary key,
guanxi varchar(50) references chengwei(daihao),
foreign key (xingming) references renyuan(daihao),
foreign key (guanxi) references chengwei(daihao)
);
#成员简历
create table jianli
(
xingming varchar(50) references renyuan(daihao),
danwei varchar (50) primary key,
shijian double (5,2),
zhiwu varchar (50)
)
;