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)