oracle 新建表 主键 序列 注释

CREATE TABLE ORG_BASE_HIS(
ID NUMBER NOT NULL,
DATA_ID NUMBER NOT NULL,
DATA_MSG NVARCHAR2(2000) NOT NULL,
TYPE CHAR(1) NOT NULL,
"COMCREATEUSER" NUMBER NULL ,
"COMCREATETIME" TIMESTAMP(6)  DEFAULT sysdate  NULL ,
"COMUPDATEUSER" NUMBER NULL ,
"COMUPDATETIME" TIMESTAMP(6)  DEFAULT sysdate  NULL
);


COMMENT ON TABLE ORG_BASE_HIS IS '基础数据历史表';
COMMENT ON COLUMN ORG_BASE_HIS.ID IS '主键';
COMMENT ON COLUMN ORG_BASE_HIS.DATA_ID IS '数据ID';
COMMENT ON COLUMN ORG_BASE_HIS.DATA_MSG IS '数据信息';
COMMENT ON COLUMN ORG_BASE_HIS.TYPE IS '1.部门 2.人员';


ALTER TABLE ORG_BASE_HIS ADD CONSTRAINT JX_ORG_BASE_HIS_PK PRIMARY KEY (ID);


CREATE SEQUENCE ORG_BASE_HIS_S
MINVALUE 1
MAXVALUE 999999999999999999999999
START WITH 2
INCREMENT BY 1
CACHE 20;