﻿CREATE TABLE [dbo].[UserCompany](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[gongsimingzi] [nvarchar](50) NOT NULL,
	[zhaopinleixing] [int] NOT NULL,
	[suoshuhangye] [nvarchar](50) NOT NULL,
	[gongsileixing] [nvarchar](50) NOT NULL,
	[gongsiguimo] [nvarchar](50) NOT NULL,
	[lianxiren] [nvarchar](50) NOT NULL,
	[lianxidianhua] [nvarchar](50) NOT NULL,
	[gongsiwagzhi] [nvarchar](50) NOT NULL,
	[gongsidizhi] [nvarchar](300) NOT NULL,
	[gongsijianjie] [nvarchar](3000) NOT NULL,
	[yingyezhizhao] [nvarchar](50) NOT NULL,
	[IsPass] [int] NOT NULL,
	[cityID] [int] NOT NULL,
 CONSTRAINT [PK_UserCompany] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
|
create trigger [dbo].[delcom]
on [dbo].[UserCompany]
for delete
as
delete PTJob where userid in (select userid from deleted)
|
CREATE TABLE [dbo].[UserResume](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [int] NOT NULL,
	[qiuzhiyixiang] [nvarchar](500) NOT NULL,
	[areaID] [int] NOT NULL,
	[zhiweixingzhi] [int] NOT NULL,
	[jianlibiaoti] [nvarchar](50) NOT NULL,
	[sex] [int] NOT NULL,
	[howold] [int] NOT NULL,
	[xueli] [int] NOT NULL,
	[gongzuonianxian] [nvarchar](50) NOT NULL,
	[zuijinzhiwei] [nvarchar](50) NOT NULL,
	[zaizhishijian] [nvarchar](50) NOT NULL,
	[ziwomiaoshu] [nvarchar](3000) NOT NULL,
	[lianxiren] [nvarchar](50) NOT NULL,
	[shouji] [nvarchar](50) NOT NULL,
	[dianhua] [nvarchar](50) NOT NULL,
	[qq] [nvarchar](50) NOT NULL,
	[youxiang] [nvarchar](50) NOT NULL,
	[IsPass] [int] NOT NULL,
	[cityID] [int] NOT NULL,
	[postdate] [datetime] NOT NULL,
	[JobNo] [nvarchar](50) NOT NULL CONSTRAINT [DF_UserResume_JobNo]  DEFAULT (''),
 CONSTRAINT [PK_UserResume] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
|
CREATE TABLE [dbo].[xueli](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[xueliStr] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_xueli] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
|
insert into xueli (xuelistr) values('初中及以下')
insert into xueli (xuelistr) values('高中/中专')
insert into xueli (xuelistr) values('大专')
insert into xueli (xuelistr) values('本科及以上')
