이벤트
테이블 (10)
event
- id — BIGINT
- event_name — VARCHAR(100) — NOT NULL
- event_type — VARCHAR(30) — NOT NULL — 이벤트
- start_at — TIMESTAMPTZ — NOT NULL — 이벤트
- end_at — TIMESTAMPTZ — NOT NULL — 이벤트
- is_active — BOOLEAN — NOT NULL — 이벤트
- is_visible — BOOLEAN — NOT NULL — 이벤트
- is_auto_entry — BOOLEAN — NOT NULL — 자동
- is_confirmed — BOOLEAN — NOT NULL — 이벤트
- is_sns_linked — BOOLEAN — NOT NULL — SNS
- event_url — VARCHAR(300) — 이벤트
- description — TEXT — 이벤트
- supplier_id — BIGINT — NOT NULL — 공급사
- is_winner_announced — BOOLEAN — NOT NULL — 당첨자
- winner_announced_at — TIMESTAMPTZ — 당첨자
- allow_duplicate_winner — BOOLEAN — NOT NULL — 당첨자
- allow_multiple_entry — BOOLEAN — NOT NULL — 복수
- winner_selection_cycle — INTEGER — 당첨자
- winner_selection_base_at — TIMESTAMPTZ — 당첨자
- priority — INTEGER — 전시
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
event_applicant
- id — BIGINT
- event_id — BIGINT — 외래 키 → event.id — NOT NULL
- member_id — BIGINT — NOT NULL — 참여자
- draw_id — BIGINT — 외래 키 → event_draw_round.id — NOT NULL — 추첨
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
event_display_asset
- id — BIGINT
- event_id — BIGINT — 외래 키 → event.id — NOT NULL
- file_id — BIGINT — 외래 키 → event_file.id — NOT NULL — 파일
- asset_type — VARCHAR(40) — NOT NULL — UI
- display_width — INTEGER — UI
- display_height — INTEGER — UI
- sort_order — INTEGER — NOT NULL — 동일
- is_active — BOOLEAN — NOT NULL — 활성화
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
event_draw_round
- id — BIGINT
- event_id — BIGINT — 외래 키 → event.id — NOT NULL
- draw_no — INTEGER — NOT NULL — 추첨
- is_confirmed — BOOLEAN — NOT NULL — 당첨자
- draw_at — TIMESTAMPTZ — 실제
- draw_start_at — TIMESTAMPTZ — 추첨
- draw_end_at — TIMESTAMPTZ — 추첨
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
event_entry
- id — BIGINT
- applicant_id — BIGINT — 외래 키 → event_applicant.id — NOT NULL
- event_prize_id — BIGINT — 외래 키 → event_prize.id — 당첨된
- member_id — BIGINT — NOT NULL — 응모자
- applied_at — TIMESTAMPTZ — NOT NULL — 이벤트
- is_winner — BOOLEAN — NOT NULL — 추첨/확정
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
event_file
- id — BIGINT
- object_key — VARCHAR(300) — NOT NULL
- original_file_name — VARCHAR(200) — NOT NULL — 업로드
- file_size — BIGINT — NOT NULL — 파일
- mime_type — VARCHAR(50) — NOT NULL — MIME
- file_extension — VARCHAR(10) — NOT NULL — 파일
- checksum_sha256 — VARCHAR(64) — SHA-256
- width — INTEGER — 이미지
- height — INTEGER — 이미지
- is_public — BOOLEAN — NOT NULL — CDN
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
event_prize
- id — BIGINT
- draw_id — BIGINT — 외래 키 → event_draw_round.id — NOT NULL
- prize_id — BIGINT — 외래 키 → prize.id — NOT NULL — 경품
- daily_limit — INTEGER — 일별
- total_limit — INTEGER — 총
- priority — INTEGER — NOT NULL — 경품
- is_active — BOOLEAN — NOT NULL — 경품
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
event_prize_probability
- id — BIGINT
- draw_id — BIGINT — 외래 키 → event_draw_round.id
- event_prize_id — BIGINT — 외래 키 → event_prize.id — NOT NULL — 경품
- probability — NUMERIC(5,2) — NOT NULL — 당첨
- weight — INTEGER — 가중치
- is_active — BOOLEAN — NOT NULL — 확률
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 수정
- updated_by — BIGINT — NOT NULL — 수정자
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
event_win
- id — BIGINT
- entry_id — BIGINT — 외래 키 → event_entry.id
- draw_id — BIGINT — 외래 키 → event_draw_round.id — 추첨
- event_id — BIGINT — 외래 키 → event.id — NOT NULL — 이벤트
- member_id — BIGINT — NOT NULL — 당첨자
- event_prize_id — BIGINT — 외래 키 → event_prize.id — 당첨된
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리
prize
- id — BIGINT
- prize_name — VARCHAR(100) — NOT NULL
- reward_type — VARCHAR(20) — NOT NULL — 보상
- point_amount — INTEGER — 포인트
- coupon_id — BIGINT — 쿠폰
- prize_description — TEXT — 경품
- is_active — BOOLEAN — NOT NULL — 경품
- created_at — TIMESTAMPTZ — NOT NULL — 등록
- created_by — BIGINT — NOT NULL — 등록자
- updated_at — TIMESTAMPTZ — NOT NULL — 최종
- updated_by — BIGINT — NOT NULL — 최종
- deleted_at — TIMESTAMPTZ — 삭제
- is_deleted — BOOLEAN — NOT NULL — 논리