이벤트

테이블 (6)

Copy Of Untitled2 (EventInvitation)

  • Key (receiver_midx) — int — 기본 키 — NOT NULL
  • midx — bigint — 외래 키 → UserInfo.midx — NOT NULL
  • Field (invite_code) — varchar
  • Field4 (created_dt) — datetime
  • Field (created_id) — varchar
  • Field2 (updated_dt) — datetime
  • Field3 (updated_id) — varchar

EventBoard

  • Key (event_id) — int — 기본 키 — NOT NULL
  • Field (event_title) — varchar
  • Field2 (event_content) — varchar
  • Field5 (event_start_dt) — datetime
  • Field (event_end_dt) — datetime
  • Field6 (created_dt) — datetime
  • Field (created_id) — varchar
  • Field7 (updated_dt) — datetime
  • Field2 (updated_id) — varchar

Untitled (EventProduct)

  • Key (product_id) — int — 기본 키 — NOT NULL
  • Key (event_id) — int — 외래 키 → EventBoard.Key — NOT NULL
  • Field (total_count) — int
  • Field5 (used_count) — int
  • Field (product_grade) — int
  • Field (probability) — decimal(6,5)
  • Field6 (created_dt) — datetime
  • Field (created_id) — varchar
  • Field7 (updated_dt) — datetime
  • Field2 (updated_id) — varchar

Untitled2 (EventWinner)

  • Key (event_winner_seq) — int — 기본 키 — NOT NULL
  • midx — bigint — 외래 키 → UserInfo.midx — NOT NULL
  • Key (product_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (event_id) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field5 (created_dt) — datetime
  • Field (created_id) — varchar
  • Field6 (updated_dt) — datetime
  • Field2 (updated_id) — varchar

Untitled2 (EventHistory)

  • Key (event_history_seq) — int — 기본 키 — NOT NULL
  • Field (midx) — bigint
  • Field2 (event_id) — int
  • Field3 (product_id) — int
  • Field4 (created_dt) — datetime
  • Field (created_id) — varchar
  • Field2 (updated_dt) — datetime
  • Field3 (updated_id) — varchar

UserInfo (EventApplicants)

  • midx — bigint — 기본 키 — NOT NULL
  • phone_number — varchar
  • Field2 (total_count) — int
  • Field3 (used_count) — int
  • Field (show_popup_yn) — int
  • created_at (created_dt) — datetime
  • Field (created_id) — varchar
  • updated_at (updated_dt) — datetime
  • Field2 (updated_id) — varchar