📄 repo1.htm
字号:
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_email_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_email_72C60C4A on dbo.employee (<br />
email ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_empName_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_empName_72C60C4A on dbo.employee (<br />
empName ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_IDCard_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_IDCard_72C60C4A on dbo.employee (<br />
IDCard ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_major_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_major_72C60C4A on dbo.employee (<br />
major ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_phone_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_phone_72C60C4A on dbo.employee (<br />
phone ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_school_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_school_72C60C4A on dbo.employee (<br />
school ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_sex_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_sex_72C60C4A on dbo.employee (<br />
sex ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_startjob_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_startjob_72C60C4A on dbo.employee (<br />
startjob ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Employee_Job */<br />
/*==============================================================*/<br />
create table dbo.Employee_Job (<br />
empid int null,<br />
jobid int null<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Exprience */<br />
/*==============================================================*/<br />
create table dbo.Exprience (<br />
oid int not null,<br />
empid int not null,<br />
startDate datetime null,<br />
endDate datetime null,<br />
companyName varchar(20) null,<br />
deptName varchar(10) null,<br />
jobName varchar(10) null,<br />
proofer varchar(10) null,<br />
phone varchar(20) null,<br />
description varchar(100) null,<br />
constraint PK_EXPRIENCE primary key clustered (oid)<br />
on "PRIMARY"<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: FamillyInfo */<br />
/*==============================================================*/<br />
create table dbo.FamillyInfo (<br />
empid int not null,<br />
married char(1) null,<br />
native int null,<br />
nation int null,<br />
polity int null,<br />
identitys varchar(20) null,<br />
contactPhone varchar(20) null,<br />
contactName varchar(20) null,<br />
homeAddress varchar(100) null,<br />
homeZipCode varchar(10) null,<br />
urgentContact varchar(10) null,<br />
urgentphone varchar(20) null,<br />
constraint PK_FAMILLYINFO primary key clustered (empid)<br />
on "PRIMARY"<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: JobInfo */<br />
/*==============================================================*/<br />
create table dbo.JobInfo (<br />
empid int not null,<br />
emplyeeid int null,<br />
workDate datetime null,<br />
jobid int null,<br />
joinDate datetime null,<br />
fileDate datetime null,<br />
contractStart datetime null,<br />
contractEnd datetime null,<br />
assureDate datetime null,<br />
secretDate datetime null,<br />
constraint PK_JOBINFO primary key clustered (empid)<br />
on "PRIMARY"<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: post */<br />
/*==============================================================*/<br />
create table post (<br />
oid int identity,<br />
postName int null,<br />
constraint PK_POST primary key (oid)<br />
)<br />
go<br />
<br />
alter table dbo.Account<br />
add constraint FK_ACCOUNT_REFERENCE_EMPLOYEE foreign key (employeeid)<br />
references dbo.employee (emplyeeid)<br />
go<br />
<br />
alter table dbo.Adjustment<br />
add constraint FK_ADJUSTME_REFERENCE_EMPLOYEE foreign key (empid)<br />
references dbo.employee (emplyeeid)<br />
go<br />
<br />
alter table dbo.Department_Job<br />
add constraint FK_DEPARTME_REFERENCE_DEPARTME foreign key (deptid)<br />
references dbo.Department (oid)<br />
go<br />
<br />
alter table dbo.Department_Job<br />
add constraint FK_DEPARTME_REFERENCE_POST foreign key (jobid)<br />
references post (oid)<br />
go<br />
<br />
alter table dbo.Employee_Job<br />
add constraint FK_EMPLOYEE_REFERENCE_EMPLOYEE foreign key (empid)<br />
references dbo.employee (emplyeeid)<br />
go<br />
<br />
alter table dbo.Employee_Job<br />
add constraint FK_EMPLOYEE_REFERENCE_POST foreign key (jobid)<br />
references post (oid)<br />
go<br />
<br />
alter table dbo.Exprience<br />
add constraint FK_EXPRIENC_REFERENCE_EMPLOYEE foreign key (empid)<br />
references dbo.employee (emplyeeid)<br />
go<br />
<br />
alter table dbo.FamillyInfo<br />
add constraint FK_FAMILLYI_REFERENCE_EMPLOYEE foreign key (empid)<br />
references dbo.employee (emplyeeid)<br />
go<br />
<br />
alter table dbo.JobInfo<br />
add constraint FK_JOBINFO_REFERENCE_EMPLOYEE foreign key (emplyeeid)<br />
references dbo.employee (emplyeeid)<br />
go<br />
</p>
</td></tr>
</table><br />
<h1>
<a name="4">命名预览</a>
</h1>
<h3>
<a name="5">表格清单</a>
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo3.htm#37">系统帐号</a>
</p>
</td>
<td>
<p align="left"><a href="Repo3.htm#37">Account</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo3.htm#27">员工调动记录</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo3.htm#27">Adjustment</a>
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo3.htm#47">部门</a>
</p>
</td>
<td>
<p align="left"><a href="Repo3.htm#47">Department</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo3.htm#52">部门职位表</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo3.htm#52">Department_Job</a>
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo3.htm#8">员工</a>
</p>
</td>
<td>
<p align="left"><a href="Repo3.htm#8">employee</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo3.htm#23">员工职位表</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo3.htm#23">Employee_Job</a>
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo3.htm#18">员工工作经历</a>
</p>
</td>
<td>
<p align="left"><a href="Repo3.htm#18">Exprience</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo3.htm#32">家庭信息</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo3.htm#32">FamillyInfo</a>
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo3.htm#13">员工工作信息</a>
</p>
</td>
<td>
<p align="left"><a href="Repo3.htm#13">JobInfo</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo3.htm#42">职位表</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo3.htm#42">post</a>
</p>
</td>
</tr>
</table><br />
<hr />
<table><tr>
<td><table class="NavGroup"><tr><td><a class="NavButton" href="Report 1.htm">上一页</a></td></tr></table></td>
<td width=4></td>
<td><table class="NavGroup"><tr><td><a class="NavButton" href="Report%201.htm">主页</a></td></tr></table></td>
<td width=4></td>
<td><table class="NavGroup"><tr><td><a class="NavButton" href="Repo2.htm">下一页</a></td></tr></table></td></tr></table>
<br />
<br />
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -