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