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