19 lines
945 B
SQL
19 lines
945 B
SQL
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 '时间戳';
|