📄 createrecruitmentobjects1-cn.sql
字号:
Insert into 大学 values('0009','复旦大学 ','NULL','上海',NULL,'93555-1648','(760)761-4591')
go
create table 招聘会
(
招聘会代号 char(4),
大学代号 char(4) ,
开始时间 datetime,
截止日期 datetime
)
go
Insert into 招聘会 values('0001','0003','05/13/2001','05/28/2001')
Insert into 招聘会 values('0002','0005','05/23/2001','06/07/2001')
Insert into 招聘会 values('0003','0002','05/13/2001','05/28/2001')
go
create table 内部职位信息
(
信息号 char(4),
职位号 char(4),
需求人数 smallint not null,
通知时间 datetime not null,
截止日期 datetime
)
go
Insert into 内部职位信息 values('0001','0002',6,'03/13/2001','04/12/2001')
Insert into 内部职位信息 values('0002','0004',9,'03/15/2001','04/12/2001')
Insert into 内部职位信息 values('0003','0001',7,'04/02/2001','04/22/2001')
Insert into 内部职位信息 values('0004','0002',12,'03/13/2001','04/12/2001')
Insert into 内部职位信息 values('0005','0004',2,'03/13/2000','04/12/2000')
Insert into 内部职位信息 values('0006','0002',4,'03/13/2000','04/12/2000')
go
create table 内部候选人
(
候选人代号 char(6) ,
员工代号 char(6),
内部职位信息号 char(4),
现任职位 char(4),
申请时间 datetime,
测试时间 datetime,
测试成绩 smallint,
面试日期 datetime,
面试者 char(25),
意见 varchar(256),
评价等级 char,
状态 char,
)
Insert into 内部候选人 values('000001','000012','0001','0002','04/02/2001','04/06/2001',96,'04/09/2001',null,null,'5',null)
Insert into 内部候选人 values('000002','000002','0001','0002','04/02/2001','04/06/2001',67,'04/09/2001',null,null,'6',null)
Insert into 内部候选人 values('000003','000011','0003','0001','04/02/2001','04/06/2001',88,'04/09/2001',null,null,'9',null)
Insert into 内部候选人 values('000004','000002','0003','0001','04/02/2001','04/06/2001',83,'04/09/2001',null,null,'7',null)
Insert into 内部候选人 values('000005','000008','0001','0002','04/02/2001','04/06/2001',43,'04/09/2001',null,null,'3',null)
Insert into 内部候选人 values('000018','000003','0001','0002','02/02/2001','03/06/2001',null,'04/09/2001',null,null,'8',null)
go
go
create table 员工
(
员工号 char(6),
员工姓名 varchar(20),
候选人代号 char(6),
地址 varchar(35),
城市 char(20),
省份 char(20),
邮编 char(10),
国家号 char(3) ,
电话 char(15),
学历 varchar(20),
出生年月日 datetime,
性别 char,
当前职位 char(20),
电子邮件 char(20),
部门号 char(4),
照片 image,
参加时间 datetime,
辞职时间 datetime,
身份证号码 char(15) unique,
)
/* data for 员工 rtable */
Insert into 员工 values('000001','史云','000001','湖北武汉桥口安定巷110号 ','湖北省','武汉市','66101-2945','001','(913)227-2344 ','Graduate','02/12/1969','F','0001','angelas@qmail.com','0002',null,'06/16/2001',null,'627-89-6952')
Insert into 员工 values('000002','薜刚','000003','湖北省沂山县潘口乡百果村三组 ','湖北省','沂山市','43017-3004','001','(614)458-3299 ','Graduate','08/06/1971','F','0010','bettyw@dpeedmil.cm','0005',null,'06/16/2000',null,'617-40-3628')
Insert into 员工 values('000003','林中','000004','武汉市武昌区万福林76-2号 ','湖北省','武汉市','67654-1255','001','(785)678-4544 ','Graduate','06/10/1979','F','0012','carolj@qmail.com','0003',null,'06/19/2000',null,'806-84-8173')
Insert into 员工 values('000004','魏中贤','000005','武昌区保善地堤铁路宿舍二单元七号','湖北省','武汉市','67654-1255','001','(785)445-2256 ','BBA','10/10/1962','F','0007','catheriner@qmail.com','0009',null,'06/29/2000',null,'763-26-5478')
Insert into 员工 values('000005','黄俊','000014','汉阳王家湾磨山村209# ','湖北省','武汉市','43017-3004','001','(614)545-9078 ','Graduate','10/12/1969','F','0013','elizabethj@qmail.com','0007',null,'07/21/2000',null,'356-05-5459')
Insert into 员工 values('000006','李天','000016','武汉市汉阳区七里小区308 ','湖北省','武汉市','10024-7401','001','(212)585-7796 ','Graduate','02/01/1972','F','0015','helenw@spedmail.com','0003',null,'08/29/2000',null,'326-69-3560')
Insert into 员工 values('000007','袁华','000018','湖北武汉市江岸区韦桑路82号 ','湖北省','武汉市','49603-2485','001','(617)569-7789 ','BBA','05/22/1966','F','0015','jenniferm@qmail.com','0004',null,'08/30/2000',null,'343-26-6693')
Insert into 员工 values('000008','曾用','000026','武汉市关西小区36栋4单元301号 ','湖北省','武汉市','31904-7624','001','(706)459-4563 ','Graduate','11/06/1969','F','0014','lindal@qmail.com','0010',null,'09/08/2000',null,'384-08-6778')
Insert into 员工 values('000009','吴兵','000029','武汉市桥口区古南小区34-1-6 ','湖北省','武汉市','31904-7624','001','(706)345-8764 ','MBA','10/21/1968','F','0008','Mariah@speedmail.com','0003',null,'09/08/2000',null,'783-06-7914')
Insert into 员工 values('000010','刘国卫','000035','武汉竹叶新村13号501室 ','湖北省','武汉市','07081-1442','001','(973)912-7905 ','Graduate','11/01/1968','M','0006','paull@qmail.com','0009',null,'09/21/2000',null,'990-35-4788')
Insert into 员工 values('000011','马华军','000039','武汉汽轮发电机厂宿舍46号 ','湖北省','武汉市','07748-3224','001','(732)982-9503 ','Graduate','05/22/1969','F','0003','Sandra@qmail.com','0009',null,'09/26/2000',null,'499-03-5817')
Insert into 员工 values('000013','陈刚','000046','武汉市洪山区建设乡桂家咀30号 ','湖北省','武汉市','89123-2514','001','(702)678-3458 ','MBA','04/08/1966','M','0003','davidc@speedmail.com','0009',null,'10/05/2000',null,'499-03-5816')
Insert into 员工 values('000012','雷莉','000045','武汉市江岸区万民街25号 ','湖北省','武汉市','89123-2514','001','(702)234-8764 ','Graduate','02/07/1969','M','0002','williamp@qmail.com','0003',null,'10/05/2000',null,'517-82-4993')
Insert into 员工 values('000014','宋庆勇','000047','常青花园12村16栋3单元101-102 ','湖北省','武汉市','44060-4514','001','(440)890-4084 ','Graduate','08/07/1971','M','0015','peterp@qmail.com','0008',null,'11/08/2000',null,'216-22-6414')
go
create table 工资
(
员工号 char(6),
月工资 money,
支付日期 datetime,
奖金 money,
)
insert into 工资 values('000001', 3833.33,'07/01/1999',0)
insert into 工资 values('000001', 3833.33,'08/01/1999',0)
insert into 工资 values('000001', 3833.33,'09/01/1999',0)
insert into 工资 values('000001', 3833.33,'10/01/1999',0)
insert into 工资 values('000001', 3833.33,'11/01/1999',0)
insert into 工资 values('000001', 3833.33,'12/01/1999',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'01/01/2000',0)
insert into 工资 values('000001', 4000.00,'02/01/2000',0)
insert into 工资 values('000001', 4000.00,'03/01/2000',0)
insert into 工资 values('000001', 4000.00,'04/01/2000',0)
insert into 工资 values('000001', 4000.00,'05/01/2000',0)
insert into 工资 values('000001', 4000.00,'06/01/2000',0)
insert into 工资 values('000001', 4000.00,'07/01/2000',0)
--------------------------------------------------------------------
insert into 工资 values('000002', 3000.00,'07/01/2000',0)
insert into 工资 values('000004', 4000.00,'07/01/2000',0)
insert into 工资 values('000005', 4000.00,'07/01/2000',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'08/01/2000',0)
insert into 工资 values('000002', 3000.00,'08/01/2000',0)
insert into 工资 values('000004', 4000.00,'08/01/2000',0)
insert into 工资 values('000005', 4000.00,'08/01/2000',0)
insert into 工资 values('000006', 4000.00,'08/01/2000',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'09/01/2000',0)
insert into 工资 values('000002', 3000.00,'09/01/2000',0)
insert into 工资 values('000004', 4000.00,'09/01/2000',0)
insert into 工资 values('000005', 4000.00,'09/01/2000',0)
insert into 工资 values('000006', 4000.00,'09/01/2000',0)
insert into 工资 values('000007', 2000.00,'09/01/2000',0)
insert into 工资 values('000008', 2000.00,'09/01/2000',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'10/01/2000',0)
insert into 工资 values('000002', 3000.00,'10/01/2000',0)
insert into 工资 values('000004', 4000.00,'10/01/2000',0)
insert into 工资 values('000005', 4000.00,'10/01/2000',0)
insert into 工资 values('000006', 4000.00,'10/01/2000',0)
insert into 工资 values('000007', 2000.00,'10/01/2000',0)
insert into 工资 values('000008', 2000.00,'10/01/2000',0)
insert into 工资 values('000009', 2500.00,'10/01/2000',0)
insert into 工资 values('000010', 2000.00,'10/01/2000',0)
insert into 工资 values('000011', 2000.00,'10/01/2000',0)
insert into 工资 values('000012', 3000.00,'10/01/2000',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'11/01/2000',0)
insert into 工资 values('000002', 3000.00,'11/01/2000',0)
insert into 工资 values('000004', 4000.00,'11/01/2000',0)
insert into 工资 values('000005', 4000.00,'11/01/2000',0)
insert into 工资 values('000006', 4000.00,'11/01/2000',0)
insert into 工资 values('000007', 2000.00,'11/01/2000',0)
insert into 工资 values('000008', 2000.00,'11/01/2000',0)
insert into 工资 values('000009', 2500.00,'11/01/2000',0)
insert into 工资 values('000010', 2000.00,'11/01/2000',0)
insert into 工资 values('000011', 2000.00,'11/01/2000',0)
insert into 工资 values('000012', 3000.00,'11/01/2000',0)
insert into 工资 values('000013', 4000.00,'11/01/2000',0)
insert into 工资 values('000014', 3000.00,'11/01/2000',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'12/01/2000',0)
insert into 工资 values('000002', 3000.00,'12/01/2000',0)
insert into 工资 values('000004', 4000.00,'12/01/2000',0)
insert into 工资 values('000005', 4000.00,'12/01/2000',0)
insert into 工资 values('000006', 4000.00,'12/01/2000',0)
insert into 工资 values('000007', 2000.00,'12/01/2000',0)
insert into 工资 values('000008', 2000.00,'12/01/2000',0)
insert into 工资 values('000009', 2500.00,'12/01/2000',0)
insert into 工资 values('000010', 2000.00,'12/01/2000',0)
insert into 工资 values('000011', 2000.00,'12/01/2000',0)
insert into 工资 values('000012', 3000.00,'12/01/2000',0)
insert into 工资 values('000013', 4000.00,'12/01/2000',0)
insert into 工资 values('000014', 3000.00,'12/01/2000',0)
insert into 工资 values('000015', 2000.00,'12/01/2000',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'01/01/2001',0)
insert into 工资 values('000002', 3000.00,'01/01/2001',0)
insert into 工资 values('000004', 4000.00,'01/01/2001',0)
insert into 工资 values('000005', 4000.00,'01/01/2001',0)
insert into 工资 values('000006', 4000.00,'01/01/2001',0)
insert into 工资 values('000007', 2000.00,'01/01/2001',0)
insert into 工资 values('000008', 2000.00,'01/01/2001',0)
insert into 工资 values('000009', 2500.00,'01/01/2001',0)
insert into 工资 values('000010', 2000.00,'01/01/2001',0)
insert into 工资 values('000011', 2000.00,'01/01/2001',0)
insert into 工资 values('000012', 3000.00,'01/01/2001',0)
insert into 工资 values('000013', 4000.00,'01/01/2001',0)
insert into 工资 values('000014', 3000.00,'01/01/2001',0)
insert into 工资 values('000015', 2000.00,'01/01/2001',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'02/01/2001',0)
insert into 工资 values('000002', 3000.00,'02/01/2001',0)
insert into 工资 values('000004', 4000.00,'02/01/2001',0)
insert into 工资 values('000005', 4000.00,'02/01/2001',0)
insert into 工资 values('000006', 4000.00,'02/01/2001',0)
insert into 工资 values('000007', 2000.00,'02/01/2001',0)
insert into 工资 values('000008', 2000.00,'02/01/2001',0)
insert into 工资 values('000009', 2500.00,'02/01/2001',0)
insert into 工资 values('000010', 2000.00,'02/01/2001',0)
insert into 工资 values('000011', 2000.00,'02/01/2001',0)
insert into 工资 values('000012', 3000.00,'02/01/2001',0)
insert into 工资 values('000013', 4000.00,'02/01/2001',0)
insert into 工资 values('000014', 3000.00,'02/01/2001',0)
insert into 工资 values('000015', 2000.00,'02/01/2001',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'03/01/2001',0)
insert into 工资 values('000002', 3000.00,'03/01/2001',0)
insert into 工资 values('000004', 4000.00,'03/01/2001',0)
insert into 工资 values('000005', 4000.00,'03/01/2001',0)
insert into 工资 values('000006', 4000.00,'03/01/2001',0)
insert into 工资 values('000007', 2000.00,'03/01/2001',0)
insert into 工资 values('000008', 2000.00,'03/01/2001',0)
insert into 工资 values('000009', 2500.00,'03/01/2001',0)
insert into 工资 values('000010', 2000.00,'03/01/2001',0)
insert into 工资 values('000011', 2000.00,'03/01/2001',0)
insert into 工资 values('000012', 3000.00,'03/01/2001',0)
insert into 工资 values('000013', 4000.00,'03/01/2001',0)
insert into 工资 values('000014', 3000.00,'03/01/2001',0)
insert into 工资 values('000015', 2000.00,'03/01/2001',0)
--------------------------------------------------------------------
insert into 工资 values('000001', 4000.00,'04/01/2001',0)
insert into 工资 values('000002', 3000.00,'04/01/2001',0)
insert into 工资 values('000004', 4000.00,'04/01/2001',0)
insert into 工资 values('000005', 4000.00,'04/01/2001',0)
insert into 工资 values('000006', 4000.00,'04/01/2001',0)
insert into 工资 values('000007', 2000.00,'04/01/2001',0)
insert into 工资 values('000008', 2000.00,'04/01/2001',0)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -