📄 repo1.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>
<h1>
<a name="2">人事管理系统数据库设计<br />
</a>
</h1>
<h3>
<a name="3">人事管理系统代码总览</a>
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.Account<br />
drop constraint FK_ACCOUNT_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.Adjustment<br />
drop constraint FK_ADJUSTME_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.Department_Job<br />
drop constraint FK_DEPARTME_REFERENCE_DEPARTME<br />
go<br />
<br />
alter table dbo.Department_Job<br />
drop constraint FK_DEPARTME_REFERENCE_POST<br />
go<br />
<br />
alter table dbo.Employee_Job<br />
drop constraint FK_EMPLOYEE_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.Employee_Job<br />
drop constraint FK_EMPLOYEE_REFERENCE_POST<br />
go<br />
<br />
alter table dbo.Exprience<br />
drop constraint FK_EXPRIENC_REFERENCE_EMPLOYEE<br />
go<br />
<br />
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 />
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.Account')<br />
and type = 'U')<br />
drop table dbo.Account<br />
go<br />
<br />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('dbo.Adjustment')<br />
and type = 'U')<br />
drop table dbo.Adjustment<br />
go<br />
<br />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('dbo.Department')<br />
and type = 'U')<br />
drop table dbo.Department<br />
go<br />
<br />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('dbo.Department_Job')<br />
and type = 'U')<br />
drop table dbo.Department_Job<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 />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('dbo.Employee_Job')<br />
and type = 'U')<br />
drop table dbo.Employee_Job<br />
go<br />
<br />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('dbo.Exprience')<br />
and type = 'U')<br />
drop table dbo.Exprience<br />
go<br />
<br />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('dbo.FamillyInfo')<br />
and type = 'U')<br />
drop table dbo.FamillyInfo<br />
go<br />
<br />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('dbo.JobInfo')<br />
and type = 'U')<br />
drop table dbo.JobInfo<br />
go<br />
<br />
if exists (select 1<br />
from sysobjects<br />
where id = object_id('post')<br />
and type = 'U')<br />
drop table post<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Account */<br />
/*==============================================================*/<br />
create table dbo.Account (<br />
uid int identity(1 , 1),<br />
employeeid int null,<br />
username varchar(20) null,<br />
password varchar(20) null,<br />
email varchar(100) null,<br />
inactive char(1) null,<br />
constraint PK_ACCOUNT primary key clustered (uid)<br />
on "PRIMARY"<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Adjustment */<br />
/*==============================================================*/<br />
create table dbo.Adjustment (<br />
oid int identity(1 , 1),<br />
empid int null,<br />
adjustDate datetime null,<br />
origindeptid int null,<br />
destdeptid int null,<br />
originjobid int null,<br />
destjobid int null,<br />
reason varchar(100) null,<br />
constraint PK_ADJUSTMENT primary key clustered (oid)<br />
on "PRIMARY"<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Department */<br />
/*==============================================================*/<br />
create table dbo.Department (<br />
oid int identity(1 , 1),<br />
parentoid int null,<br />
deptName varchar(20) null,<br />
phone varchar(20) null,<br />
email varchar(100) null,<br />
fax varchar(20) null,<br />
manager int null,<br />
address varchar(100) null,<br />
zipcode varchar(10) null,<br />
status char(1) null,<br />
description varchar(100) null,<br />
constraint PK_DEPARTMENT primary key clustered (oid)<br />
on "PRIMARY"<br />
)<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Department_Job */<br />
/*==============================================================*/<br />
create table dbo.Department_Job (<br />
deptid int null,<br />
jobid int null<br />
)<br />
on "PRIMARY"<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 />
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -