编号：时间：2021年x月x日书山有路勤为径，学海无涯苦作舟页码：第1页 共1页第十六章 求职招聘系统16.2 数据的设计与基本配置16.2.1 数据的设计本系统数据库系统采用MS－SQLServer 2000 SP4（简体中文版），设定数据库服务器名为“ZUT-GYF”，使用企业管理器新建一个数据库，命名为myjobs根据需求分析，系统共需要7个数据表，表结构内容以及建立步骤如下：（1）myjobs_jobkinds数据表该数据表用户保存系统工作类别，共有两个字段（ID，jobkinds），生成该数据表的SQL脚本语句如下：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[myjobs_jobkinds]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[myjobs_jobkinds]GOCREATE TABLE [dbo].[myjobs_jobkinds] ( [id] [int] IDENTITY (1, 1) NOT NULL , [jobkinds] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY]GO（2）myjobs_cominfor数据表该数据表用户保存企业会员信息，包括ID，企业名称，企业信息，密码等相关信息，共有9个字段（ID，comid，pwd，comname，tel，email，cominfor，regdate，address），生成该数据表的SQL脚本语句如下：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[myjobs_cominfor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[myjobs_cominfor]GOCREATE TABLE [dbo].[myjobs_cominfor] ( [id] [int] IDENTITY (1, 1) NOT NULL , [comid] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , [comname] [nchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [cominfor] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL , [email] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [tel] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [pwd] [char] (32) COLLATE Chinese_PRC_CI_AS NOT NULL , [regdate] [datetime] NOT NULL , [address] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO（3）myjobs_userinfor数据表该数据表用于保存普通会员注册信息，包括ID，用户姓名，密码等相关信息，共包含20个字段（ID，userid，username，pwd，tel，sex，email，edu，degree，wantjob等），生成该数据表的SQL语句如下：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[myjobs_userinfor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[myjobs_userinfor]GOCREATE TABLE [dbo].[myjobs_userinfor] ( [id] [int] IDENTITY (1, 1) NOT NULL , [userid] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , [pwd] [char] (32) COLLATE Chinese_PRC_CI_AS NOT NULL , [email] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [tel] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [sex] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [edutime] [datetime] NOT NULL , [school] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [brithday] [datetime] NOT NULL , [pic] [char] (40) COLLATE Chinese_PRC_CI_AS NOT NULL , [wantmoney] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [major] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [express] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL , [myself] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL , [login] [int] NOT NULL , [passportkinds] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [passportNo] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [username] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL , [degree] [int] NOT NULL , [wantjob] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO(4) myjobs_newjobs数据表该数据表用户保存企业发布的招聘职位，包括职位ID，职位名称，招聘人数，招聘公司等，共包含11个字段（ID，comid ，jobname等），生成该数据表的SQL语句如下：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[myjobs_newjobs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[myjobs_newjobs]GOCREATE TABLE [dbo].[myjobs_newjobs] ( [id] [int] IDENTITY (1, 1) NOT NULL , [comid] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , [jobkinds] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [jobname] [char] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [peoplecount] [int] NOT NULL , [request] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL , [pubtime] [datetime] NOT NULL , [endtime] [datetime] NOT NULL , [jobpay] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , [degrequest] [int] NOT NULL , [jobstate] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO（5）myjobs_req_msg数据表该数据用户存储应聘记录，包括应聘职位，应聘人ID，申请日期等，同时根据标识字段，也存储用户收藏职位信息，在必要的时候发送应聘请求。
共包含8个字段（ID，jobid，usreid，comid，viewstate，userstate，comstate，sendtime），生成该数据表的SQL脚本语句如下：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[myjobs_req_msg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[myjobs_req_msg]GOCREATE TABLE [dbo].[myjobs_req_msg] ( [id] [int] IDENTITY (1, 1) NOT NULL , [userid] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , [comid] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL , [jobid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [viewstate] [int] NOT NULL , [sendtime] [datetime] NOT NULL , [usermsgstate] [int] NOT NULL , [commsgstate] [int] NOT NULL ) ON [PRIMARY]GO(6) myjobs_myhrmsg 数据表该数据用户保存普通会员的人事经理来信记录，一般为企业的面试邀请，包括普通会员ID，企业ID，发送日期等，共包含7个字段（ID，userid，comid等），生成改表的SQL脚本语句如下：if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[myjobs_myhrmsg]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[myjobs_myhrmsg]GOCREATE TABLE [dbo].[myjobs_myhrmsg] ( [id] [int] IDENTITY (1, 1) NOT NUL。