use HrMan
CREATE TABLE [dbo].[awardpunish] (
[ap_id] [int] IDENTITY (1, 1) NOT NULL ,
[ap_empCode] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ap_date] [datetime] NULL ,
[ap_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ap_byWhom] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[AP_Comment] [char] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
create table Department (
dept_Id int IDENTITY (1, 1) not null,
dept_Name char(50) not null,
dept_Code char(10) not null,
dept_Leader char(10) not null,
dept_Office char(200) null,
dept_Tel char(25) null,
dept_Fax char(25) null,
dept_Description text null,
constraint PK_DEPARTMENT primary key (dept_Id)
)
go
CREATE TABLE [dbo].[dip_code] (
[dip_code] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[dip_desc] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
create table emp_relation (
rel_id int identity(1,1) not null,
poli_code char(1) null,
rel_empCode char(10) not null,
rel_CountPart char(10) null,
rel_relation char(10) null,
rel_Political char(1) null,
rel_Unit char(30) null,
rel_Title char(10) null,
rel_Access char(30) null,
constraint PK_EMP_RELATION primary key (rel_id)
)
go
CREATE TABLE [dbo].[Employee] (
[emp_Id] [int] IDENTITY (1, 1) NOT NULL ,
[emp_Code] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[emp_Name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[emp_IdNum] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_sex_Code] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_dept_Code] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_dipl_Code] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_home_Code] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_title_Code] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_homeTel] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_officeTel] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_mobilePhone] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_level_Code] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_pager] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_birthdate] [datetime] NULL ,
[emp_totalWorkyear] [int] NULL ,
[emp_address] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_postcode] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_status] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_nation] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_marrige] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_political] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_gschool] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[emp_major] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[experience] (
[exp_id] [int] IDENTITY (1, 1) NOT NULL ,
[exp_empCode] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[exp_Unit] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[exp_startDate] [datetime] NULL ,
[exp_endDate] [datetime] NULL ,
[exp_desc] [char] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[exp_quitReason] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[home_code] (
[home_code] [char] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[home_desc] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[level_code] (
[lev_code] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[lev_desc] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[marriage] (
[marriage_code] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[marriage_desc] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[nation_code] (
[nation_code] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[nation_desc] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[PoliCode] (
[poli_code] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[poli_desc] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[sex_code] (
[sex_code] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[sex_desc] [char] (2) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[status_code] (
[status_code] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[status_desc] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[title_code] (
[title_code] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[title_desc] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
