31 lines
1.4 KiB
SQL
31 lines
1.4 KiB
SQL
CREATE TABLE CAPMERCDEF(
|
|
MERC_ID VARCHAR2(15) NOT NULL,
|
|
CRE_DT VARCHAR2(8) DEFAULT '',
|
|
CRE_TM VARCHAR2(6) DEFAULT '',
|
|
TXN_CNL VARCHAR2(10) NOT NULL,
|
|
CAP_TYP VARCHAR2(50) DEFAULT '' NOT NULL,
|
|
LIC_NAME VARCHAR2(50) ,
|
|
IS_CARD_D VARCHAR2(2) DEFAULT 'N',
|
|
IS_CARD_C VARCHAR2(2) DEFAULT 'N',
|
|
IS_CARD_SC VARCHAR2(2) DEFAULT 'N',
|
|
IS_OTH_CARD_TYPE VARCHAR2(2) DEFAULT 'N',
|
|
REMACK VARCHAR2(512) DEFAULT '',
|
|
TM_SMP VARCHAR2(26) DEFAULT ''
|
|
);
|
|
ALTER TABLE CAPMERCDEF ADD CONSTRAINT CAPMERCDEF_PK PRIMARY KEY (MERC_ID,TXN_CNL,CAP_TYP) USING INDEX;
|
|
COMMENT ON TABLE CAPMERCDEF IS '商户默认场景信息表';
|
|
COMMENT ON COLUMN CAPMERCDEF.MERC_ID IS '商户号';
|
|
COMMENT ON COLUMN CAPMERCDEF.CRE_DT IS '创建日期';
|
|
COMMENT ON COLUMN CAPMERCDEF.CRE_TM IS '创建时间';
|
|
COMMENT ON COLUMN CAPMERCDEF.TXN_CNL IS '渠道标志';
|
|
COMMENT ON COLUMN CAPMERCDEF.CAP_TYP IS '业务类型';
|
|
COMMENT ON COLUMN CAPMERCDEF.LIC_NAME IS '默认应用场景';
|
|
COMMENT ON COLUMN CAPMERCDEF.IS_CARD_D IS '是否支持借记卡';
|
|
COMMENT ON COLUMN CAPMERCDEF.IS_CARD_C IS '是否支持贷记卡';
|
|
COMMENT ON COLUMN CAPMERCDEF.IS_CARD_SC IS '是否支持准贷记卡 ';
|
|
COMMENT ON COLUMN CAPMERCDEF.IS_OTH_CARD_TYPE IS '其他卡类型';
|
|
COMMENT ON COLUMN CAPMERCDEF.REMACK IS '备注';
|
|
COMMENT ON COLUMN CAPMERCDEF.TM_SMP IS '时间戳';
|
|
|
|
|