CREATE TABLE [dbo].[person_t](
[rowId] [int] IDENTITY(1,1) NOT NULL,
[档案号] [int] NULL,
[身份证] [nvarchar](18) NULL,
[身份证有效期] [date] NULL,
[姓名] [nvarchar](40) NULL,
[性别] [nvarchar](20) NULL,
[籍贯] [nvarchar](400) NULL,
[出生年月日] [date] NULL,
[年龄] [decimal](4, 1) NULL,
[民族] [nvarchar](40) NULL,
[学历] [nvarchar](200) NULL,
[婚姻状况] [nvarchar](20) NULL,
[管理层级] [nvarchar](40) NULL,
[人力分类] [nvarchar](40) NULL,
[身份证地址] [nvarchar](400) NULL,
[现住址] [nvarchar](200) NULL,
[联系电话] [nvarchar](200) NULL,
[部门] [nvarchar](200) NULL,
[车间] [nvarchar](200) NULL,
[职位] [nvarchar](200) NULL,
[职称] [nvarchar](200) NULL,
[入职日期] [date] NULL,
[试用期月数] [int] NULL,
[预计转正日期] [date] NULL,
[实际转正日期] [date] NULL,
[在职状态] [nvarchar](200) NULL,
[离职日期] [date] NULL,
[外语证书] [nvarchar](200) NULL,
[计算机证书] [nvarchar](200) NULL,
[其他证书] [nvarchar](200) NULL,
[是否有社保] [nvarchar](200) NULL,
[是否有公积金] [nvarchar](200) NULL,
[专业] [nvarchar](200) NULL,
[毕业学校] [nvarchar](200) NULL,
[紧急联系人] [nvarchar](200) NULL,
[紧急联系电话] [nvarchar](200) NULL,
[照片] [image] NULL,
[教育经历] [nvarchar](max) NULL,
[工作经历] [nvarchar](max) NULL,
[岗位异动备注] [nvarchar](200) NULL,
[备注] [nvarchar](200) NULL,
[inputdate] [datetime] NULL CONSTRAINT [DF__person_t__inputd__398D8EEE] DEFAULT (getdate()),
[update_by] [nvarchar](500) NULL,
CONSTRAINT [PK__person_t__4B58DB8091C127A5] PRIMARY KEY CLUSTERED
(
[rowId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
可以自己改改，改为适合你的即可！ 编辑于 2019-9-1 22:44
|
