employees.sql

来自「开发人力资源管理系统的目的就是帮助企业的人力资源部门提高工作效率,实现企业认识信」· SQL 代码 · 共 38 行

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),
   Mini			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),
  )