创建表.sql

来自「企业人事管理系统主要功能有： ①人事档案管理：户口状况、政治面貌、生理状况、合」· SQL 代码 · 共 33 行

use managesystem;
create table BaseTable(
	BID varchar(10) not null unique,
	BName varchar(20) not null,
 	BAge int,
	BSex varchar(2),
	BResidence varchar(50),
	BPolity varchar(50),
	BHealthy varchar(50),
	BAgreement varchar(50),
	BDepartment varchar(20) not null,
	BPhoto image,
	BPassword varchar(50) not null,
	BPosition varchar(10) not null,
	primary key(BID),
	check (BAge>0),
        check (BSex in ('男','女')),
	check (BPosition in ('员工','维护部员工','经理','人事经理','总裁'))
);

create table ExtendTable(
	EID varchar(10) not null,
	EDate varchar(10) not null,
	EState varchar(4),		--考勤，内容为“请假，旷到，迟到，正常,出差”
	EOverwork varchar(2),		--加班，内容“有，无”
	ERAP varchar(500),		--奖惩(rewards and punishment)
	ETraining varchar(500),
	primary key(EID,EDate),
	check (EState in ('请假','旷到','迟到','正常','出差')),
	check (EOverwork in ('有','无')),
	foreign key(EID) references BaseTable(BID) on delete cascade 
);