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