二维表.sql

数据库优秀课程设计——企业人事管理系统 VB界面连接数据库

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