11 lines
634 B
SQL
11 lines
634 B
SQL
CREATE TABLE IF NOT EXISTS `recharge_agency_seller_info` (
|
|
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
|
`sys_origin` varchar(32) NOT NULL COMMENT '来源系统',
|
|
`user_id` bigint NOT NULL COMMENT '币商用户ID',
|
|
`whatsapp` varchar(64) NOT NULL DEFAULT '' COMMENT 'WhatsApp',
|
|
`create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',
|
|
`update_time` datetime(3) DEFAULT NULL COMMENT '更新时间',
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `uk_recharge_agency_seller_info_user` (`sys_origin`, `user_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充值代理币商扩展资料';
|