이벤트 erd
테이블 (3)
event_reward_condition
- condition_id — int — 기본 키 — NOT NULL
- event_id — int — 외래 키 → event_setting.event_id — NOT NULL
- condition_value — int
- condition_desc — varchar(512)
event_setting
- event_id — int — 기본 키 — NOT NULL
- event_name — varchar(512)
- event_start — datetime
- event_end — datetime
- on_off — varchar(1)
reward_event_item
- condition_id — int — 외래 키 → event_reward_condition.condition_id — NOT NULL
- reward_type — varchar(1)
- reward_id — int
- reward_cnt — int