31 lines
1.5 KiB
SQL
31 lines
1.5 KiB
SQL
CREATE TABLE CAPLICINFO(
|
|
LOG_NO VARCHAR2(18) NOT NULL,
|
|
LIC_NO VARCHAR2(18) NOT NULL,
|
|
CORG_NO VARCHAR2(10) NOT NULL,
|
|
CAP_TYP VARCHAR2(50) NOT NULL,
|
|
LIC_NAME VARCHAR2(50) NOT NULL,
|
|
CRE_DT VARCHAR2(8) DEFAULT '',
|
|
CRE_TM VARCHAR2(6) DEFAULT '',
|
|
IS_USED VARCHAR2(2) DEFAULT 'N',
|
|
LIC_VAR VARCHAR2(256) DEFAULT '',
|
|
VAR_NUM VARCHAR2(512) DEFAULT '',
|
|
FORCE_COVER VARCHAR2(2) DEFAULT 'N',
|
|
LIC_DESC VARCHAR2(256) DEFAULT '',
|
|
TM_SMP VARCHAR2(26) DEFAULT ''
|
|
);
|
|
ALTER TABLE CAPLICINFO ADD CONSTRAINT CAPLICINFO_PK PRIMARY KEY (LOG_NO) USING INDEX;
|
|
COMMENT ON TABLE CAPLICINFO IS '场景变量明细表';
|
|
COMMENT ON COLUMN CAPLICINFO.LOG_NO IS '流水号';
|
|
COMMENT ON COLUMN CAPLICINFO.LIC_NO IS '与总表中唯一流水号对应';
|
|
COMMENT ON COLUMN CAPLICINFO.CORG_NO IS '合作机构';
|
|
COMMENT ON COLUMN CAPLICINFO.CAP_TYP IS '业务类型';
|
|
COMMENT ON COLUMN CAPLICINFO.LIC_NAME IS '场景名称';
|
|
COMMENT ON COLUMN CAPLICINFO.CRE_DT IS '创建日期';
|
|
COMMENT ON COLUMN CAPLICINFO.CRE_TM IS '创建时间';
|
|
COMMENT ON COLUMN CAPLICINFO.IS_USED IS '是否启用 Y 启用 N 未启用';
|
|
COMMENT ON COLUMN CAPLICINFO.LIC_VAR IS '场景变量';
|
|
COMMENT ON COLUMN CAPLICINFO.VAR_NUM IS '变量赋值';
|
|
COMMENT ON COLUMN CAPLICINFO.FORCE_COVER IS '变量赋值是否强行覆盖变量实值 Y 覆盖 N 不覆盖';
|
|
COMMENT ON COLUMN CAPLICINFO.LIC_DESC IS '变量赋值说明';
|
|
COMMENT ON COLUMN CAPLICINFO.TM_SMP IS '时间戳';
|