CREATE TABLE CAPBANKCOL(
	CORG_NO          VARCHAR2(12)    NOT NULL,
        CAP_TYP     	 VARCHAR2(50)    NOT NULL,
	LIC_VAR          VARCHAR2(256)   DEFAULT '',
	LIC_LOC_NAM      VARCHAR2(128)   DEFAULT '',
	LIC_VALUE        VARCHAR2(128)   DEFAULT '',
	LIC_DESC         VARCHAR2(256)   DEFAULT '',
	TM_SMP           VARCHAR2(26)    DEFAULT ''
);
ALTER TABLE CAPBANKCOL ADD CONSTRAINT CAPBANKCOL_PK PRIMARY KEY (CORG_NO,CAP_TYP,LIC_VAR) USING INDEX;
COMMENT ON TABLE CAPBANKCOL IS '银行场景变量库表';
COMMENT ON COLUMN CAPBANKCOL.CORG_NO IS '机构编号';
COMMENT ON COLUMN CAPBANKCOL.CAP_TYP IS '业务类型';
COMMENT ON COLUMN CAPBANKCOL.LIC_VAR IS '场景变量';
COMMENT ON COLUMN CAPBANKCOL.LIC_LOC_NAM IS '本地系统变量命名';
COMMENT ON COLUMN CAPBANKCOL.LIC_VALUE IS '变量默认值';
COMMENT ON COLUMN CAPBANKCOL.LIC_DESC IS '变量赋值说明';
COMMENT ON COLUMN CAPBANKCOL.TM_SMP IS '时间戳';