Mode produksi: aplikasi live di pdkbsbu.web.id. Gunakan data dengan teliti dan cek ulang sebelum submit/perubahan status.
Database
Ringkasan data cache AppSheet yang siap dijadikan sumber seed awal PostgreSQL.
Total Rows Cache
7.321Dataset
7Missing Files
0Lookup Feeder
683/home/ubuntu/pdkbsbu-web/releases/20260518-183809/src/server/data-cache| Dataset | Target Table | Rows | File | Size | Updated |
|---|---|---|---|---|---|
| Work Orders | work_orders | 4.544 | work-orders.json | 5.2 MB | 18/5/2026, 01.34.02 |
| Users | app_users | 67 | users.json | 9.3 KB | 18/5/2026, 01.34.02 |
| Materials | materials | 62 | materials.json | 8.0 KB | 18/5/2026, 01.34.02 |
| Material Usages | material_usages | 2.503 | material-usages.json | 554.2 KB | 18/5/2026, 01.34.02 |
| Material Additions | material_additions | 137 | material-additions.json | 31.2 KB | 18/5/2026, 01.34.02 |
| SP2B Documents | sp2b_documents | 7 | sp2b.json | 5.5 KB | 18/5/2026, 01.34.02 |
| Reports | reports | 1 | reports.json | 373 B | 18/5/2026, 01.34.02 |
Lookup Feeder Rows
683 target: feedersLookup Pekerjaan Rows
95 target: work_typesJenis Konstruksi
18 target: construction_typesScript dry-run sudah tersedia untuk validasi urutan upsert dan kualitas key tanpa menulis ke PostgreSQL.
Hasil checkpoint terakhir: 7 dataset, 7.321 row cache planned, required key tidak missing, duplicate key sample tidak ada. `db:seed:cache` default dry-run dan baru menulis DB jika dijalankan manual dengan `-- --execute`.