이벤트
테이블 (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