Grand Prix
테이블 (4)
grand_prix
- id — 기본 키 — NOT NULL
- 대회명 (title)
- 시작일 (start_date)
- 종료일 (end_date)
- 총상금 (total_prize)
- 1등 (prize_1st)
- 2둥 (prize_2nd)
- 3등 (prize_3rd)
- 최소투자금액 (min_seed)
quantus_coin_accounts
- account_id — int — 기본 키 — NOT NULL
- created_at — datetime
- updated_at — datetime
- uid — int — NOT NULL
- account_name — varchar(64) — NOT NULL
- app_key — varchar(64) — NOT NULL
- secret_key — blob — NOT NULL
- ip_address — varchar(100)
- exchange_type — varchar(50)
- vip_uid — int
- passphrase — varchar(255)
- is_verified — tinyint(1)
- vip_active — tinyint(1)
- is_rebate_account — tinyint(1)
quantus_coin_balances
- uid — int — 기본 키 — NOT NULL
- account_id — int — 기본 키 — NOT NULL
- created_at — datetime
- updated_at — datetime
- assets — text
- positions — text
- filled_history — json
- datetime — datetime
- iim — float
참여자 (participant)
- id — 기본 키 — NOT NULL
- grand_prix_id — 외래 키 → grand_prix.id — NOT NULL
- account_id — int — 외래 키 → quantus_coin_accounts.account_id — NOT NULL
- nickname
- 수익금 (realized_pnl)
- 수익률 (realized_pnl_rate)
- 참여일 (participate_date)
- 잔고현황 (margin_amount)
- 실격사유 (disqualified_flag)
- 실격사유 설명 (disqualified_detail)
- uid
- 현재_수익률_등수 (present_rank)
- 과거_수익률_등수 (prev_rank)
- 상금지불여부 (Field)
- 지급금액 (Field2)