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