employees.sql

财务管理系统 报账等基本功能实现 有完整的实现

USE Mis
GO
CREATE TABLE [Employees] (
	[EmpId] [int] IDENTITY (1, 1) NOT NULL ,
	[EmpName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Sex] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Nationality] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Birth] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Academic] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Marital] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Original] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Id_Card] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Office_phone] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mobile] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[HireDate] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[DepId] [int] NULL ,
	[Title] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[State] [tinyint] NULL ,
	[Salary] [int] NULL ,
	[Memo] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO