新建文稿(1).docx

create table employees

(yuangongbianhao charlIO) NOT NULL primary key, xingming varcharl19) NOT NULL, xueli

charlIO) NOT NULL, chushengriqi date NOT NULL, xingbie tinyint NOT NULL,

gongzuonianxian tinyint, dizhi text, dianhuahaoma charlI2), yuangongbumenhao tinyint);

create table departments

(bumenbianhao char(5) NOT NULL primary key, bumenmingcheng text NOT NULL, beizhu

text);

create table salary(yuangongbianhao char(1O) NOT NULL, primary keylyuangongbianhao),

foreign keylyuangongbianhaol references yg(yuangongbianhao), shouru float(8,2) NOT NULL,