이벤트

테이블 (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 — 논리