CREATE TABLE wechat_binding
(
WECHAT_BINDING_ID NUMBER(16) NOT NULL ,
DEVICE_NBR varchar2(250) DEFAULT NULL,
BINDING_CHANNEL_NBR varchar2(250) DEFAULT NULL,
BINDING_CHANNEL_NAME varchar2(250) DEFAULT NULL,
CREATE_DATE DATE DEFAULT NULL,
OPERATE_TIME DATE DEFAULT NULL,
TRANSACTION_ID varchar2(250) DEFAULT NULL,
DEVICE_TYPE varchar2(250) DEFAULT NULL,
OPEN_ID varchar2(1000) DEFAULT NULL,
UNION_ID varchar2(250) DEFAULT NULL,
O_ID varchar2(250) DEFAULT NULL,
FIRST_BINDING_TIME DATE DEFAULT NULL,
BINDING_STATUS varchar2(250) DEFAULT NULL,
STATUS_CD varchar2(250) DEFAULT NULL ,
PRIMARY KEY (WECHAT_BINDING_ID)
);
COMMENT ON COLUMN wechat_binding.WECHAT_BINDING_ID IS '微信绑定关系ID';
COMMENT ON COLUMN wechat_binding.DEVICE_NBR IS '设备号';
create index IDX_DEVICE_NBR on wechat_binding(DEVICE_NBR);