📄 repo4.htm
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-936">
<title>Report 1
</title>
<link href="Blue_Theme.css" type="text/css" rel="stylesheet">
</head>
<!--This file has been automatically generated by PowerDesigner.-->
<body>
<h3>
<a name="4">表格清单</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="Repo4.htm#36">系统帐号</a>
</p>
</td>
<td>
<p align="left"><a href="Repo4.htm#36">Account</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo4.htm#26">员工调动记录</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo4.htm#26">Adjustment</a>
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo4.htm#46">部门</a>
</p>
</td>
<td>
<p align="left"><a href="Repo4.htm#46">Department</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo4.htm#51">部门职位表</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo4.htm#51">Department_Job</a>
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo4.htm#7">员工</a>
</p>
</td>
<td>
<p align="left"><a href="Repo4.htm#7">employee</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo4.htm#22">员工职位表</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo4.htm#22">Employee_Job</a>
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo4.htm#17">员工工作经历</a>
</p>
</td>
<td>
<p align="left"><a href="Repo4.htm#17">Exprience</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo4.htm#31">家庭信息</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo4.htm#31">FamillyInfo</a>
</p>
</td>
</tr>
<tr>
<td>
<p align="left"><a href="Repo4.htm#12">员工工作信息</a>
</p>
</td>
<td>
<p align="left"><a href="Repo4.htm#12">JobInfo</a>
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left"><a href="Repo4.htm#41">职位表</a>
</p>
</td>
<td class="TD2">
<p align="left"><a href="Repo4.htm#41">post</a>
</p>
</td>
</tr>
</table><br />
<h1>
<a name="5">Tables</a>
</h1>
<h1>
<a name="6">Model level tables</a>
</h1>
<h2>
<a name="7">表格员工</a>
</h2>
<h3>
<a name="8">表格员工的卡片</a>
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="Repo4.htm#7">员工</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="Repo4.htm#7">employee</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">数据库管理系统
</p>
</td>
<td width="75%">
<p align="left">Microsoft SQL Server 2000
</p>
</td>
</tr>
</table><br />
<h3>
<a name="9">表格员工的代码预览</a>
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.FamillyInfo<br />
drop constraint FK_FAMILLYI_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.JobInfo<br />
drop constraint FK_JOBINFO_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.Exprience<br />
drop constraint FK_EXPRIENC_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.Account<br />
drop constraint FK_ACCOUNT_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.Employee_Job<br />
drop constraint FK_EMPLOYEE_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.Adjustment<br />
drop constraint FK_ADJUSTME_REFERENCE_EMPLOYEE<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_birthday_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_birthday_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_degree_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_degree_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_deptid_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_deptid_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_email_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_email_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_empName_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_empName_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_IDCard_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_IDCard_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_major_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_major_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_phone_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_phone_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_school_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_school_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_sex_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_sex_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysindexes<br />
where id = object_id('dbo.employee')<br />
and name = '_WA_Sys_startjob_72C60C4A'<br />
and indid > 0<br />
and indid < 255)<br />
drop index dbo.employee._WA_Sys_startjob_72C60C4A<br />
go<br />
<br />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('dbo.employee')<br />
and type = 'U')<br />
drop table dbo.employee<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: employee */<br />
/*==============================================================*/<br />
create table dbo.employee (<br />
emplyeeid int identity(1 , 1),<br />
deptid int null,<br />
empName varchar(20) null,<br />
sex char(2) null,<br />
birthday datetime null,<br />
school varchar(20) null,<br />
major varchar(10) null,<br />
degree int null,<br />
phone varchar(50) null,<br />
startjob datetime null,<br />
email varchar(50) null,<br />
IDCard varchar(50) null,<br />
constraint PK_EMPLOYEE primary key clustered (emplyeeid)<br />
on "PRIMARY"<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_birthday_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_birthday_72C60C4A on dbo.employee (<br />
birthday ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_degree_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_degree_72C60C4A on dbo.employee (<br />
degree ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<br />
/*==============================================================*/<br />
/* Index: _WA_Sys_deptid_72C60C4A */<br />
/*==============================================================*/<br />
create index _WA_Sys_deptid_72C60C4A on dbo.employee (<br />
deptid ASC<br />
)<br />
on "PRIMARY"<br />
go<br />
<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 />
</p>
</td></tr>
</table><br />
<h3>
<a name="10">表格员工的列清单</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">emplyeeid
</p>
</td>
<td>
<p align="left">emplyeeid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">所属部门
</p>
</td>
<td class="TD2">
<p align="left">deptid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">员工姓名
</p>
</td>
<td>
<p align="left">empName
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">性别
</p>
</td>
<td class="TD2">
<p align="left">sex
</p>
</td>
</tr>
<tr>
<td>
<p align="left">生日
</p>
</td>
<td>
<p align="left">birthday
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">毕业学校
</p>
</td>
<td class="TD2">
<p align="left">school
</p>
</td>
</tr>
<tr>
<td>
<p align="left">专业
</p>
</td>
<td>
<p align="left">major
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">学历
</p>
</td>
<td class="TD2">
<p align="left">degree
</p>
</td>
</tr>
<tr>
<td>
<p align="left">电话
</p>
</td>
<td>
<p align="left">phone
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">开始工作时间
</p>
</td>
<td class="TD2">
<p align="left">startjob
</p>
</td>
</tr>
<tr>
<td>
<p align="left">电子邮件
</p>
</td>
<td>
<p align="left">email
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">身份证
</p>
</td>
<td class="TD2">
<p align="left">IDCard
</p>
</td>
</tr>
</table><br />
<h3>
<a name="11">表格员工的键清单</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>
<td class="Header">
<p align="center">主要的
</p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -