用户登陆.sql

用VB.NET做的软件工程课程设计

create database users
create table userinfo
(empno char(20) primary key,
userpwd char(10),
loginmode char(10),
foreign key (empno) references empinfo(empno)
on delete cascade
on update cascade,
)

drop table userinfo

insert into userinfo values('20050230105','feng','管理员')
insert into userinfo values('20050230104','huang','领导')
insert into userinfo values('20050230109','hai','职工')

select * from userinfo

create table empinfo
(empname char(10),
empsex char(5),
emprace char(10),
empyear char(10),
empmonth char(10),
empday char(10),
empnative char(20),
empno char(20) primary key,
empost char(20),
empdepart char(20),
empremark char(100),

)
drop table empinfo
select * from empinfo

insert into empinfo values('张三','男','汉',1987,12,25,'江苏泰州','20050230105','经理','销售部','工作比较认真')
insert into empinfo values('小王','女','汉',1987,12,21,'江苏苏州','20050230104','经理','组织部','工作比较认真')
insert into empinfo values('小张','男','汉',1967,10,25,'湖北武汉','20050230109','经理','生产部','工作比较认真')
insert into empinfo values('xiaoli','女','汉',1978,12,21,'江苏苏州','20050230107','经理','组织部','比较认真')

create table checkinfo
(empno char(20) primary key,
shenggao char(10),
tizhong char(20),
shili char(10),
xueya char(10),
gumidu char(10),
gangongneng char(20),
shenggongneng char(20),
cheadv char(100),--医生的意见
foreign key (empno) references empinfo(empno)
on delete cascade
on update cascade,
)
select * from checkinfo
drop table checkinfo