创建表.sql

企业人事管理系统主要功能有： ①人事档案管理：户口状况、政治面貌、生理状况、合同管理等； ②考勤加班出差管理； ③人事变动：新进员工登记、员工离职登记、人事变更记录； ④考核奖惩； ⑤员工培

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 
);