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)