Database Full Catalog (FULL Only)

Total migration files parsed: 106
Total tabel terdeteksi (create/alter union): 39

Dokumen ini sengaja tanpa mapping detail table → migration list.
Fokus: inventori penuh + perubahan terakhir yang relevan per table.

Inventori Tabel per Domain

User/Auth & Infra

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

Project & 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)

Table	Latest change (detected from migration name)	Status
users	add deleted_at + tanda tangan (gambar_ttd)	verified by migration name
projects	nullable latitude/longitude	verified by migration name
spbs	add soft delete (deleted_at)	verified by migration name
items	add FK spb_id	verified by migration name
pre_orders	add FK spb_id	verified by migration name
po_items	set nullable + add FK po_id	verified by migration name
payments	update nilai split_total + flag is_full_payment	verified by migration name
payment_terms	add FK payment_id	verified by migration name
payment_splits	add initial_amount	verified by migration name
price_change_requests	add FK po_id	verified by migration name
payment_split_price_change_requests	create table request perubahan harga split	verified by migration name
spks	add rejection note + soft delete (deleted_at)	verified by migration name
spk_payments	add rejection_note	verified by migration name
spk_payment_accountings	add paid_nominal	verified by migration name
spk_payment_receipts	update struktur receipt	verified by migration name
suppliers	add type	verified by migration name
taxes	add new_amount	verified by migration name
pivot_project_spvs	create pivot project ↔ spv	verified by migration name
pivot_project_logistic_admins	create pivot project ↔ logistic admin	verified by migration name

Relasi Visual

Lihat viewer khusus: /docs/database-viewer

Catatan Verifikasi

• Status: Partial
• Scope: Ringkasan berbasis nama migration (intent), belum menjamin kondisi data production saat ini.
• Action: Cross-check terhadap schema DB live (structure + indeks + FK aktual).