이벤트 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