16 lines
1.0 KiB
SQL
16 lines
1.0 KiB
SQL
CREATE TABLE IF NOT EXISTS douyin_reward_logs (
|
|
id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID',
|
|
shop_order_id VARCHAR(64) NOT NULL DEFAULT '' COMMENT '抖店订单号',
|
|
douyin_user_id VARCHAR(128) NOT NULL DEFAULT '' COMMENT '抖音用户ID',
|
|
local_user_id BIGINT NOT NULL DEFAULT 0 COMMENT '本地用户ID',
|
|
douyin_product_id VARCHAR(64) NOT NULL DEFAULT '' COMMENT '抖店商品ID',
|
|
prize_id BIGINT NOT NULL DEFAULT 0 COMMENT '直播奖品ID(可选)',
|
|
source VARCHAR(32) NOT NULL DEFAULT '' COMMENT '来源: auto/manual/dispatch',
|
|
status VARCHAR(32) NOT NULL DEFAULT '' COMMENT '状态: success/failed/skipped',
|
|
message VARCHAR(255) NOT NULL DEFAULT '' COMMENT '说明信息',
|
|
extra JSON NULL COMMENT '扩展信息',
|
|
created_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='抖店发奖日志';
|
|
|
|
CREATE INDEX idx_douyin_reward_logs_order ON douyin_reward_logs (shop_order_id, created_at);
|