32 lines
1.3 KiB
Markdown
32 lines
1.3 KiB
Markdown
URL：https://api-gateway-qa.meiqia.cn/sp/unauth/auth/wx-callback
|
||
|
||
|
||
```sql
|
||
CREATE TABLE `luoke_auth_info` (
|
||
`id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
|
||
`ent_id` BIGINT NOT NULL,
|
||
`user_id` VARCHAR(64) NOT NULL,
|
||
`device_id` VARCHAR(64) NOT NULL DEFAULT '',
|
||
`corp_id` VARCHAR(64) NOT NULL DEFAULT '',
|
||
`nickname` VARCHAR(255) NOT NULL DEFAULT '',
|
||
`avatar` VARCHAR(512) NOT NULL DEFAULT '',
|
||
`region` VARCHAR(64) NOT NULL DEFAULT '',
|
||
`deleted_at` BIGINT NOT NULL DEFAULT 0,
|
||
`created_at` BIGINT NOT NULL DEFAULT 0,
|
||
`updated_at` BIGINT NOT NULL DEFAULT 0,
|
||
PRIMARY KEY (`id`),
|
||
UNIQUE KEY `uniq_luoke_auth_ent_user` (`ent_id`, `user_id`),
|
||
KEY `idx_luoke_auth_user_id` (`user_id`)
|
||
) ;
|
||
|
||
CREATE TABLE `luoke_fansinfo` (
|
||
`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
|
||
`ent_id` BIGINT NOT NULL COMMENT '企业ID',
|
||
`sub_source` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '子来源',
|
||
`sender` BIGINT UNSIGNED NOT NULL COMMENT '发送者ID',
|
||
`client_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '客户端ID',
|
||
`created_at` BIGINT NOT NULL DEFAULT 0 COMMENT '创建时间',
|
||
`updated_at` BIGINT NOT NULL DEFAULT 0 COMMENT '更新时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Luoke粉丝信息表';
|
||
``` |