| Column | Type | Length | Nullable |
|---|---|---|---|
| audit_id | integer | NO | |
| table_name | character varying | 50 | NO |
| field_name | character varying | 50 | YES |
| record_id | integer | NO | |
| action | character varying | 20 | NO |
| old_values | jsonb | YES | |
| new_values | jsonb | YES | |
| changed_by | character varying | 50 | YES |
| changed_on | timestamp without time zone | NO | |
| ip_address | character varying | 45 | YES |
| session_id | character varying | 128 | YES |
| user_agent | character varying | 255 | YES |
| audit_id | table_name | field_name | record_id | action | old_values | new_values | changed_by | changed_on | ip_address | session_id | user_agent |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | user_master | 1 | CREATE | {"note": "Default superuser created during setup", "role": "superuser", "status": "active", "last_name": "Administrator", "user_code": "superadmin", "first_name": "Super"} | system | 2026-05-23 15:05:33.347098 | 157.85.206.120 | ||||
| 2 | user_master | failed_login_count | 1 | UPDATE | {"failed_login_count": 0} | {"failed_login_count": 1} | 2026-05-23 15:20:33.887215 | 157.85.206.120 | pikfjenja3fb06kepctmhjpnba | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | |
| 3 | user_master | failed_login_count | 1 | UPDATE | {"failed_login_count": 1} | {"failed_login_count": 2} | 2026-05-23 15:20:43.632093 | 157.85.206.120 | pikfjenja3fb06kepctmhjpnba | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | |
| 4 | user_master | last_login_on | 1 | UPDATE | {"last_login_on": null} | {"last_login_on": "2026-05-23 15:21:54"} | superadmin | 2026-05-23 15:21:54.259263 | 157.85.206.120 | pikfjenja3fb06kepctmhjpnba | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 |
| 5 | user_session | is_active | 1 | UPDATE | {"is_active": true} | {"is_active": false, "logged_out_by": "superadmin"} | superadmin | 2026-05-23 15:23:29.228607 | 157.85.206.120 | pikfjenja3fb06kepctmhjpnba | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 |
| 6 | user_master | failed_login_count | 1 | UPDATE | {"failed_login_count": 0} | {"failed_login_count": 1} | 2026-05-23 15:23:32.770483 | 157.85.206.120 | 8o5o8kndvcpmovqhsqekecuiu3 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | |
| 7 | user_master | failed_login_count | 1 | UPDATE | {"failed_login_count": 1} | {"failed_login_count": 2} | 2026-05-23 15:23:50.182211 | 157.85.206.120 | 8o5o8kndvcpmovqhsqekecuiu3 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | |
| 8 | user_master | failed_login_count | 1 | UPDATE | {"failed_login_count": 2} | {"failed_login_count": 3} | 2026-05-23 15:23:59.583019 | 157.85.206.120 | 8o5o8kndvcpmovqhsqekecuiu3 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | |
| 9 | user_master | last_login_on | 1 | UPDATE | {"last_login_on": null} | {"last_login_on": "2026-05-23 15:24:13"} | superadmin | 2026-05-23 15:24:13.426558 | 157.85.206.120 | 8o5o8kndvcpmovqhsqekecuiu3 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 |
| 10 | user_master | password_hash | 1 | UPDATE | {"changed": true} | {"changed": true} | superadmin | 2026-05-23 15:25:32.204863 | 157.85.206.120 | 8o5o8kndvcpmovqhsqekecuiu3 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| blanket_id | integer | NO | |
| blanket_number | character varying | 50 | NO |
| supplier_id | integer | NO | |
| supplier_name_snapshot | character varying | 100 | YES |
| title | character varying | 200 | YES |
| start_date | date | YES | |
| close_order_date | date | YES | |
| due_payment_date | date | YES | |
| delivery_date | date | YES | |
| close_date | date | YES | |
| status | character varying | 20 | NO |
| created_by | character varying | 50 | YES |
| created_on | timestamp without time zone | NO |
| blanket_id | blanket_number | supplier_id | supplier_name_snapshot | title | start_date | close_order_date | due_payment_date | delivery_date | close_date | status | created_by | created_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | BL20260523001 | 2 | Toko Beras Nyawang | penawaran juni 2026 01 | 2026-05-23 | 2026-05-30 | 2026-06-01 | 2026-06-03 | 2026-06-10 | closed | superadmin | 2026-05-23 22:36:45.721542 |
| 2 | BL20260524001 | 1 | Beras Ripah | penawaran 003 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | cancelled | superadmin | 2026-05-24 17:13:54.990755 |
| 3 | BL20260524002 | 1 | Beras Ripah | blanket penawaran 005 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | cancelled | superadmin | 2026-05-24 17:17:27.150142 |
| 4 | BL20260524003 | 1 | Beras Ripah | blanket penawaran 101 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | cancelled | superadmin | 2026-05-24 17:29:59.765144 |
| 5 | BL20260524004 | 1 | Beras Ripah | blanket penawaran 105 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | cancelled | superadmin | 2026-05-24 17:35:33.260369 |
| 6 | BL20260524005 | 1 | Beras Ripah | blanket penawaran 103 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | open | superadmin | 2026-05-24 17:45:31.529187 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| blanket_id | integer | NO | |
| item_id | integer | NO | |
| item_number | integer | NO | |
| description | character varying | 200 | NO |
| unit_of_measure | character varying | 20 | NO |
| qty_offered | numeric | NO | |
| unit_price | numeric | NO |
| blanket_id | item_id | item_number | description | unit_of_measure | qty_offered | unit_price |
|---|---|---|---|---|---|---|
| 1 | 1 | 10 | beras premium 4kg | 100 | 1.00 | 3.00 |
| 1 | 2 | 20 | beras ramos 4kg | 200 | 1.00 | 2.00 |
| 2 | 3 | 10 | beras abrakadabra | pcs | 100.00 | 10000.00 |
| 2 | 4 | 20 | beras muslihat | pcs | 100.00 | 20000.00 |
| 3 | 5 | 10 | beras abrakadabra | pcs | 100.00 | 10000.00 |
| 3 | 6 | 20 | Beras prima | pcs | 100.00 | 20000.00 |
| 4 | 7 | 10 | beras abrakadabra | pcs | 100.00 | 10000.00 |
| 4 | 8 | 20 | beras puler | pcs | 100.00 | 20000.00 |
| 5 | 9 | 10 | beras abrakadabra | pcs | 100.00 | 10000.00 |
| 5 | 10 | 20 | beras puler | pcs | 100.00 | 20000.00 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| assignment_id | integer | NO | |
| blanket_id | integer | NO | |
| site_id | integer | NO | |
| assigned_by | character varying | 50 | YES |
| assigned_on | timestamp without time zone | NO | |
| status | character varying | 20 | NO |
| assignment_id | blanket_id | site_id | assigned_by | assigned_on | status |
|---|---|---|---|---|---|
| 1 | 2 | 1 | superadmin | 2026-05-24 17:13:54.990755 | active |
| Column | Type | Length | Nullable |
|---|---|---|---|
| booking_id | integer | NO | |
| booking_number | character varying | 50 | NO |
| site_id | integer | NO | |
| penawaran_id | integer | NO | |
| supplier_id | integer | NO | |
| member_id | integer | NO | |
| member_name_snapshot | character varying | 100 | YES |
| status | character varying | 30 | NO |
| total_amount | numeric | NO | |
| payment_proof_file_path | character varying | 255 | YES |
| payment_date | timestamp without time zone | YES | |
| payment_method | character varying | 30 | YES |
| payment_amount | numeric | YES | |
| payment_verified_by | character varying | 50 | YES |
| payment_verified_on | timestamp without time zone | YES | |
| payment_rejected_reason | character varying | 200 | YES |
| payment_rejected_count | integer | NO | |
| delivery_address | character varying | 255 | YES |
| delivery_notes | character varying | 500 | YES |
| estimated_delivery_date | date | YES | |
| delivery_proof_file_path | character varying | 255 | YES |
| is_recipient_confirmed | boolean | NO | |
| recipient_confirmed_on | timestamp without time zone | YES | |
| cancelled_reason | character varying | 200 | YES |
| cancelled_by | character varying | 50 | YES |
| cancelled_on | timestamp without time zone | YES | |
| is_refund_required | boolean | NO | |
| refund_processed_on | timestamp without time zone | YES | |
| refund_processed_by | character varying | 50 | YES |
| notes | character varying | 500 | YES |
| created_by | character varying | 50 | YES |
| created_on | timestamp without time zone | NO | |
| updated_by | character varying | 50 | YES |
| updated_on | timestamp without time zone | YES | |
| expired_on | timestamp without time zone | YES |
| booking_id | booking_number | site_id | penawaran_id | supplier_id | member_id | member_name_snapshot | status | total_amount | payment_proof_file_path | payment_date | payment_method | payment_amount | payment_verified_by | payment_verified_on | payment_rejected_reason | payment_rejected_count | delivery_address | delivery_notes | estimated_delivery_date | delivery_proof_file_path | is_recipient_confirmed | recipient_confirmed_on | cancelled_reason | cancelled_by | cancelled_on | is_refund_required | refund_processed_on | refund_processed_by | notes | created_by | created_on | updated_by | updated_on | expired_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8 | B20260523002 | 1 | 2 | 1 | 8 | subaryadi ahmad | closed | 213520.00 | uploads/payment_proofs/payment_6a12743220672_20260524104450.jpeg | 2026-05-24 00:00:00 | transfer | 223999.99 | adminsby002 | 2026-05-24 13:45:55.30064 | 0 | jl kutilang 13 paseban wonokromo | 2026-06-05 | 1 | 2026-05-24 15:24:44.362905 | 0817474741233 | 2026-05-23 23:27:59.719258 | 2026-05-24 10:44:50.138597 | 2026-05-24 23:27:59 | |||||||||||
| 7 | B20260523001 | 1 | 3 | 2 | 8 | subaryadi ahmad | closed | 92000.00 | uploads/payment_proofs/payment_6a129f02d81e8_20260524134730.jpeg | 2026-05-24 00:00:00 | transfer | 150000.00 | adminsby002 | 2026-05-24 13:48:38.206323 | 0 | jl kutilang 13 paseban wonokromo | ambil magrib | 2026-06-03 | 1 | 2026-05-24 15:24:52.334026 | 0817474741233 | 2026-05-23 23:26:32.46777 | 0817474741233 | 2026-05-24 13:47:30.890622 | 2026-05-24 23:26:32 | |||||||||
| 9 | B20260524001 | 1 | 4 | 2 | 8 | subaryadi ahmad | closed | 36000.00 | uploads/payment_proofs/payment_6a12b7f5141e4_20260524153357.jpeg | 2026-05-24 00:00:00 | transfer | 50000.00 | adminsby002 | 2026-05-24 15:34:35.822932 | 0 | jl kutilang 13 paseban wonokromo | 2026-06-10 | 1 | 1 | 2026-05-24 15:35:50.873212 | 0817474741233 | 2026-05-24 15:32:38.573685 | 0817474741233 | 2026-05-24 15:33:57.086959 | 2026-05-25 15:32:38 | |||||||||
| 11 | B20260524003 | 1 | 5 | 2 | 8 | subaryadi ahmad | closed | 74000.00 | uploads/payment_proofs/payment_6a12c5c26a343_20260524163250.jpeg | 2026-05-24 00:00:00 | transfer | 120000.00 | adminsby002 | 2026-05-24 16:33:33.063911 | 0 | jl kutilang 13 paseban wonokromo | 2026-06-04 | 1 | 2026-05-24 16:35:25.356004 | 0817474741233 | 2026-05-24 16:32:35.025135 | 0817474741233 | 2026-05-24 16:32:50.436214 | 2026-05-25 16:32:35 | ||||||||||
| 10 | B20260524002 | 1 | 5 | 2 | 7 | ahmad kurain | closed | 62000.00 | uploads/payment_proofs/payment_6a12c571f0537_20260524163129.jpeg | 2026-05-24 00:00:00 | transfer | 100000.00 | adminsby002 | 2026-05-24 16:33:37.960183 | 0 | jl. bungur 12 wonokromo | 2026-06-04 | 1 | 2026-05-24 16:35:07.027873 | 0812727273774 | 2026-05-24 16:31:05.105015 | 0812727273774 | 2026-05-24 16:31:30.253164 | 2026-05-25 16:31:05 | ||||||||||
| 12 | B20260524004 | 2 | 10 | 1 | 10 | athifah zakiyyah | paid | 220000.00 | uploads/payment_proofs/payment_6a12d7d85416a_20260524175000.jpeg | 2026-05-24 00:00:00 | transfer | 299999.00 | 0 | jl kanayakan a1 | 2026-06-04 | 08222222222 | 2026-05-24 17:49:45.301791 | 08222222222 | 2026-05-24 17:50:00.350908 | 2026-05-25 17:49:45 | ||||||||||||||
| 13 | B20260524005 | 1 | 9 | 1 | 7 | ahmad kurain | paid | 80000.00 | uploads/payment_proofs/payment_6a12d8670c0be_20260524175223.jpeg | 2026-05-24 00:00:00 | transfer | 100000.00 | 0 | jl. bungur 12 wonokromo | 2026-06-04 | 0812727273774 | 2026-05-24 17:50:46.090388 | 0812727273774 | 2026-05-24 17:52:23.060267 | 2026-05-25 17:50:46 | ||||||||||||||
| 14 | B20260524006 | 1 | 9 | 1 | 8 | subaryadi ahmad | paid | 120000.00 | uploads/payment_proofs/payment_6a12d95610613_20260524175622.jpeg | 2026-05-24 00:00:00 | transfer | 200000.00 | 0 | jl kutilang 13 paseban wonokromo | 2026-06-04 | 0817474741233 | 2026-05-24 17:56:04.372727 | 0817474741233 | 2026-05-24 17:56:22.07587 | 2026-05-25 17:56:04 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| booking_id | integer | NO | |
| item_id | integer | NO | |
| penawaran_item_id | integer | NO | |
| description_snapshot | character varying | 200 | YES |
| unit_of_measure_snapshot | character varying | 20 | YES |
| qty_offered_snapshot | numeric | YES | |
| qty_ordered | numeric | NO | |
| unit_price_snapshot | numeric | NO | |
| subtotal | numeric | NO | |
| item_status | character varying | 20 | NO |
| booking_id | item_id | penawaran_item_id | description_snapshot | unit_of_measure_snapshot | qty_offered_snapshot | qty_ordered | unit_price_snapshot | subtotal | item_status |
|---|---|---|---|---|---|---|---|---|---|
| 7 | 1 | 5 | beras premium 4kg | pcs | 60.00 | 1.00 | 58000.00 | 58000.00 | active |
| 7 | 2 | 6 | beras ramos 4kg | pcs | 60.00 | 1.00 | 34000.00 | 34000.00 | active |
| 8 | 3 | 3 | beras premium 7kg | pcs | 50.00 | 2.00 | 59000.00 | 118000.00 | active |
| 8 | 4 | 4 | beras biasa 7kg | pcs | 70.00 | 1.99 | 48000.00 | 95520.00 | active |
| 9 | 5 | 7 | Beras prima | pcs | 20.00 | 3.00 | 12000.00 | 36000.00 | active |
| 10 | 6 | 8 | beras puler | pcs | 20.00 | 1.00 | 12000.00 | 12000.00 | active |
| 10 | 7 | 9 | beras cianjur | pcs | 30.00 | 2.00 | 25000.00 | 50000.00 | active |
| 11 | 8 | 8 | beras puler | pcs | 20.00 | 2.00 | 12000.00 | 24000.00 | active |
| 11 | 9 | 9 | beras cianjur | pcs | 30.00 | 2.00 | 25000.00 | 50000.00 | active |
| 12 | 10 | 18 | beras abrakadabra | pcs | 50.00 | 5.00 | 17000.00 | 85000.00 | active |
| Column | Type | Length | Nullable |
|---|---|---|---|
| history_id | integer | NO | |
| booking_id | integer | NO | |
| status_from | character varying | 30 | YES |
| status_to | character varying | 30 | NO |
| changed_by | character varying | 50 | YES |
| changed_on | timestamp without time zone | NO | |
| notes | character varying | 500 | YES |
| ip_address | character varying | 45 | YES |
| history_id | booking_id | status_from | status_to | changed_by | changed_on | notes | ip_address |
|---|---|---|---|---|---|---|---|
| 1 | 7 | open | 0817474741233 | 2026-05-23 23:26:32.46777 | Booking created | ||
| 2 | 8 | open | 0817474741233 | 2026-05-23 23:27:59.719258 | Booking created | ||
| 3 | 8 | open | paid | 0817474741233 | 2026-05-24 10:44:50.138597 | Payment: transfer Rp 224.000 | |
| 6 | 8 | paid | verified | adminsby002 | 2026-05-24 13:45:55.30064 | Payment verified by admin | |
| 7 | 7 | open | paid | 0817474741233 | 2026-05-24 13:47:30.890622 | Payment: transfer Rp 150.000 | 157.85.206.120 |
| 8 | 7 | paid | verified | adminsby002 | 2026-05-24 13:48:38.206323 | Payment verified by admin | |
| 9 | 8 | verified | preparing | adminsby002 | 2026-05-24 15:22:13.853651 | deliver | |
| 10 | 7 | verified | preparing | adminsby002 | 2026-05-24 15:22:27.928611 | deli | |
| 11 | 8 | preparing | delivered | adminsby002 | 2026-05-24 15:23:37.192249 | ||
| 12 | 7 | preparing | delivered | adminsby002 | 2026-05-24 15:23:41.498912 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| config_id | integer | NO | |
| config_key | character varying | 40 | NO |
| config_value | numeric | NO | |
| config_value_2 | numeric | YES | |
| description | character varying | 255 | YES |
| updated_by | character varying | 50 | YES |
| updated_on | timestamp without time zone | YES |
| config_id | config_key | config_value | config_value_2 | description | updated_by | updated_on |
|---|---|---|---|---|---|---|
| 1 | marbot_percentage | 0.5000 | Marbot commission (20%) | superadmin | 2026-05-24 17:59:21.622392 | |
| 2 | penawaran_open_days | 7.0000 | Days penawaran open for orders | superadmin | 2026-05-24 17:59:21.644707 | |
| 3 | penawaran_payment_days | 2.0000 | Days for payment after order close | superadmin | 2026-05-24 17:59:21.665082 | |
| 4 | penawaran_delivery_days | 2.0000 | Days for delivery after payment | superadmin | 2026-05-24 17:59:21.691207 | |
| 5 | penawaran_close_days | 7.0000 | Days until penawaran fully closed | superadmin | 2026-05-24 17:59:21.709581 | |
| 6 | min_order_default | 1.0000 | Default minimum order per item | superadmin | 2026-05-24 17:59:21.735618 | |
| 7 | max_order_default | 10.0000 | Default maximum order per item | superadmin | 2026-05-24 17:59:21.889348 | |
| 8 | auto_cancel_hours | 24.0000 | Hours until auto-cancel (unpaid booking) | superadmin | 2026-05-24 17:59:22.116925 | |
| 10 | quota_threshold_percent | 50.0000 | Minimum quota % to avoid cancellation | superadmin | 2026-05-24 17:59:22.133851 | |
| 11 | refund_sla_days | 3.0000 | Refund processing SLA (business days) | superadmin | 2026-05-24 17:59:22.154401 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| archive_id | integer | NO | |
| table_name | character varying | 50 | NO |
| record_id | integer | NO | |
| archive_data | jsonb | NO | |
| archived_by | character varying | 50 | YES |
| archived_on | timestamp without time zone | NO | |
| archive_reason | character varying | 200 | YES |
| retention_until_date | date | YES |
| Column | Type | Length | Nullable |
|---|---|---|---|
| tracking_id | integer | NO | |
| booking_id | integer | NO | |
| tracking_number | character varying | 100 | YES |
| carrier | character varying | 50 | YES |
| status_from | character varying | 30 | YES |
| status_to | character varying | 30 | NO |
| changed_by | character varying | 50 | YES |
| changed_on | timestamp without time zone | NO | |
| delivery_photo_file_path | character varying | 255 | YES |
| notes | character varying | 500 | YES |
| tracking_id | booking_id | tracking_number | carrier | status_from | status_to | changed_by | changed_on | delivery_photo_file_path | notes |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 8 | preparing | delivered | adminsby002 | 2026-05-24 15:23:37.192249 | ||||
| 2 | 7 | preparing | delivered | adminsby002 | 2026-05-24 15:23:41.498912 | ||||
| 3 | 9 | 1 | jojo | preparing | delivered | adminsby002 | 2026-05-24 15:35:12.797799 | ||
| 4 | 11 | preparing | delivered | adminsby002 | 2026-05-24 16:34:21.486016 | ||||
| 5 | 10 | preparing | delivered | adminsby002 | 2026-05-24 16:34:34.423318 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| upload_id | integer | NO | |
| original_name | character varying | 255 | YES |
| stored_name | character varying | 255 | YES |
| file_path | character varying | 500 | YES |
| mime_type | character varying | 50 | YES |
| file_size_bytes | integer | YES | |
| uploaded_by | character varying | 50 | YES |
| uploaded_on | timestamp without time zone | NO | |
| related_table | character varying | 50 | YES |
| related_record_id | integer | YES | |
| purpose | character varying | 50 | YES |
| upload_id | original_name | stored_name | file_path | mime_type | file_size_bytes | uploaded_by | uploaded_on | related_table | related_record_id | purpose |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | WhatsApp Image 2026-05-24 at 10.22.49 AM.jpeg | payment_6a129f02d81e8_20260524134730.jpeg | uploads/payment_proofs/payment_6a129f02d81e8_20260524134730.jpeg | image/jpeg | 79741 | 0817474741233 | 2026-05-24 13:47:30.890622 | booking_header | 7 | payment_proof |
| 2 | WhatsApp Image 2026-05-24 at 10.22.49 AM.jpeg | payment_6a12b7f5141e4_20260524153357.jpeg | uploads/payment_proofs/payment_6a12b7f5141e4_20260524153357.jpeg | image/jpeg | 79741 | 0817474741233 | 2026-05-24 15:33:57.086959 | booking_header | 9 | payment_proof |
| 3 | WhatsApp Image 2026-05-24 at 10.22.49 AM.jpeg | payment_6a12c571f0537_20260524163129.jpeg | uploads/payment_proofs/payment_6a12c571f0537_20260524163129.jpeg | image/jpeg | 79741 | 0812727273774 | 2026-05-24 16:31:30.253164 | booking_header | 10 | payment_proof |
| 4 | WhatsApp Image 2026-05-24 at 10.22.49 AM.jpeg | payment_6a12c5c26a343_20260524163250.jpeg | uploads/payment_proofs/payment_6a12c5c26a343_20260524163250.jpeg | image/jpeg | 79741 | 0817474741233 | 2026-05-24 16:32:50.436214 | booking_header | 11 | payment_proof |
| 5 | WhatsApp Image 2026-05-24 at 10.22.49 AM.jpeg | payment_6a12d7d85416a_20260524175000.jpeg | uploads/payment_proofs/payment_6a12d7d85416a_20260524175000.jpeg | image/jpeg | 79741 | 08222222222 | 2026-05-24 17:50:00.350908 | booking_header | 12 | payment_proof |
| 6 | WhatsApp Image 2026-05-24 at 10.22.49 AM.jpeg | payment_6a12d8670c0be_20260524175223.jpeg | uploads/payment_proofs/payment_6a12d8670c0be_20260524175223.jpeg | image/jpeg | 79741 | 0812727273774 | 2026-05-24 17:52:23.060267 | booking_header | 13 | payment_proof |
| 7 | WhatsApp Image 2026-05-24 at 10.22.49 AM.jpeg | payment_6a12d95610613_20260524175622.jpeg | uploads/payment_proofs/payment_6a12d95610613_20260524175622.jpeg | image/jpeg | 79741 | 0817474741233 | 2026-05-24 17:56:22.07587 | booking_header | 14 | payment_proof |
| Column | Type | Length | Nullable |
|---|---|---|---|
| notification_id | integer | NO | |
| user_id | integer | NO | |
| notification_type | character varying | 30 | NO |
| title | character varying | 100 | YES |
| message | character varying | 500 | YES |
| action_url | character varying | 255 | YES |
| priority | character varying | 10 | NO |
| sent_via | character varying | 20 | NO |
| is_read | boolean | NO | |
| created_on | timestamp without time zone | NO | |
| read_on | timestamp without time zone | YES | |
| expires_on | timestamp without time zone | YES |
| notification_id | user_id | notification_type | title | message | action_url | priority | sent_via | is_read | created_on | read_on | expires_on |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 6 | approval | New Registration Request | ahmad kurain requested to join the site. | member_approve.php?id=7 | high | in_app | 2026-05-23 15:48:53.166254 | |||
| 2 | 7 | approval | Registration Approved | Your registration has been approved! You can now start using the system. | dashboard_member.php | high | in_app | 2026-05-23 21:54:21.56534 | |||
| 3 | 6 | approval | New Registration Request | subaryadi ahmad requested to join the site. | member_approve.php?id=8 | high | in_app | 2026-05-23 21:55:52.296042 | |||
| 4 | 8 | approval | Registration Approved | Your registration has been approved! You can now start using the system. | dashboard_member.php | high | in_app | 2026-05-23 21:56:27.20386 | |||
| 5 | 7 | booking | New Penawaran: Juni 2026 | A new penawaran is now open for orders. Check it out! | penawaran_view.php?id=1 | high | in_app | 2026-05-23 22:06:26.59914 | |||
| 6 | 8 | booking | New Penawaran: Juni 2026 | A new penawaran is now open for orders. Check it out! | penawaran_view.php?id=1 | high | in_app | 2026-05-23 22:06:26.59914 | |||
| 7 | 7 | booking | New Penawaran: Juni 2026 | A new penawaran is now open for orders. Check it out! | penawaran_view.php?id=2 | high | in_app | 2026-05-23 22:08:12.148501 | |||
| 8 | 8 | booking | New Penawaran: Juni 2026 | A new penawaran is now open for orders. Check it out! | penawaran_view.php?id=2 | high | in_app | 2026-05-23 22:08:12.148501 | |||
| 9 | 7 | booking | New Penawaran: penawaran juni 2026 01 | A new penawaran is now open for orders. Check it out! | penawaran_view.php?id=3 | high | in_app | 2026-05-23 22:39:23.156285 | |||
| 10 | 8 | booking | New Penawaran: penawaran juni 2026 01 | A new penawaran is now open for orders. Check it out! | penawaran_view.php?id=3 | high | in_app | 2026-05-23 22:39:23.156285 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| penawaran_id | integer | NO | |
| penawaran_number | character varying | 50 | NO |
| blanket_id | integer | YES | |
| site_id | integer | NO | |
| supplier_id | integer | NO | |
| supplier_name_snapshot | character varying | 100 | YES |
| title | character varying | 200 | YES |
| start_date | date | NO | |
| close_order_date | date | NO | |
| due_payment_date | date | NO | |
| delivery_date | date | NO | |
| close_date | date | NO | |
| status | character varying | 20 | NO |
| published_on | timestamp without time zone | YES | |
| closed_on | timestamp without time zone | YES | |
| cancelled_reason | character varying | 200 | YES |
| total_amount | numeric | NO | |
| created_by | character varying | 50 | YES |
| created_on | timestamp without time zone | NO | |
| updated_by | character varying | 50 | YES |
| updated_on | timestamp without time zone | YES |
| penawaran_id | penawaran_number | blanket_id | site_id | supplier_id | supplier_name_snapshot | title | start_date | close_order_date | due_payment_date | delivery_date | close_date | status | published_on | closed_on | cancelled_reason | total_amount | created_by | created_on | updated_by | updated_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | P20260523001 | 1 | 1 | Beras Ripah | Juni 2026 | 2026-05-23 | 2026-05-30 | 2026-06-01 | 2026-06-03 | 2026-06-10 | closed | 2026-05-23 22:06:26.59914 | 2026-05-23 22:06:42.404971 | 6430000.00 | adminsby002 | 2026-05-23 22:05:40.868409 | adminsby002 | 2026-05-23 22:06:26.59914 | ||
| 3 | P20260523003 | 1 | 1 | 2 | Toko Beras Nyawang | penawaran juni 2026 01 | 2026-05-23 | 2026-05-30 | 2026-06-01 | 2026-06-03 | 2026-06-10 | closed | 2026-05-23 22:39:23.156285 | 2026-05-24 15:26:06.35464 | 5520000.00 | adminsby002 | 2026-05-23 22:39:14.951297 | adminsby002 | 2026-05-23 22:39:23.156285 | |
| 2 | P20260523002 | 1 | 1 | Beras Ripah | Juni 2026 | 2026-05-25 | 2026-06-01 | 2026-06-03 | 2026-06-05 | 2026-06-12 | closed | 2026-05-23 22:08:12.148501 | 2026-05-24 15:26:10.00183 | 6310000.00 | adminsby002 | 2026-05-23 22:07:54.415029 | adminsby002 | 2026-05-23 22:08:12.148501 | ||
| 4 | P20260524001 | 1 | 2 | Toko Beras Nyawang | P00003-Gelap Nyawang | 2026-05-30 | 2026-06-06 | 2026-06-08 | 2026-06-10 | 2026-06-17 | closed | 2026-05-24 15:31:49.052058 | 2026-05-24 15:37:13.609709 | 240000.00 | adminsby002 | 2026-05-24 15:31:37.674603 | adminsby002 | 2026-05-24 15:31:49.052058 | ||
| 6 | P20260524003 | 3 | 2 | 1 | Beras Ripah | blanket penawaran 005 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | closed | 2026-05-24 17:19:23.250151 | 2026-05-24 17:28:25.35863 | 1200000.00 | adminbdg002 | 2026-05-24 17:19:17.242453 | adminbdg002 | 2026-05-24 17:19:23.250151 | |
| 7 | P20260524004 | 3 | 1 | 2 | Toko Beras Nyawang | blanket penawaran 005 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | cancelled | 800000.00 | adminsby002 | 2026-05-24 17:20:34.542153 | |||||
| 5 | P20260524002 | 1 | 2 | Toko Beras Nyawang | P00031-Juni meriah 2026 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | closed | 2026-05-24 16:26:23.038322 | 2026-05-24 17:37:12.180598 | 990000.00 | adminsby002 | 2026-05-24 16:26:15.685771 | adminsby002 | 2026-05-24 16:26:23.038322 | ||
| 8 | P20260524005 | 5 | 1 | 1 | Beras Ripah | blanket penawaran 105 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | closed | 2026-05-24 17:36:48.756482 | 2026-05-24 17:43:06.629477 | 800000.00 | adminsby002 | 2026-05-24 17:36:42.079292 | adminsby002 | 2026-05-24 17:36:48.756482 | |
| 9 | P20260524006 | 6 | 1 | 1 | Beras Ripah | blanket penawaran 103 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | open | 2026-05-24 17:46:26.515652 | 1050000.00 | adminsby002 | 2026-05-24 17:46:20.297933 | adminsby002 | 2026-05-24 17:46:26.515652 | ||
| 10 | P20260524007 | 6 | 2 | 1 | Beras Ripah | blanket penawaran 103 | 2026-05-24 | 2026-05-31 | 2026-06-02 | 2026-06-04 | 2026-06-11 | open | 2026-05-24 17:47:12.264212 | 2740000.00 | adminbdg002 | 2026-05-24 17:47:06.405439 | adminbdg002 | 2026-05-24 17:47:12.264212 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| penawaran_id | integer | NO | |
| item_id | integer | NO | |
| item_number | integer | NO | |
| description | character varying | 200 | NO |
| image_file_path | character varying | 255 | YES |
| unit_of_measure | character varying | 20 | NO |
| qty_offered | numeric | NO | |
| qty_ordered | numeric | NO | |
| qty_available | numeric | NO | |
| supplier_price | numeric | NO | |
| selling_price | numeric | NO | |
| min_order | numeric | NO | |
| max_order | numeric | YES | |
| status | character varying | 20 | NO |
| penawaran_id | item_id | item_number | description | image_file_path | unit_of_measure | qty_offered | qty_ordered | qty_available | supplier_price | selling_price | min_order | max_order | status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 10 | Beras premium 5 kg | pcs | 50.00 | 0.00 | 50.00 | 56000.00 | 60000.00 | 1.00 | 5.00 | active | |
| 1 | 2 | 20 | Beras biasa 5 kg | pcs | 70.00 | 0.00 | 70.00 | 43000.00 | 49000.00 | 1.00 | 2.00 | active | |
| 3 | 5 | 10 | beras premium 4kg | pcs | 60.00 | 1.00 | 59.00 | 55000.00 | 58000.00 | 1.00 | 3.00 | active | |
| 3 | 6 | 20 | beras ramos 4kg | pcs | 60.00 | 1.00 | 59.00 | 32000.00 | 34000.00 | 1.00 | 3.00 | active | |
| 2 | 3 | 10 | beras premium 7kg | pcs | 50.00 | 2.00 | 48.00 | 55000.00 | 59000.00 | 1.00 | 8.00 | active | |
| 2 | 4 | 20 | beras biasa 7kg | pcs | 70.00 | 1.99 | 68.01 | 45000.00 | 48000.00 | 1.00 | 2.00 | active | |
| 4 | 7 | 10 | Beras prima | pcs | 20.00 | 3.00 | 17.00 | 10000.00 | 12000.00 | 1.00 | 3.00 | active | |
| 5 | 8 | 10 | beras puler | pcs | 20.00 | 3.00 | 17.00 | 10000.00 | 12000.00 | 1.00 | 3.00 | active | |
| 5 | 9 | 20 | beras cianjur | pcs | 30.00 | 4.00 | 26.00 | 20000.00 | 25000.00 | 1.00 | 2.00 | active | |
| 6 | 10 | 10 | beras abrakadabra | pcs | 30.00 | 0.00 | 30.00 | 10000.00 | 15000.00 | 1.00 | 3.00 | active |
| Column | Type | Length | Nullable |
|---|---|---|---|
| view_id | integer | NO | |
| penawaran_id | integer | NO | |
| site_id | integer | NO | |
| viewed_by | integer | YES | |
| ip_address | character varying | 45 | YES |
| user_agent | character varying | 255 | YES |
| viewed_on | timestamp without time zone | NO | |
| source | character varying | 50 | YES |
| Column | Type | Length | Nullable |
|---|---|---|---|
| template_id | integer | NO | |
| report_code | character varying | 20 | NO |
| report_name | character varying | 100 | YES |
| description | character varying | 255 | YES |
| selection_fields | jsonb | YES | |
| output_columns | jsonb | YES | |
| lamp_logic | jsonb | YES | |
| access_roles | character varying | 100 | YES |
| created_on | timestamp without time zone | NO |
| template_id | report_code | report_name | description | selection_fields | output_columns | lamp_logic | access_roles | created_on |
|---|---|---|---|---|---|---|---|---|
| 1 | Report-001 | Site Performance | Site performance overview with member count, booking statistics, and activity metrics. Export: Excel .xlsx | [{"type": "text", "field": "country", "label": "Country"}, {"type": "text", "field": "province", "label": "Province"}, {"type": "text", "field": "city", "label": "City"}, {"type": "select", "field": "site_id", "label": "Site"}, {"type": "text", "field": "site_name", "label": "Site Name"}] | [{"label": "Site Code", "column": "site_code"}, {"label": "Site Name", "column": "site_name"}, {"label": "Country", "column": "country"}, {"label": "Province", "column": "province"}, {"label": "City", "column": "city"}, {"label": "Member Count", "column": "member_count"}, {"label": "Total Bookings", "column": "total_bookings"}, {"label": "Total Revenue", "column": "total_revenue"}, {"label": "Active Penawaran", "column": "active_penawaran"}, {"label": "Status", "column": "status"}] | {"red": {"condition": "member_count < 5"}, "green": {"condition": "member_count >= 10 AND total_bookings > 0"}, "yellow": {"condition": "member_count >= 5 AND member_count < 10"}} | superuser,admin_site | 2026-05-23 15:06:29.508032 |
| 2 | Report-002 | Penawaran Performance | Penawaran performance with item details, reserved quantity, and delivery metrics. | [{"type": "text", "field": "country", "label": "Country"}, {"type": "text", "field": "province", "label": "Province"}, {"type": "text", "field": "city", "label": "City"}, {"type": "select", "field": "site_id", "label": "Site"}, {"type": "text", "field": "site_name", "label": "Site Name"}, {"type": "select", "field": "penawaran_id", "label": "Penawaran"}] | [{"label": "Penawaran #", "column": "penawaran_number"}, {"label": "Site", "column": "site_name"}, {"label": "Supplier", "column": "supplier_name"}, {"label": "Title", "column": "title"}, {"label": "Start Date", "column": "start_date"}, {"label": "Close Order", "column": "close_order_date"}, {"label": "Status", "column": "status"}, {"label": "Total Amount", "column": "total_amount"}, {"label": "Items", "column": "item_count"}, {"label": "Total Booked", "column": "total_booked"}, {"label": "Total Delivered", "column": "total_delivered"}] | {"red": {"condition": "total_booked < total_amount * 0.5"}, "green": {"condition": "total_booked >= total_amount * 0.8"}, "yellow": {"condition": "total_booked >= total_amount * 0.5"}} | superuser,admin_site | 2026-05-23 15:06:29.532766 |
| 3 | Report-003 | Blanket Performance | Blanket penawaran performance with site assignments and utilization metrics. | [{"type": "text", "field": "country", "label": "Country"}, {"type": "text", "field": "province", "label": "Province"}, {"type": "text", "field": "city", "label": "City"}, {"type": "select", "field": "site_id", "label": "Site"}, {"type": "text", "field": "site_name", "label": "Site Name"}, {"type": "select", "field": "blanket_id", "label": "Blanket"}] | [{"label": "Blanket #", "column": "blanket_number"}, {"label": "Supplier", "column": "supplier_name"}, {"label": "Title", "column": "title"}, {"label": "Status", "column": "status"}, {"label": "Sites Assigned", "column": "site_count"}, {"label": "Items", "column": "item_count"}, {"label": "Total Reserved", "column": "total_reserved"}, {"label": "Total Delivered", "column": "total_delivered"}] | {"red": {"condition": "total_delivered < total_reserved * 0.7"}, "green": {"condition": "total_delivered >= total_reserved * 0.9"}, "yellow": {"condition": "total_delivered >= total_reserved * 0.7"}} | superuser,admin_site | 2026-05-23 15:06:29.548988 |
| 4 | Report-004 | Booking Performance | Booking performance with member details, payment status, and delivery tracking. | [{"type": "text", "field": "country", "label": "Country"}, {"type": "text", "field": "province", "label": "Province"}, {"type": "text", "field": "city", "label": "City"}, {"type": "select", "field": "site_id", "label": "Site"}, {"type": "text", "field": "site_name", "label": "Site Name"}, {"type": "select", "field": "booking_id", "label": "Booking"}] | [{"label": "Booking #", "column": "booking_number"}, {"label": "Member", "column": "member_name"}, {"label": "Site", "column": "site_name"}, {"label": "Penawaran", "column": "penawaran_title"}, {"label": "Status", "column": "status"}, {"label": "Total Amount", "column": "total_amount"}, {"label": "Payment", "column": "payment_status"}, {"label": "Created", "column": "created_on"}, {"label": "Items", "column": "item_count"}] | {"red": {"condition": "status IN ('open', 'rejected', 'cancelled')"}, "green": {"condition": "status IN ('received', 'closed')"}, "yellow": {"condition": "status IN ('paid', 'verified', 'preparing', 'delivered')"}} | superuser,admin_site | 2026-05-23 15:06:29.567915 |
| 5 | Report-005 | Supplier Performance | Supplier performance with delivery metrics, cancellation rates, and lamp status. | [{"type": "select", "field": "supplier_id", "label": "Supplier"}, {"type": "text", "field": "supplier_name", "label": "Supplier Name"}, {"type": "date", "field": "date_from", "label": "Date From"}, {"type": "date", "field": "date_to", "label": "Date To"}] | [{"label": "Supplier Code", "column": "supplier_code"}, {"label": "Supplier Name", "column": "supplier_name"}, {"label": "Total Bookings", "column": "total_bookings"}, {"label": "Delivered", "column": "delivered_count"}, {"label": "Cancelled", "column": "cancelled_count"}, {"label": "Cancel Rate %", "column": "cancel_rate"}, {"label": "Total Amount", "column": "total_amount"}, {"label": "Avg Delivery Days", "column": "avg_delivery_days"}, {"label": "Status", "column": "lamp_status"}] | {"red": {"condition": "overdue_delivery > 7 OR cancel_rate > 20"}, "green": {"condition": "overdue_delivery = 0 AND cancel_rate < 10"}, "yellow": {"condition": "overdue_delivery <= 3 OR cancel_rate BETWEEN 10 AND 20"}} | superuser,admin_site | 2026-05-23 15:06:29.589927 |
| 6 | Report-006 | Site Financial Performance | Financial breakdown per site showing total booking, marbot (20%), kas, and supplier amounts. | [{"type": "text", "field": "country", "label": "Country"}, {"type": "text", "field": "province", "label": "Province"}, {"type": "text", "field": "city", "label": "City"}, {"type": "select", "field": "site_id", "label": "Site"}, {"type": "text", "field": "site_name", "label": "Site Name"}] | [{"label": "Site Code", "column": "site_code"}, {"label": "Site Name", "column": "site_name"}, {"label": "Penawaran #", "column": "penawaran_number"}, {"label": "Total Booking", "column": "total_booking_amount"}, {"label": "Marbot (20%)", "column": "marbot_amount"}, {"label": "Kas Amount", "column": "kas_amount"}, {"label": "Supplier Amount", "column": "supplier_amount"}, {"label": "Payment Status", "column": "payment_status"}] | {"red": {"condition": "payment_status = \"pending\" OR kas_amount < 0"}, "green": {"condition": "payment_status = \"confirmed\" AND kas_amount > 0"}, "yellow": {"condition": "payment_status = \"paid\""}} | superuser,admin_site | 2026-05-23 15:06:29.614288 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| site_id | integer | NO | |
| site_code | character varying | 20 | NO |
| site_name | character varying | 50 | NO |
| country | character varying | 40 | YES |
| province | character varying | 50 | YES |
| city | character varying | 50 | YES |
| contact_email | character varying | 100 | YES |
| contact_phone | character varying | 20 | YES |
| website | character varying | 100 | YES |
| bank_name | character varying | 40 | YES |
| bank_account | character varying | 40 | YES |
| gopay_number | character varying | 40 | YES |
| photo_file_path | character varying | 255 | YES |
| member_count | integer | NO | |
| timezone | character varying | 50 | NO |
| status | character varying | 20 | NO |
| description_1 | character varying | 200 | YES |
| description_2 | character varying | 200 | YES |
| description_3 | character varying | 200 | YES |
| description_4 | character varying | 200 | YES |
| add_1 | character varying | 150 | YES |
| add_2 | character varying | 150 | YES |
| add_3 | character varying | 150 | YES |
| add_4 | character varying | 150 | YES |
| add_5 | character varying | 150 | YES |
| add_6 | character varying | 150 | YES |
| created_by | character varying | 50 | YES |
| created_on | timestamp without time zone | NO | |
| updated_by | character varying | 50 | YES |
| updated_on | timestamp without time zone | YES |
| site_id | site_code | site_name | country | province | city | contact_email | contact_phone | website | bank_name | bank_account | gopay_number | photo_file_path | member_count | timezone | status | description_1 | description_2 | description_3 | description_4 | add_1 | add_2 | add_3 | add_4 | add_5 | add_6 | created_by | created_on | updated_by | updated_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SBY001 | Masjid Agung Wonokromo | Indonesia | Jatim | Surabaya | 2212233444 | 2 | Asia/Jakarta | active | superadmin | 2026-05-23 15:26:43.43073 | ||||||||||||||||||
| 2 | JB2001 | Masjid Agung Bandung | Indonesia | Jabar | Bandung | 000302333 | 1 | Asia/Jakarta | active | superadmin | 2026-05-23 15:27:12.364838 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| supplier_id | integer | NO | |
| supplier_code | character varying | 50 | NO |
| supplier_name | character varying | 100 | NO |
| contact_person | character varying | 100 | YES |
| contact_email | character varying | 100 | YES |
| contact_phone | character varying | 20 | YES |
| country | character varying | 40 | YES |
| province | character varying | 50 | YES |
| city | character varying | 50 | YES |
| office_address | character varying | 200 | YES |
| warehouse_address | character varying | 200 | YES |
| tax_id | character varying | 50 | YES |
| bank_name | character varying | 50 | YES |
| bank_account | character varying | 50 | YES |
| status | character varying | 20 | NO |
| created_by | character varying | 50 | YES |
| created_on | timestamp without time zone | NO |
| supplier_id | supplier_code | supplier_name | contact_person | contact_email | contact_phone | country | province | city | office_address | warehouse_address | tax_id | bank_name | bank_account | status | created_by | created_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SUP001 | Beras Ripah | Pak Kumeli | 081199143421 | Kota Bekasi | active | superadmin | 2026-05-23 22:00:37.155324 | ||||||||
| 2 | SUP002 | Toko Beras Nyawang | Pak sobirin | 08122128282 | Majene | active | superadmin | 2026-05-23 22:01:16.040172 | ||||||||
| 3 | SUP005 | Beras Ramos Prima | Dulkalim | 085522122212 | Depok | inactive | superadmin | 2026-05-23 23:14:23.045535 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| payment_id | integer | NO | |
| penawaran_id | integer | NO | |
| supplier_id | integer | NO | |
| site_id | integer | NO | |
| total_booking_amount | numeric | NO | |
| marbot_percentage | numeric | NO | |
| marbot_amount | numeric | NO | |
| kas_amount | numeric | NO | |
| supplier_amount | numeric | NO | |
| status | character varying | 20 | NO |
| paid_by | character varying | 50 | YES |
| paid_on | timestamp without time zone | YES | |
| payment_proof_file_path | character varying | 255 | YES |
| notes | character varying | 500 | YES |
| created_by | character varying | 50 | YES |
| created_on | timestamp without time zone | NO | |
| updated_by | character varying | 50 | YES |
| updated_on | timestamp without time zone | YES | |
| payment_received | numeric | NO |
| payment_id | penawaran_id | supplier_id | site_id | total_booking_amount | marbot_percentage | marbot_amount | kas_amount | supplier_amount | status | paid_by | paid_on | payment_proof_file_path | notes | created_by | created_on | updated_by | updated_on | payment_received |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 4 | 2 | 1 | 36000.00 | 0.2000 | 7200.00 | 0.00 | 30000.00 | paid | adminsby002 | 2026-05-24 16:45:22.794079 | adminsby002 | 2026-05-24 15:36:30.044435 | adminsby002 | 2026-05-24 16:45:22.794079 | 50000.00 | ||
| 1 | 2 | 1 | 1 | 213520.00 | 0.2000 | 42704.00 | 0.00 | 199550.00 | paid | adminsby002 | 2026-05-24 16:45:35.417267 | adminsby002 | 2026-05-24 15:25:19.981958 | adminsby002 | 2026-05-24 16:45:35.417267 | 223999.99 | ||
| 2 | 3 | 2 | 1 | 92000.00 | 0.2000 | 18400.00 | 0.00 | 87000.00 | paid | adminsby002 | 2026-05-24 16:45:47.977836 | adminsby002 | 2026-05-24 15:25:25.23187 | adminsby002 | 2026-05-24 16:45:47.977836 | 150000.00 | ||
| 4 | 5 | 2 | 1 | 136000.00 | 0.2000 | 5200.00 | 104800.00 | 110000.00 | paid | adminsby002 | 2026-05-24 16:46:43.909745 | adminsby002 | 2026-05-24 16:36:08.304531 | adminsby002 | 2026-05-24 16:46:43.909745 | 220000.00 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| assignment_id | integer | NO | |
| supplier_id | integer | NO | |
| user_id | integer | NO | |
| role | character varying | 30 | NO |
| assigned_by | character varying | 50 | YES |
| assigned_on | timestamp without time zone | NO | |
| status | character varying | 20 | NO |
| Column | Type | Length | Nullable |
|---|---|---|---|
| user_id | integer | NO | |
| user_code | character varying | 50 | NO |
| role | character varying | 20 | NO |
| first_name | character varying | 50 | NO |
| last_name | character varying | 50 | YES |
| password_hash | character varying | 255 | NO |
| character varying | 100 | YES | |
| phone | character varying | 20 | NO |
| spouse_phone | character varying | 20 | YES |
| address | character varying | 255 | YES |
| photo_file_path | character varying | 255 | YES |
| status | character varying | 20 | NO |
| email_verified_on | timestamp without time zone | YES | |
| phone_verified_on | timestamp without time zone | YES | |
| last_login_on | timestamp without time zone | YES | |
| failed_login_count | integer | NO | |
| locked_until_on | timestamp without time zone | YES | |
| password_reset_token | character varying | 255 | YES |
| password_reset_expires_on | timestamp without time zone | YES | |
| created_by | character varying | 50 | YES |
| created_on | timestamp without time zone | NO | |
| valid_from_date | date | NO | |
| valid_to_date | date | YES |
| user_id | user_code | role | first_name | last_name | password_hash | phone | spouse_phone | address | photo_file_path | status | email_verified_on | phone_verified_on | last_login_on | failed_login_count | locked_until_on | password_reset_token | password_reset_expires_on | created_by | created_on | valid_from_date | valid_to_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 08222222222 | member | athifah | zakiyyah | $2y$12$LURrv11tEI1zLH3nwLK3teHYkt1iNi/kM8XPY/E6ZNYAg0YcNtQ3K | ifa@gmail.com | 08222222222 | 08222222223 | jl kanayakan a1 | active | 2026-05-24 17:49:07.779414 | 2026-05-24 17:49:16.26074 | 0 | 2026-05-24 17:48:27.224569 | 2026-05-24 | |||||||
| 7 | 0812727273774 | member | ahmad | kurain | $2y$12$WpfoN8C8BojioeZnBQanouOCby4qaNZi03dAwxErv8eF2JHcPUR.6 | firdaus@gmail.com | 0812727273774 | 0812727273772 | jl. bungur 12 wonokromo | active | 2026-05-23 21:54:21.526418 | 2026-05-24 17:50:12.43605 | 0 | 2026-05-23 15:48:53.166254 | 2026-05-23 | |||||||
| 8 | 0817474741233 | member | subaryadi | ahmad | $2y$12$4V64Y2k45KI//KfGPyRRBepFuCFwmbWqCh9zxDcKHzXRT/AI7jH4i | adminsby003@jdjd.com | 0817474741233 | 0817474741232 | jl kutilang 13 paseban wonokromo | active | 2026-05-23 21:56:25.043055 | 2026-05-24 17:55:27.618154 | 0 | 2026-05-23 21:55:52.296042 | 2026-05-23 | |||||||
| 9 | adminbdg002 | admin_site | Kusuma Wijaya | Talinn | $2y$12$EwUfj.xMjQRCTTIXGVUx4OhjBrumTRGp0wMTDKoeXdBCrBmn4uBbS | 081211122211 | active | 2026-05-24 18:00:21.540134 | 0 | superadmin | 2026-05-24 17:15:10.418862 | 2026-05-24 | ||||||||||
| 6 | adminsby002 | admin_site | vita | malik | $2y$12$IvgUhYXP0x.iB.dOa7JFbOEUAo1yKgJ3JA3QI.8gP7WTh//WcmNlq | 0817834572 | active | 2026-05-24 18:01:07.027274 | 0 | superadmin | 2026-05-23 15:31:43.873076 | 2026-05-23 | ||||||||||
| 1 | superadmin | superuser | Super | Administrator | $2y$12$j3oPyTAdONskpz.BptfcOei75b9WglnFJKkUmjQOtsWPYJXjI6/uy | superadmin@g5k.wasiat.org | 081234567890 | active | 2026-05-23 15:05:32.519288 | 2026-05-23 15:05:32.519288 | 2026-05-29 15:06:34.986154 | 0 | 2026-05-23 15:05:32.519288 | 2026-05-23 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| session_id | character varying | 128 | NO |
| user_id | integer | NO | |
| ip_address | character varying | 45 | YES |
| user_agent | character varying | 255 | YES |
| created_on | timestamp without time zone | NO | |
| last_activity_on | timestamp without time zone | YES | |
| is_active | boolean | NO | |
| invalidated_by | character varying | 50 | YES |
| invalidated_on | timestamp without time zone | YES |
| session_id | user_id | ip_address | user_agent | created_on | last_activity_on | is_active | invalidated_by | invalidated_on |
|---|---|---|---|---|---|---|---|---|
| r3d1hijc4b3tjnoaokclan5bl0 | 8 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 23:33:04.798264 | 2026-05-23 23:33:20.217873 | 2026-05-23 23:34:22.024273 | ||
| mvr9lasmfdkvba13mb8m0mbm55 | 6 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 21:56:15.727923 | 2026-05-23 21:56:48.143203 | 2026-05-23 21:57:08.476692 | ||
| h26jh781sdjfbortt9mpck40cp | 1 | 182.2.185.66 | Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Mobile Safari/537.36 | 2026-05-23 16:25:07.383093 | 2026-05-23 16:25:17.345576 | 2026-05-23 17:51:32.068279 | ||
| 4flr55881uf9cae9k1ld1miv17 | 1 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 15:25:44.160822 | 2026-05-23 15:31:44.473919 | 2026-05-23 15:31:57.088292 | ||
| 1mtehdt22l7k2btng4n7dmeddo | 6 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 22:37:38.228549 | 2026-05-23 22:39:42.933312 | 2026-05-23 22:40:00.716438 | ||
| v7trh8fsq8g9ubvioc387se8cc | 6 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 15:32:10.133966 | 2026-05-23 15:32:42.900423 | 2026-05-23 15:46:58.473933 | ||
| pikfjenja3fb06kepctmhjpnba | 1 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 15:21:54.058736 | 2026-05-23 15:23:24.503336 | 2026-05-23 15:23:29.214607 | ||
| cfk7ral27u8a72va4dn10856jo | 1 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 23:13:24.569343 | 2026-05-23 23:25:41.000462 | 2026-05-23 23:25:50.292464 | ||
| 8o5o8kndvcpmovqhsqekecuiu3 | 1 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 15:24:13.413174 | 2026-05-23 15:25:31.152896 | 2026-05-23 15:25:35.463822 | ||
| 0v521dmrevs3jf992rmems98b7 | 1 | 157.85.206.120 | Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36 | 2026-05-23 23:12:42.277873 | 2026-05-23 23:12:50.255152 | 2026-05-23 23:13:05.916848 |
| Column | Type | Length | Nullable |
|---|---|---|---|
| assignment_id | integer | NO | |
| user_id | integer | NO | |
| site_id | integer | NO | |
| role_at_site | character varying | 20 | NO |
| assigned_by | character varying | 50 | YES |
| assigned_on | timestamp without time zone | NO | |
| status | character varying | 20 | NO |
| previous_site_id | integer | YES | |
| transferred_on | timestamp without time zone | YES |
| assignment_id | user_id | site_id | role_at_site | assigned_by | assigned_on | status | previous_site_id | transferred_on |
|---|---|---|---|---|---|---|---|---|
| 1 | 6 | 1 | admin_site | superadmin | 2026-05-23 15:31:43.873076 | active | ||
| 2 | 7 | 1 | member | 2026-05-23 15:48:53.166254 | active | |||
| 3 | 8 | 1 | member | 2026-05-23 21:55:52.296042 | active | |||
| 4 | 9 | 2 | admin_site | superadmin | 2026-05-24 17:15:10.418862 | active | ||
| 5 | 10 | 2 | member | 2026-05-24 17:48:27.224569 | active |