dondone_erd

Tables (27)

advance_requests

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • workplace_id — BIGINT — NOT NULL
  • contract_id — BIGINT — NOT NULL
  • month_start — DATE — NOT NULL
  • idempotency_key — VARCHAR(120) — NOT NULL
  • requested_amount_krw — BIGINT — NOT NULL
  • approved_amount_krw — BIGINT — NOT NULL
  • fee_amount_krw — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • requested_at — TIMESTAMPTZ — NOT NULL
  • repayment_due_date — DATE — NOT NULL
  • snapshot_available_amount_krw — BIGINT — NOT NULL
  • snapshot_max_cap_krw — BIGINT — NOT NULL
  • snapshot_policy_rate — NUMERIC(10, 4) — NOT NULL
  • snapshot_repayment_tier — VARCHAR(2) — NOT NULL
  • snapshot_reflected_work_days — INTEGER — NOT NULL
  • snapshot_reflected_work_minutes — BIGINT — NOT NULL
  • snapshot_verified_minutes — BIGINT — NOT NULL
  • snapshot_pending_minutes — BIGINT — NOT NULL
  • snapshot_needs_review_record_count — INTEGER — NOT NULL
  • snapshot_next_tier_remaining_minutes — INTEGER — NOT NULL
  • snapshot_estimated_fee_krw — BIGINT — NOT NULL
  • snapshot_estimated_repayment_date — DATE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

async_job_attempts

  • id — BIGINT
  • job_id — BIGINT — NOT NULL
  • attempt_no — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • worker_name — VARCHAR(120)
  • started_at — TIMESTAMPTZ — NOT NULL
  • finished_at — TIMESTAMPTZ
  • error_code — VARCHAR(50)
  • error_message — TEXT

async_jobs

  • id — BIGINT
  • job_type — VARCHAR(40) — NOT NULL
  • queue_name — VARCHAR(50) — NOT NULL
  • resource_type — VARCHAR(50) — NOT NULL
  • resource_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • priority — INTEGER — NOT NULL
  • dedupe_key — VARCHAR(200)
  • concurrency_key — VARCHAR(200)
  • payload_json — JSONB — NOT NULL
  • attempts — INTEGER — NOT NULL
  • max_attempts — INTEGER — NOT NULL
  • run_after — TIMESTAMPTZ — NOT NULL
  • locked_at — TIMESTAMPTZ
  • locked_by — VARCHAR(120)
  • last_error_code — VARCHAR(50)
  • last_error_message — TEXT
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • RUNNING) — )

claim_preparation_checklist_items

  • id — BIGINT
  • preparation_id — BIGINT — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • item_code — VARCHAR(50)
  • item_text — TEXT — NOT NULL
  • is_required — BOOLEAN — NOT NULL

claim_preparation_document_links

  • preparation_id — BIGINT — Foreign key — NOT NULL
  • document_id — BIGINT — Foreign key — NOT NULL
  • sort_order — INTEGER — NOT NULL

claim_preparation_route_snapshots

  • id — BIGINT
  • preparation_id — BIGINT — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • channel — VARCHAR(20) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • description — TEXT — NOT NULL
  • contact — VARCHAR(200)
  • link_url — VARCHAR(500)

claim_preparations

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • wage_verification_id — BIGINT — NOT NULL
  • claim_kit_document_id — BIGINT
  • idempotency_key — VARCHAR(120)
  • locale — VARCHAR(20) — NOT NULL
  • tone — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • summary_text — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

claim_routes

  • id — BIGINT
  • locale — VARCHAR(20) — NOT NULL
  • channel — VARCHAR(20) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • description — TEXT — NOT NULL
  • contact — VARCHAR(200)
  • link_url — VARCHAR(500)
  • sort_order — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

documents

  • id — BIGINT
  • request_id — UUID — NOT NULL
  • requested_by_user_id — BIGINT — NOT NULL
  • document_type — VARCHAR(30) — NOT NULL
  • document_status — VARCHAR(20) — NOT NULL
  • document_format — VARCHAR(10) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • idempotency_key — VARCHAR(120) — NOT NULL
  • wage_verification_id — BIGINT
  • transfer_id — BIGINT
  • workplace_id — BIGINT
  • month_start — DATE
  • summary_payload_json — JSONB — NOT NULL
  • related_links_json — JSONB — NOT NULL
  • mime_type — VARCHAR(120)
  • file_name — VARCHAR(255)
  • file_size_bytes — BIGINT
  • storage_provider — VARCHAR(40)
  • storage_object_key — VARCHAR(512)
  • file_sha256 — CHAR(64)
  • error_code — VARCHAR(50)
  • error_message — TEXT
  • queued_at — TIMESTAMPTZ — NOT NULL
  • started_at — TIMESTAMPTZ
  • ready_at — TIMESTAMPTZ
  • failed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • TRANSFER_RECEIPT) — AND

remittance_recipients

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • alias — VARCHAR(100) — NOT NULL
  • relationship — VARCHAR(50) — NOT NULL
  • wallet_address — VARCHAR(120) — NOT NULL
  • photo_url — VARCHAR(500)
  • is_favorite — BOOLEAN — NOT NULL
  • cooldown_until — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

remittance_transfer_events

  • id — BIGINT
  • transfer_id — BIGINT — NOT NULL
  • event_type — VARCHAR(30) — NOT NULL
  • message — TEXT
  • tx_hash — VARCHAR(120)
  • payload_json — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

remittance_transfers

  • id — BIGINT
  • request_id — UUID — NOT NULL
  • user_id — BIGINT — NOT NULL
  • recipient_id — BIGINT — NOT NULL
  • safepay_check_id — BIGINT — NOT NULL
  • idempotency_key — VARCHAR(120) — NOT NULL
  • token_symbol — VARCHAR(20) — NOT NULL
  • token_decimals — INTEGER — NOT NULL
  • amount — NUMERIC(36, 18) — NOT NULL
  • memo — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL
  • tx_hash — VARCHAR(120)
  • failure_reason_code — VARCHAR(50)
  • failure_reason_message — TEXT
  • submitted_at — TIMESTAMPTZ — NOT NULL
  • confirmed_at — TIMESTAMPTZ
  • failed_at — TIMESTAMPTZ
  • blocked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

safepay_transfer_check_reasons

  • id — BIGINT
  • safepay_check_id — BIGINT — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • reason_code — VARCHAR(50) — NOT NULL

safepay_transfer_checks

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • recipient_id — BIGINT — NOT NULL
  • token_symbol — VARCHAR(20) — NOT NULL
  • amount — NUMERIC(36, 18) — NOT NULL
  • decision — VARCHAR(10) — NOT NULL
  • user_message — TEXT — NOT NULL
  • cooldown_until — TIMESTAMPTZ
  • requires_additional_confirm — BOOLEAN — NOT NULL
  • checked_at — TIMESTAMPTZ — NOT NULL

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

vault_accounts

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • token_symbol — VARCHAR(20) — NOT NULL
  • stored_amount — NUMERIC(36, 18) — NOT NULL
  • available_to_store_amount — NUMERIC(36, 18) — NOT NULL
  • available_to_transfer_amount — NUMERIC(36, 18) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

vault_ledger_entries

  • id — BIGINT
  • account_id — BIGINT — NOT NULL
  • entry_type — VARCHAR(20) — NOT NULL
  • amount — NUMERIC(36, 18) — NOT NULL
  • release_target — VARCHAR(20)
  • resulting_stored_amount — NUMERIC(36, 18) — NOT NULL
  • resulting_available_to_store_amount — NUMERIC(36, 18) — NOT NULL
  • resulting_available_to_transfer_amount — NUMERIC(36, 18) — NOT NULL
  • interest_daily — NUMERIC(36, 18) — NOT NULL
  • interest_monthly — NUMERIC(36, 18) — NOT NULL
  • interest_apr — NUMERIC(10, 4) — NOT NULL
  • simulated_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

wage_deposits

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • month_start — DATE — NOT NULL
  • deposit_date — DATE — NOT NULL
  • actual_deposit_amount_krw — BIGINT — NOT NULL
  • deductions_known — BOOLEAN — NOT NULL
  • note — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

wage_verification_cause_snapshots

  • id — BIGINT
  • verification_id — BIGINT — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • cause_code — VARCHAR(50) — NOT NULL
  • cause_title — VARCHAR(150) — NOT NULL
  • cause_detail — TEXT

wage_verification_record_links

  • sort_order — INTEGER — Primary key — NOT NULL
  • verification_id — BIGINT — Foreign key — NOT NULL
  • work_proof_record_id — BIGINT — NOT NULL

wage_verifications

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • workplace_id — BIGINT — NOT NULL
  • contract_id — BIGINT — NOT NULL
  • month_start — DATE — NOT NULL
  • pay_unit — VARCHAR(20) — NOT NULL
  • base_pay_amount_krw — BIGINT — NOT NULL
  • daily_work_minutes — INTEGER
  • monthly_work_minutes — INTEGER
  • normalized_hourly_wage_krw — BIGINT — NOT NULL
  • work_day_count — INTEGER — NOT NULL
  • verified_work_minutes — BIGINT — NOT NULL
  • overtime_minutes — BIGINT — NOT NULL
  • night_minutes — BIGINT — NOT NULL
  • modified_record_count — INTEGER — NOT NULL
  • excluded_pending_record_count — INTEGER — NOT NULL
  • actual_deposit_amount_krw — BIGINT — NOT NULL
  • deductions_known — BOOLEAN — NOT NULL
  • submitted_by — VARCHAR(20) — NOT NULL
  • memo — VARCHAR(500)
  • status — VARCHAR(30) — NOT NULL
  • resolution_stage — VARCHAR(50) — NOT NULL
  • base_estimate_krw — BIGINT — NOT NULL
  • overtime_premium_krw — BIGINT — NOT NULL
  • night_premium_krw — BIGINT — NOT NULL
  • estimated_total_krw — BIGINT — NOT NULL
  • difference_amount_krw — BIGINT — NOT NULL
  • difference_rate — NUMERIC(10, 4) — NOT NULL
  • threshold_absolute_won — BIGINT — NOT NULL
  • threshold_relative_percent — NUMERIC(10, 4) — NOT NULL
  • threshold_deduction_relaxed — BOOLEAN — NOT NULL
  • rule_version — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

work_contracts

  • id — BIGINT
  • workplace_id — BIGINT — NOT NULL
  • pay_unit — VARCHAR(20) — NOT NULL
  • base_pay_amount_krw — BIGINT — NOT NULL
  • daily_work_minutes — INTEGER
  • monthly_work_minutes — INTEGER
  • normalized_hourly_wage_krw — BIGINT — NOT NULL
  • effective_from — DATE — NOT NULL
  • effective_to — DATE
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

work_proof_attachments

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • kind — VARCHAR(30) — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • content_type — VARCHAR(120) — NOT NULL
  • file_size_bytes — BIGINT — NOT NULL
  • storage_provider — VARCHAR(40) — NOT NULL
  • storage_object_key — VARCHAR(512) — NOT NULL
  • file_sha256 — CHAR(64)
  • uploaded_at — TIMESTAMPTZ — NOT NULL

work_proof_modification_attachments

  • modification_id — BIGINT — Foreign key — NOT NULL
  • attachment_id — BIGINT — Foreign key — NOT NULL

work_proof_modifications

  • id — BIGINT
  • record_id — BIGINT — NOT NULL
  • modified_by_user_id — BIGINT — NOT NULL
  • reviewed_by_user_id — BIGINT
  • review_status — VARCHAR(20) — NOT NULL
  • modification_kind — VARCHAR(30) — NOT NULL
  • reason_code — VARCHAR(30) — NOT NULL
  • reason_memo — VARCHAR(500)
  • before_record_status — VARCHAR(20)
  • before_reflection_status — VARCHAR(20)
  • before_check_in_device_at — TIMESTAMPTZ
  • before_check_out_device_at — TIMESTAMPTZ
  • after_record_status — VARCHAR(20)
  • after_reflection_status — VARCHAR(20)
  • after_check_in_device_at — TIMESTAMPTZ
  • after_check_out_device_at — TIMESTAMPTZ
  • reviewed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • OTHER)) — )

work_proof_records

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • workplace_id — BIGINT — NOT NULL
  • contract_id — BIGINT — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • record_status — VARCHAR(20) — NOT NULL
  • reflection_status — VARCHAR(20) — NOT NULL
  • work_date — DATE — NOT NULL
  • worked_minutes — INTEGER
  • modification_count — INTEGER — NOT NULL
  • check_in_device_at — TIMESTAMPTZ
  • check_in_server_at — TIMESTAMPTZ
  • check_in_latitude — NUMERIC(9, 6)
  • check_in_longitude — NUMERIC(9, 6)
  • check_in_location_label — VARCHAR(120)
  • check_out_device_at — TIMESTAMPTZ
  • check_out_server_at — TIMESTAMPTZ
  • check_out_latitude — NUMERIC(9, 6)
  • check_out_longitude — NUMERIC(9, 6)
  • check_out_location_label — VARCHAR(120)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

workplaces

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • map_label — VARCHAR(120)
  • latitude — NUMERIC(9, 6) — NOT NULL
  • longitude — NUMERIC(9, 6) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL