Dondok

Tables (23)

crew

  • id — BIGINT — Primary key — NOT NULL
  • host_member_id — BIGINT — Foreign key → member.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT — NOT NULL
  • image_s3_key — VARCHAR(255)
  • category — VARCHAR(30) — NOT NULL
  • host_agreement_snapshot — JSON — NOT NULL
  • host_agreement_version — VARCHAR(20) — NOT NULL
  • host_agreed_at — DATETIME(6) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • deposit_amount — BIGINT — NOT NULL
  • min_participants — INT — NOT NULL
  • max_participants — INT — NOT NULL
  • recruitment_deadline — DATETIME(6) — NOT NULL
  • start_at — DATETIME(6) — NOT NULL
  • activated_at — DATETIME(6)
  • cancelled_at — DATETIME(6)
  • end_at — DATETIME(6) — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

crew_notice

  • id — BIGINT — Primary key — NOT NULL
  • crew_id — BIGINT — Foreign key → crew.id — NOT NULL
  • author_member_id — BIGINT — Foreign key → member.id — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

crew_notice_comment

  • id — BIGINT — Primary key — NOT NULL
  • crew_notice_id — BIGINT — Foreign key → crew_notice.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

crew_notice_reaction

  • id — BIGINT — Primary key — NOT NULL
  • crew_notice_id — BIGINT — Foreign key → crew_notice.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • reaction_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

crew_participant

  • id — BIGINT — Primary key — NOT NULL
  • crew_id — BIGINT — Foreign key → crew.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • deposit_amount — BIGINT — NOT NULL
  • pending_at — DATETIME(6) — NOT NULL
  • locked_at — DATETIME(6)
  • rejected_at — DATETIME(6)
  • cancelled_at — DATETIME(6)
  • expired_at — DATETIME(6)
  • released_point_history_id — BIGINT — Foreign key → point_history.id
  • version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

daily_settlement_participant_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • daily_settlement_snapshot_id — BIGINT — Foreign key → daily_settlement_snapshot.id — NOT NULL
  • crew_participant_id — BIGINT — Foreign key → crew_participant.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • participant_status_snapshot — VARCHAR(20) — NOT NULL
  • success_count — INT — NOT NULL
  • share_ratio — DECIMAL(10, 6) — NOT NULL
  • expected_refund_amount — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

daily_settlement_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • crew_id — BIGINT — Foreign key → crew.id — NOT NULL
  • mission_date — DATE — NOT NULL
  • daily_settlement_type — CHAR(1) — NOT NULL
  • frequency_type_snapshot — VARCHAR(20) — NOT NULL
  • phase — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • batch_run_key — VARCHAR(100) — NOT NULL
  • frozen_at — DATETIME(6) — NOT NULL
  • total_participants — INT — NOT NULL
  • total_recognized_success_count — INT — NOT NULL
  • total_locked_amount — BIGINT — NOT NULL
  • failure_message — VARCHAR(500)
  • retry_count — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

image_reencode_task

  • id — BIGINT — Primary key — NOT NULL
  • mission_log_id — BIGINT — Foreign key → mission_log.id — NOT NULL
  • s3_key — VARCHAR(255) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • last_error — VARCHAR(500)
  • next_attempt_at — DATETIME(6) — NOT NULL
  • attempt_version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

member

  • id — BIGINT — Primary key — NOT NULL
  • uuid — BINARY(16) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_s3_key — VARCHAR(255)
  • status_message — VARCHAR(100)
  • oauth_provider — VARCHAR(20)
  • oauth_provider_id — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

member_refresh_token

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • token_hash — CHAR(64) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • revoked_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

mission_log

  • id — BIGINT — Primary key — NOT NULL
  • crew_participant_id — BIGINT — Foreign key → crew_participant.id — NOT NULL
  • image_url — VARCHAR(500)
  • image_s3_key — VARCHAR(255) — NOT NULL
  • caption — VARCHAR(100) — NOT NULL
  • image_hash — CHAR(64)
  • server_time — DATETIME(6) — NOT NULL
  • exif_taken_at — DATETIME(6)
  • exif_risk — VARCHAR(20) — NOT NULL
  • duplicate_hash — BOOLEAN — NOT NULL
  • certification_status — VARCHAR(20) — NOT NULL
  • moderator_id — BIGINT — Foreign key → member.id
  • moderator_decided_at — DATETIME(6)
  • decision_type — VARCHAR(20)
  • reject_reason_code — VARCHAR(30)
  • reject_memo — VARCHAR(50)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

mission_log_reaction

  • id — BIGINT — Primary key — NOT NULL
  • mission_log_id — BIGINT — Foreign key → mission_log.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • reaction_type — VARCHAR(20) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

mission_rule

  • id — BIGINT — Primary key — NOT NULL
  • crew_id — BIGINT — Foreign key → crew.id — NOT NULL
  • frequency_type — VARCHAR(20) — NOT NULL
  • daily_settlement_type — CHAR(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

mission_schedule_day

  • id — BIGINT — Primary key — NOT NULL
  • mission_rule_id — BIGINT — Foreign key → mission_rule.id — NOT NULL
  • day_of_week — TINYINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

moderation_history

  • id — BIGINT — Primary key — NOT NULL
  • mission_log_id — BIGINT — Foreign key → mission_log.id — NOT NULL
  • before_state — JSON
  • after_state — JSON — NOT NULL
  • decision_type — VARCHAR(20) — NOT NULL
  • reject_reason_code — VARCHAR(30)
  • reject_memo — VARCHAR(50)
  • moderator_id — BIGINT — Foreign key → member.id — NOT NULL
  • changed_at — DATETIME(6) — NOT NULL

notification

  • id — BIGINT — Primary key — NOT NULL
  • uuid — BINARY(16) — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • event_type — VARCHAR(80) — NOT NULL
  • resource_type — VARCHAR(50) — NOT NULL
  • resource_id — VARCHAR(100) — NOT NULL
  • deep_link — VARCHAR(255) — NOT NULL
  • display_text — VARCHAR(500) — NOT NULL
  • crew_name — VARCHAR(100)
  • requires_refetch — BOOLEAN — NOT NULL
  • occurred_at — DATETIME(6) — NOT NULL
  • read_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

notification_device

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • device_id — VARCHAR(100) — NOT NULL
  • platform — VARCHAR(20) — NOT NULL
  • fcm_token — VARCHAR(512) — NOT NULL
  • app_version — VARCHAR(50)
  • enabled — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

notification_settings

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • cat_emoji_reaction — BOOLEAN — NOT NULL
  • cat_host_verification — BOOLEAN — NOT NULL
  • cat_deadline_approaching — BOOLEAN — NOT NULL
  • cat_daily_result — BOOLEAN — NOT NULL
  • cat_settlement — BOOLEAN — NOT NULL
  • cat_crew_disbanded — BOOLEAN — NOT NULL
  • cat_crew_news — BOOLEAN — NOT NULL
  • quiet_start_time — TIME
  • quiet_end_time — TIME
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_account

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • available_balance — BIGINT — NOT NULL
  • reserved_balance — BIGINT — NOT NULL
  • locked_balance — BIGINT — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_charge

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • payment_id — VARCHAR(200) — NOT NULL
  • order_id — VARCHAR(64) — NOT NULL
  • amount — BIGINT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • point_history_id — BIGINT — Foreign key → point_history.id
  • failure_code — VARCHAR(80)
  • failure_message — VARCHAR(500)
  • recovery_attempt_count — INT — NOT NULL
  • next_recovery_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

point_history

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • amount — BIGINT — NOT NULL
  • available_after — BIGINT — NOT NULL
  • reserved_after — BIGINT — NOT NULL
  • locked_after — BIGINT — NOT NULL
  • transaction_type — VARCHAR(40) — NOT NULL
  • reference_type — VARCHAR(40) — NOT NULL
  • reference_id — BIGINT — NOT NULL
  • idempotency_key — VARCHAR(160) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

settlement

  • id — BIGINT — Primary key — NOT NULL
  • crew_id — BIGINT — Foreign key → crew.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • baseline_frozen_at — DATETIME(6) — NOT NULL
  • batch_run_key — VARCHAR(100)
  • retry_count — INT — NOT NULL
  • total_participants — INT — NOT NULL
  • total_locked_amount — BIGINT — NOT NULL
  • total_recognized_success — INT — NOT NULL
  • total_base_refund_amount — BIGINT — NOT NULL
  • total_remainder_amount — BIGINT — NOT NULL
  • remainder_policy — VARCHAR(40) — NOT NULL
  • failure_code — VARCHAR(50)
  • failure_message — VARCHAR(500)
  • algorithm_version — VARCHAR(50) — NOT NULL
  • rule_context_snapshot — JSON — NOT NULL
  • started_at — DATETIME(6)
  • finished_at — DATETIME(6)
  • crew_name — VARCHAR(255)
  • crew_started_at — DATETIME(6)
  • crew_ended_at — DATETIME(6)
  • mission_days — INT
  • version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

settlement_item

  • id — BIGINT — Primary key — NOT NULL
  • settlement_id — BIGINT — Foreign key → settlement.id — NOT NULL
  • crew_participant_id — BIGINT — Foreign key → crew_participant.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • nickname — VARCHAR(100)
  • participant_status_snapshot — VARCHAR(20) — NOT NULL
  • deposit_amount — BIGINT — NOT NULL
  • success_count_raw — INT — NOT NULL
  • recognized_success_count — INT — NOT NULL
  • recognized_dates_count — INT — NOT NULL
  • excluded_success_count — INT — NOT NULL
  • period_start_at — DATETIME(6) — NOT NULL
  • period_end_at — DATETIME(6) — NOT NULL
  • share_ratio — DECIMAL(10, 6) — NOT NULL
  • base_refund_amount — BIGINT — NOT NULL
  • remainder_bonus_amount — BIGINT — NOT NULL
  • refund_amount — BIGINT — NOT NULL
  • effective_moderation_snapshot — JSON
  • moderation_chain_ref — JSON
  • calculation_reason — JSON — NOT NULL
  • point_history_id — BIGINT — Foreign key → point_history.id
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL