-- 跟单佣金：LEGACY 逐笔盈利分成 | MONTHLY_FIXED 月固定 | DAILY_PROFIT_PCT 按自然日汇总已实现盈亏后抽成
|
ALTER TABLE T_TRADER
|
ADD COLUMN FOLLOW_COMMISSION_TYPE VARCHAR(32) NOT NULL DEFAULT 'LEGACY' COMMENT '跟单佣金类型',
|
ADD COLUMN FOLLOW_COMMISSION_MONTHLY_AMOUNT DECIMAL(32, 16) NOT NULL DEFAULT 0 COMMENT '月固定跟单费(USDT)',
|
ADD COLUMN FOLLOW_COMMISSION_DAILY_PCT DOUBLE NOT NULL DEFAULT 0 COMMENT '按日总盈利提成比例 0~1';
|
|
ALTER TABLE T_TRADER_FOLLOW_USER
|
ADD COLUMN MONTHLY_FEE_PAID_PERIOD VARCHAR(7) NULL COMMENT '已缴月费周期 yyyy-MM';
|
|
CREATE TABLE IF NOT EXISTS T_TRADER_FOLLOW_DAILY_PNL (
|
UUID VARCHAR(64) NOT NULL PRIMARY KEY COMMENT '主键',
|
PARTY_ID VARCHAR(64) NOT NULL COMMENT '跟随者',
|
TRADER_PARTY_ID VARCHAR(64) NOT NULL COMMENT '带单员',
|
PNL_DATE DATE NOT NULL COMMENT '盈亏归属自然日(平仓时间, 服务器默认时区)',
|
REALIZED_PROFIT_SUM DECIMAL(32, 16) NOT NULL DEFAULT 0 COMMENT '当日已实现盈亏合计(可负)',
|
SETTLED TINYINT NOT NULL DEFAULT 0 COMMENT '0未结算 1已结算',
|
COMMISSION_AMOUNT DECIMAL(32, 16) NOT NULL DEFAULT 0 COMMENT '实际抽取给带单员的金额',
|
CREATE_TIME DATETIME NULL,
|
UPDATE_TIME DATETIME NULL,
|
CREATE_TIME_TS BIGINT NULL,
|
UPDATE_TIME_TS BIGINT NULL,
|
CREATE_BY VARCHAR(64) NULL,
|
UPDATE_BY VARCHAR(64) NULL,
|
DEL_FLAG TINYINT NOT NULL DEFAULT 0,
|
UNIQUE KEY UK_FOLLOW_DAILY (PARTY_ID, TRADER_PARTY_ID, PNL_DATE)
|
) COMMENT='跟单按日已实现盈亏汇总(用于日提成)';
|
