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 '时间戳';