CREATE TABLE CAPLICDATA (
	CRE_DT 			 VARCHAR2(8)   DEFAULT '',
	CRE_TM 			 VARCHAR2(6)   DEFAULT '',
	CAP_TYP 	         VARCHAR2(50)  NOT NULL,
	LIC_NAME 		 VARCHAR2(50)  NOT NULL,
	LIC_DESC 		 VARCHAR2(512) DEFAULT '', 
	IS_USED  		 VARCHAR2(2)   DEFAULT 'N',
	REMACK 			 VARCHAR2(128) DEFAULT '',
	TM_SMP                   VARCHAR2(26)  DEFAULT ''
);
ALTER TABLE CAPLICDATA ADD CONSTRAINT CAPLICDATA_PK PRIMARY KEY (CAP_TYP,LIC_NAME) USING INDEX;
COMMENT ON TABLE CAPLICDATA IS '应用场景基本信息表';
COMMENT ON COLUMN CAPLICDATA.CRE_DT IS '创建日期';
COMMENT ON COLUMN CAPLICDATA.CRE_TM IS '创建时间';
COMMENT ON COLUMN CAPLICDATA.CAP_TYP IS '业务类型';
COMMENT ON COLUMN CAPLICDATA.LIC_NAME IS '场景名称';
COMMENT ON COLUMN CAPLICDATA.LIC_DESC IS '场景说明';
COMMENT ON COLUMN CAPLICDATA.IS_USED IS '是否生效 Y 生效 N 无效';
COMMENT ON COLUMN CAPLICDATA.REMACK IS '备用字段';
COMMENT ON COLUMN CAPLICDATA.TM_SMP IS '时间戳';