createtable2.sql

该章文件夹Chap2下存放的都是SQL脚本文件

USE PERSONNEL_SYS1
CREATE TABLE REWARD_PUN
(RECORD_ID bigint IDENTITY (1, 1) NOT NULL ,
WORKER_ID nvarchar (15) COLLATE Chinese_PRC_CI_AS NULL ,
WORKER_NAME nvarchar (8) COLLATE Chinese_PRC_CI_AS NULL ,
  RECORD_DATE datetime NULL, 
  RECORD_TYPE nvarchar (2) COLLATE Chinese_PRC_CI_AS NULL ,
RECORD_CONTENT nvarchar (30) COLLATE Chinese_PRC_CI_AS NULL ,
  RECORD_REASON nvarchar (30) COLLATE Chinese_PRC_CI_AS NULL ,
  ALLOW_UNIT nvarchar (20) COLLATE Chinese_PRC_CI_AS NULL ,
REMARK nvarchar (255) COLLATE Chinese_PRC_CI_AS NULL
)
GO