awardpunish.sql

来自「分为基本数据录入、部门管理、人事管理、代码维护等。」· SQL 代码 · 共 10 行

CREATE TABLE [dbo].[awardpunish] (
	[ap_id] [int] IDENTITY (1, 1) NOT NULL ,
	[ap_empCode] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ap_date] [datetime] NULL ,
	[ap_type] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ap_byWhom] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[AP_Comment] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO