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