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;
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;