event-한정원

테이블 (19)

event (이벤트)

  • id — BIGSERIAL
  • supplier_id — BIGINT — NOT NULL
  • event_type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20)
  • is_visible — BOOLEAN
  • display_order — INTEGER
  • start_at — TIMESTAMP — NOT NULL
  • end_at — TIMESTAMP — NOT NULL
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_attendance_bonus_reward (출석 누적 보상)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • milestone_type — VARCHAR(20) — NOT NULL
  • milestone_count — INTEGER — NOT NULL
  • payout_rule — VARCHAR(20)
  • reward_catalog_id — BIGINT — 외래 키 → event_reward_catalog.id
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL
  • UNIQUE(event_id, — milestone_type,

event_attendance_daily_reward (출석 일일 보상)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • reward_catalog_id — BIGINT — 외래 키 → event_reward_catalog.id
  • is_active — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_attendance_policy (출석 정책)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • total_days — INTEGER — NOT NULL
  • allow_missed_days — BOOLEAN
  • reset_time — TIME
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_display_asset (이벤트에 속한 에셋)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • file_id — BIGINT — 외래 키 → file.id
  • asset_type — VARCHAR(40) — NOT NULL
  • display_width — INTEGER
  • display_height — INTEGER
  • sort_order — INTEGER
  • is_active — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_display_message (기본 노출 메시지)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • message_type — VARCHAR(100) — NOT NULL
  • text — TEXT — NOT NULL
  • lang_code — VARCHAR(10)
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL
  • UNIQUE(event_id, — message_type,

event_entry (이벤트 성공 기록(출석, 랜덤 포함))

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • event_type — VARCHAR(20) — NOT NULL
  • member_id — BIGINT — NOT NULL
  • action_result — VARCHAR(30) — NOT NULL
  • failure_reason — TEXT
  • attendance_date — DATE
  • total_attendance_count — INTEGER
  • streak_attendance_count — INTEGER
  • trigger_type — VARCHAR(20)
  • reward_pool_id — BIGINT — 외래 키 → event_random_reward_pool.id
  • created_at — TIMESTAMP

event_participant (이벤트에 조건 통과한 참여자 목록(출석, 랜덤 포함))

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • member_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • UNIQUE(event_id, — member_id)

event_participant_block (이벤트에 참여자 블랙 리스트)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • member_id — BIGINT — NOT NULL
  • blocked_reason — TEXT — NOT NULL
  • unblocked_at — TIMESTAMP
  • unblocked_by — BIGINT
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_participation_eligibility (이벤트 참여자격)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • eligibility_type — VARCHAR(30) — NOT NULL
  • eligibility_value — VARCHAR(200)
  • priority — INTEGER
  • is_active — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_participation_limit_policy (이벤트 참여 제한)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • limit_subject — VARCHAR(20) — NOT NULL
  • limit_scope — VARCHAR(20) — NOT NULL
  • limit_metric — VARCHAR(20) — NOT NULL
  • limit_value — INTEGER — NOT NULL
  • priority — INTEGER
  • is_active — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_random_policy (랜덤 정책)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • game_type — VARCHAR(20) — NOT NULL
  • display_slot_count — INTEGER
  • quiz_question — TEXT
  • quiz_answer — VARCHAR(200)
  • sns_retry_enabled — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_random_reward_counter (랜덤 상품의 일일 제한, 전체 기간동안 상품의 제한)

  • reward_pool_id — BIGINT — 외래 키 → event_random_reward_pool.id
  • daily_count — INTEGER
  • total_count — INTEGER
  • last_reset_date — DATE
  • updated_at — TIMESTAMP

event_random_reward_pool (랜덤 상품에 각각 확률 적용)

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • reward_catalog_id — BIGINT — 외래 키 → event_reward_catalog.id
  • probability_weight — INTEGER — NOT NULL
  • daily_limit — INTEGER
  • total_limit — INTEGER
  • priority — INTEGER
  • is_active — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_reward_allocation (이벤트 보상 준 기록(출석, 랜덤 포함))

  • id — BIGSERIAL
  • event_id — BIGINT — 외래 키 → event.id
  • event_type — VARCHAR(20) — NOT NULL
  • member_id — BIGINT — NOT NULL
  • reward_kind — VARCHAR(20) — NOT NULL
  • reward_catalog_id — BIGINT — 외래 키 → event_reward_catalog.id
  • reward_type — VARCHAR(20) — NOT NULL
  • point_amount — INTEGER
  • coupon_group_id — BIGINT
  • external_ref_id — BIGINT
  • reward_status — VARCHAR(20)
  • retry_count — INTEGER
  • next_retry_at — TIMESTAMP
  • idempotency_key — VARCHAR(120)
  • external_transaction_id — VARCHAR(120)
  • error_code — VARCHAR(50)
  • error_message — TEXT
  • requested_at — TIMESTAMP
  • processed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

event_reward_catalog (이벤트 보상 카탈로그(point, coupon, product, 꽝, 한번더))

  • id — BIGSERIAL
  • reward_type — VARCHAR(20) — NOT NULL
  • reward_name — VARCHAR(200) — NOT NULL
  • point_amount — INTEGER
  • coupon_group_id — BIGINT
  • external_ref_id — BIGINT
  • is_active — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

event_share_log (SNS 공유 로그)

  • event_share_id — BIGINT — 기본 키 — NOT NULL
  • id — BIGSERIAL — 기본 키
  • share_token — VARCHAR(200) — NOT NULL
  • sharer_member_id — BIGINT — NOT NULL
  • visitor_member_id — BIGINT
  • share_channel — VARCHAR(20) — NOT NULL
  • ip_address — VARCHAR(50)
  • user_agent — TEXT
  • created_at — TIMESTAMP

event_share_policy (SNS 공유 정책)

  • event_id — BIGINT — 외래 키 → event_random_policy.event_id
  • max_share_credit — INTEGER
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL

file (파일)

  • id — BIGSERIAL
  • object_key — VARCHAR(300) — NOT NULL
  • original_file_name — VARCHAR(200)
  • file_size — BIGINT — NOT NULL
  • mime_type — VARCHAR(50) — NOT NULL
  • file_extension — VARCHAR(10) — NOT NULL
  • checksum_sha256 — VARCHAR(64)
  • width — INTEGER
  • height — INTEGER
  • is_public — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — TIMESTAMP
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMP
  • updated_by — BIGINT — NOT NULL