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