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