USE [lyfz]
GO
/****** 表中文名：lyfz员工信息 ******/
/****** 对象:  Table [dbo].[lyfzEmployeeInfo]    脚本日期: 08/20/2014 20:06:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[lyfzEmployeeInfo](					
	[employee_id] [varchar](50) NOT NULL,					/* 员工id(id编号方式:另定) */
	[employee_name] [varchar](50) NULL,						/* 员工姓名 */
	[employee_sex] [varchar](50) NULL,						/* 员工性别 */
	[employee_identityCard]	[varchar](50) NULL,				/* 员工身份证 */
	[employee_nativePlace][varchar](50)NULL,				/* 员工籍贯 */
	[employee_dept][varchar](50)NULL,						/* 员工部门 */
	/* 部门职位 */
	[employee_phone][varchar](50)NULL,						/* 员工电话*/
	[employee_QQ][varchar](50)NULL,							/* 员工QQ */
	[employee_maritalStatus][varchar](50)NULL,				/* 员工婚否 */
	[employee_currentAddress][varchar](50)NULL,				/* 员工现居地址 */
	[employee_incumbency][varchar](50)NULL,					/* 在职否 */
	[employee_entryTime][varchar](50)NULL,					/* 入职时间 */
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_][varchar](50)NULL,
	[employee_remarks] [varchar](50) NULL,					/* 备注 */

) ON [PRIMARY]

GO
SET ANSI_PADDING OFF