employees.sql

这是一个企业版的人力资源管理源码,很适合初级开发人员

CREATE TABLE Employees
  (Emp_Id	        Int Primary Key,
   Emp_NAME    		Varchar(50) NOT NULL,
   Photo		Image,
   Sex			Char(2),
   Nationality		Varchar(40),
   Birth		Varchar(20),
   Political_Party	Varchar(40),
   Culture_Level	Varchar(40),
   Marital_Condition	Varchar(20),
   Family_Place		Varchar(60),
   Id_Card		Varchar(20),
   PcID			Varchar(40),
   BadgeID		Varchar(40),
   Office_phone		Varchar(30),
   Home_phone		Varchar(30),
   Bp			Varchar(30),
   Mobile		Varchar(30),
   Files_Keep_Org	Varchar(100),
   Residence		Varchar(100),
   Hukou		Varchar(100),
   Postcode		Varchar(10),
   Police_Post		Varchar(50),
   Street_Office	Varchar(50),
   HireDate		Varchar(20),
   Working_Years	TinyInt,
   Dep_Id		SmallInt,
   Position		Varchar(40),
   Title		Varchar(20),
   State		TinyInt,
   UpperId		Int,
   Contract_Sign_Date	Varchar(20),
   Base_Wage		Decimal(10,2),
   Base_Prize   	Decimal(10,2),
   Memo			Varchar(200),
   Fillin_Person	Varchar(30),
   Fillin_Time		Varchar(20),
  )