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