23 lines
1.1 KiB
SQL
23 lines
1.1 KiB
SQL
CREATE TABLE CAPLICTOL(
|
|
LIC_NO VARCHAR2(18) NOT NULL,
|
|
CAP_TYP VARCHAR2(50) NOT NULL,
|
|
LIC_NAME VARCHAR2(50) NOT NULL,
|
|
CORG_NO VARCHAR2(10) NOT NULL,
|
|
IS_DEFAULT VARCHAR2(2) DEFAULT 'N' NOT NULL,
|
|
CRE_DT VARCHAR2(8) DEFAULT '',
|
|
CRE_TM VARCHAR2(6) DEFAULT '',
|
|
CORG_DESC VARCHAR2(512) DEFAULT '',
|
|
TM_SMP VARCHAR2(26) DEFAULT ''
|
|
);
|
|
ALTER TABLE CAPLICTOL ADD CONSTRAINT CAPLICTOL_PK PRIMARY KEY (CAP_TYP,LIC_NAME,CORG_NO) USING INDEX;
|
|
COMMENT ON TABLE CAPLICTOL IS '场景变量汇总信息表';
|
|
COMMENT ON COLUMN CAPLICTOL.LIC_NO IS '唯一序号，关联场景变量总表与明细表';
|
|
COMMENT ON COLUMN CAPLICTOL.CORG_NO IS '机构编码';
|
|
COMMENT ON COLUMN CAPLICTOL.CAP_TYP IS '业务类型';
|
|
COMMENT ON COLUMN CAPLICTOL.LIC_NAME IS '场景名称';
|
|
COMMENT ON COLUMN CAPLICTOL.IS_DEFAULT IS '是否默认';
|
|
COMMENT ON COLUMN CAPLICTOL.CRE_DT IS '创建日期';
|
|
COMMENT ON COLUMN CAPLICTOL.CRE_TM IS '创建时间';
|
|
COMMENT ON COLUMN CAPLICTOL.CORG_DESC IS '场景设置说明';
|
|
COMMENT ON COLUMN CAPLICTOL.TM_SMP IS '时间戳';
|