16 lines
850 B
MySQL
16 lines
850 B
MySQL
|
-- 盈利计划独立表
|
||
|
|
CREATE TABLE IF NOT EXISTS coin_profit_schedule (
|
||
|
|
id bigint(20) NOT NULL AUTO_INCREMENT,
|
||
|
|
coin_id bigint(20) NOT NULL COMMENT '币种ID',
|
||
|
|
profit_date date NOT NULL COMMENT '盈利计划日期',
|
||
|
|
profit_per_thousand decimal(10,2) NOT NULL COMMENT '每1000U盈利金额',
|
||
|
|
status tinyint(1) NOT NULL DEFAULT 0 COMMENT '0-待执行 1-已执行 2-已取消',
|
||
|
|
actual_profit_rate decimal(12,8) DEFAULT NULL COMMENT '实际执行比率(自动回填)',
|
||
|
|
admin_id bigint(20) DEFAULT NULL COMMENT '操作管理员',
|
||
|
|
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
update_time datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
|
||
|
|
PRIMARY KEY (id),
|
||
|
|
UNIQUE KEY uk_coin_date (coin_id, profit_date),
|
||
|
|
KEY idx_profit_date (profit_date)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='平台代币盈利计划表';
|