KB
Tables (17)
ATTENDANCE_RECORDS
- id — BIGINT — Primary key — NOT NULL
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- type — VARCHAR(50)
- distance_meters — DECIMAL(10,2)
- accuracy_meters — DECIMAL(10,2)
- result — VARCHAR(50)
DISPUTES
- id — BIGINT — Primary key — NOT NULL
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- requester_id — BIGINT — Foreign key → USERS.id
- status — VARCHAR(50)
DOCUMENTS
- id — BIGINT — Primary key — NOT NULL
- owner_user_id — BIGINT — Foreign key → USERS.id
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- document_type — VARCHAR(100)
- storage_key — VARCHAR(255)
- mime_type — VARCHAR(100)
- size_bytes — BIGINT
- checksum — VARCHAR(255)
- expires_at — DATETIME
- status — VARCHAR(50)
DOCUMENT_ACCESS_LOGS
- id — BIGINT — Primary key — NOT NULL
- document_id — BIGINT — Foreign key → DOCUMENTS.id
- actor_user_id — BIGINT — Foreign key → USERS.id
- action — VARCHAR(100)
- result — VARCHAR(50)
- created_at — DATETIME
DOCUMENT_SHARES
- id — BIGINT — Primary key — NOT NULL
- document_id — BIGINT — Foreign key → DOCUMENTS.id
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- shared_with_user_id — BIGINT — Foreign key → USERS.id
- expires_at — DATETIME
- revoked_at — DATETIME
EMPLOYER_PROFILES
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id
- business_name — VARCHAR(255)
ESCROWS
- id — BIGINT — Primary key — NOT NULL
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- amount — DECIMAL(15,2)
- status — VARCHAR(50)
PAYMENTS
- id — BIGINT — Primary key — NOT NULL
- payer_id — BIGINT — Foreign key → USERS.id
- portone_payment_id — VARCHAR(255)
- expected_amount — DECIMAL(15,2)
- paid_amount — DECIMAL(15,2)
- status — VARCHAR(50)
QR_TOKENS
- id — BIGINT — Primary key — NOT NULL
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- token_hash — VARCHAR(255)
- action — VARCHAR(50)
- expires_at — DATETIME
SETTLEMENTS
- id — BIGINT — Primary key — NOT NULL
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- amount — DECIMAL(15,2)
- due_at — DATETIME
- status — VARCHAR(50)
USERS
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255)
- password_hash — VARCHAR(255)
- role — VARCHAR(50)
- status — VARCHAR(50)
USER_BADGES
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id
- badge_type — VARCHAR(100)
- evidence — TEXT
WALLETS
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → USERS.id
- available_balance — DECIMAL(15,2)
- locked_balance — DECIMAL(15,2)
WALLET_TRANSACTIONS
- id — BIGINT — Primary key — NOT NULL
- wallet_id — BIGINT — Foreign key → WALLETS.id
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- amount — DECIMAL(15,2)
- type — VARCHAR(50)
- idempotency_key — VARCHAR(255)
WORK_CASES
- id — BIGINT — Primary key — NOT NULL
- employer_id — BIGINT — Foreign key → EMPLOYER_PROFILES.id
- worker_id — BIGINT — Foreign key → USERS.id
- agreed_wage — DECIMAL(15,2)
- status — VARCHAR(50)
- starts_at — DATETIME
- ends_at — DATETIME
WORK_CONTRACTS
- id — BIGINT — Primary key — NOT NULL
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- agreed_wage — DECIMAL(15,2)
- terms_snapshot — TEXT
WORK_INVITATIONS
- id — BIGINT — Primary key — NOT NULL
- work_case_id — BIGINT — Foreign key → WORK_CASES.id
- token_hash — VARCHAR(255)
- expires_at — DATETIME
- status — VARCHAR(50)