Skip to main content

Full Catalog Database (FULL Only)

Total migration files parsed: 106 Total tables detected (create/alter union): 39

This document deliberately without mapping detail table → migration list. Focus: full inventory + last relevant changes per table.

Table Inventory per Domain​

User/Auth & Infra​

  • users
  • personal_access_tokens
  • otps
  • fcm_tokens
  • notifications
  • jobs, failed_jobs, job_batches

Projects & Procurement​

  • projects
  • project_managers, project_accounts
  • pivot_project_spvs, pivot_project_logistic_admins
  • spbs, items, pre_orders, po_items
  • suppliers, order_givers

Payment PO​

  • payments, payment_terms, payment_splits, price_change_requests, payment_split_price_change_requests
  • taxes, check_list_po_docs
  • po_payment_receipts, po_payment_receipt_checklists
  • pivot_po_payment_receipt_checklists, pivot_po_payment_receipt_pre_order

SPK​

  • spks, spk_revisions, spk_attachments
  • spk_payments, spk_payment_accountings
  • spk_payment_receipts, spk_payment_receipt_checklists
  • pivot_spk_payment_receipt_checklists

Latest Change Summary (Per Table)​

TablesLatest change (detected from migration name)Status
usersadd deleted_at + signature (signed_image)verified by migration name
projectsnullable latitude/longitudeverified by migration name
spbsadd soft delete (deleted_at)verified by migration name
itemsadd FK spb_idverified by migration name
pre_ordersadd FK spb_idverified by migration name
po_itemsset nullable + add FK po_idverified by migration name
paymentsupdate split_total value + is_full_payment flagverified by migration name
payment_termsadd FK payment_idverified by migration name
payment_splitsadd initial_amountverified by migration name
price_change_requestsadd FK po_idverified by migration name
payment_split_price_change_requestscreate table request split price changesverified by migration name
spksadd rejection note + soft delete (deleted_at)verified by migration name
spk_paymentsadd rejection_noteverified by migration name
spk_payment_accountingsadd paid_nominalverified by migration name
spk_payment_receiptsupdate receipt structureverified by migration name
suppliersadd typeverified by migration name
taxesadd new_amountverified by migration name
pivot_project_spvscreate pivot project ↔ spvverified by migration name
pivot_project_logistic_adminscreate pivot project ↔ logistics adminverified by migration name

Visual Relations​

View custom viewer: /docs/database-viewer

Verification Notes​

  • Status: Partial
  • Scope: Summary based on migration name (intent), does not guarantee the current state of production data.
  • Action: Cross-check against live DB schema (structure + index + actual FK).