createtable2.sql

来自「该章文件夹Chap2下存放的都是SQL脚本文件」· SQL 代码 · 共 15 行

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