数据库建表代码.doc

员工表 Create database HRM; Use HRM； Create table t_staff ( ID int primary key auto_increment, Staff_ID varchar(12) not null, name varchar(20) not null, gender varchar(2) not null, birthday date not null, ethnic varchar(20) not null, political_landscape varchar(10) not null, birthplace varchar(60) not null, tellphone varchar(12) not null, E-mail varchar(30) not null, Home_address varchar(60) not null, emergency_contact_name varchar(20) not null, emergency_contact_tel varchar(20) not null, start_working_time date not null, incoming_date date not null, identification_ID varchar(18) not null, department_ID varchar(3) not null, position varchar(20) not null, foreign key (department_ID) references department(department_ID), direct_header varchar(12) not null, photo blob not null, wage_bank varchar(20) not null, card_num varchar(19) not null, basic_wage int not null, remark varchar(600), foreign key (direct_header) references department(Staff_ID) ); 部门表 Create table t_depatrment ( ID int primary key auto_increment, department_ID varchar(3) not null, department_manager_ID varchar(12) not null, department_name varchar(20) not null, remark varchar(600), ); 教育经历表 Create table t_education( ID int primary key auto_increment, Staff_ID varchar(12) not null, Grade varchar(5), School varchar(20), Start_time date, End_time date, Reward_punish varchar(600), Major varchar(20), remark varchar(600), foreign key (Staff_ID) references t_staff (Staff_ID) ); 家庭成员表 Create table t_family( ID int primary key auto_increment, Staff_ID varchar(12) not null, Name varchar(20) not null, Gender varchar(2) not null, Relation varchar(20) not null, Address varchar(60), Work_unit varchar(30), Tellphone