(
[nation] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [political] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [height] [int] NULL, [age] [int] NULL,
[origin] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [marriage] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [place] [varchar](200) COLLATE Chinese_PRC_CI_AS NULL, [card] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [school] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [education] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [time] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [subject] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [chinese] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [dialect] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [fforeign] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [sforeign] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [standard] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [computer] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [speciality] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [phone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [telephone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [title] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [regulardate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [workdata] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [subject1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [tphone1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [teacher1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [time1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [school1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [education1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [tphone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [teacher] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [remarks] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [resumetime] [datetime] NULL,
CONSTRAINT [PK_persondata] PRIMARY KEY CLUSTERED
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO
SET ANSI_PADDING OFF
②培训档案表(traindata)：ID,名称 USE [humanmanage]
1
GO
/****** 对象: Table [dbo].[traindata] 脚本日期: 03/07/2012 19:43:27 ******/
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[traindata]( (
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF GO
USE [humanmanage] GO
ALTER TABLE [dbo].[traindata] WITH CHECK ADD CONSTRAINT [FK_traindata_traindata] FOREIGN KEY([id])
REFERENCES [dbo].[traindata] ([id]) [id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL, [type] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [department] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [position] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [time] [datetime] NULL,
[unit] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [topical] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [grade] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [certificate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [tripcost] [money] NULL, [traincost] [money] NULL,
[remarks] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_traindata] PRIMARY KEY CLUSTERED
③薪资变动职位晋升表(salarydata)：ID,名称
USE [humanmanage]
GO
/****** 对象: Table [dbo].[salarydata] 脚本日期: 03/07/2012 19:44:52 ******/
SET ANSI_NULLS ON GO
1
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[salarydata]( (
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [department] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [employdate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [sprobationdate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [eprobationdate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [prosalary] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [regulardate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [contractdate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [salarydate] [datetime] NULL, [risedate] [datetime] NULL,
[contractperiod] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [fposition] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [sposition] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [fsalary] [int] NULL, [ssalary] [int] NULL,
[reason] [varchar](500) COLLATE Chinese_PRC_CI_AS NULL, [remarks] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_salarydata] PRIMARY KEY CLUSTERED
④职业生涯规划表(careerdata)：Id,名称
USE [humanmanage]
GO
/****** 对象: Table [dbo].[careerdata] 脚本日期: 03/07/2012 19:45:55 ******/
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[careerdata](
[id] [int] IDENTITY(1,1) NOT NULL,
1
(
[name] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [arrivedate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [department] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [nposition] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [selfvalue] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL, [ideal] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL, [wish] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL, [design] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL, [remarks] [varchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_careerdata] PRIMARY KEY CLUSTERED
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF
⑤家庭基本情况表 (homedata)：Id,名称 USE [humanmanage]
GO
/****** 对象: Table [dbo].[homedata] 脚本日期: 03/07/2012 19:46:59 ******/
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[homedata]( (
[homeid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF
[homeid] [int] IDENTITY(1,1) NOT NULL,
[name1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [job] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [homephone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [urgentphone] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [relation] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [homename] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_homedata] PRIMARY KEY CLUSTERED
1
⑥培训经历表(experiencedata)：
USE [humanmanage]
GO
/****** 对象: Table [dbo].[experiencedata] 脚本日期: 03/07/2012 19:48:38 ******/ SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[experiencedata]( (
[trainid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO
SET ANSI_PADDING OFF
[trainid] [int] IDENTITY(1,1) NOT NULL,
[name1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [traintime] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [trainname] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [certificate] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_experiencedata_1] PRIMARY KEY CLUSTERED
⑦个人荣誉表(honourdata)：
USE [humanmanage]
GO
/****** 对象: Table [dbo].[honourdata] 脚本日期: 03/07/2012 19:49:21 ******/
SET ANSI_NULLS ON GO
SET QUOTED_IDENTIFIER ON GO
SET ANSI_PADDING ON GO
CREATE TABLE [dbo].[honourdata]( (
[honourid] ASC
1
[honourid] [int] IDENTITY(1,1) NOT NULL,
[name1] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [honourtime] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL, [award] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_honourdata_1] PRIMARY KEY CLUSTERED