tradeEvt

Tables (3)

tradeEvt_info (Untitled)

  • tradeEvt_season_no (Key) — int — Primary key — NOT NULL
  • tradeEvt_round_no (Key2) — int — Primary key — NOT NULL
  • tradeEvt_rcv_start_dt (Field) — timestamp — 접수시작시간
  • tradeEvt_rcv_end_dt (Field2) — timestamp — 접수마감시간
  • tradeEvt_prd_start_dt (Field3) — timestamp — 진행시작시간
  • tradeEvt_prd_end_dt (Field4) — timestamp — 진행마감시간
  • tradeEvt_type (Field5) — enum — 이벤트분류
  • tradeEvt_coin_admit (Field6) — json — 종목코인 종목최대인정
  • tradeEvt_status (Field7) — enum — 상태 (접수대기/접수중/진행대기/진행중/종료)

tradeEvt_reward_detail (CopyOfUntitled2)

  • tradeEvt_info_seq (Key2) — Foreign key → tradeEvt_reward_info.tradeEvt_info_seq — NOT NULL
  • tradeEvt_type (Field) — enum
  • mb_id (Field2) — varchar
  • mb_no (Field3) — int
  • tradeEvt (Field4) — varchar
  • reward_coin_name (Field5) — varchar
  • rank_no (Field6) — int
  • rank_reward (Field7) — decimal

tradeEvt_reward_info (Untitled2)

  • tradeEvt_info_seq (Key) — Primary key — NOT NULL
  • reward_coin_name (Field) — varchar
  • rank_no (Field2) — int
  • rank_reward (Field3) — int