Database — Cross-System View¶
File ini auto-generated dari
tools/generate_layer_indexes.py. Jangan edit manual — perubahan akan ditimpa. Edit file sumber disystems/<slug>/.
| Sistem | Dokumen | Highlights | Status |
|---|---|---|---|
| 🔧 Automotive | 02-database.md | ERD kendaraan-WO-sparepart-invoice-komisi, DDL PostgreSQL dengan FEFO batch constraint, VIN/plate index, substitusi part EXACT/MODIFIED, audit trail adjustment | draft |
| 🍔 Fnb | 02-database.md | Recipe BOM, FIFO/FEFO ingredient batch, KDS state machine, table/order schema | draft |
| 🩺 Healthcare | 02-database.md | ERD dan DDL schema PostgreSQL untuk SentraClinic EMR — patients, encounters, vital_signs, soap_notes (immutable lock), prescriptions, medicine_batches FEFO, billing_invoices, audit_logs append-only | draft |
| 🧺 Laundry | 02-database.md | ERD laundry orders, FSM item tracking, mesin cuci, operational queue, courier dispatches, payroll incentive | draft |
| 🏋️ Membership | 02-database.md | ERD dan DDL PostgreSQL untuk membership, subscriptions, wallet signed transactions, booking, dan gate access logs | draft |
| 🚗 Rental | 02-database.md | Branch-partitioned assets, booking state machine, deposit lifecycle, handover tamper-proof hash, staff commission schema | draft |
| 🛒 Retail | 02-database.md | Multi-branch products, batch FIFO stock, customer loyalty, tiered pricing schema | draft |
| 💇 Service | 02-database.md | Skema appointment, staff_schedules shift, services duration, staff_commissions tiered, retail_sales upselling | draft |