| Nama Kolom | Tipe | Null | Default |
|---|---|---|---|
| id | bigint(20) unsigned | NO | NULL |
| tenant_id | bigint(20) unsigned | NO | NULL |
| plan_id | bigint(20) unsigned | NO | NULL |
| mulai_pada | datetime | YES | NULL |
| berakhir_pada | datetime | YES | NULL |
| harga_disepakati | decimal(15,2) | NO | 0.00 |
| maksimal_warung_snapshot | int(10) unsigned | NO | 1 |
| status | enum('menunggu_pembayaran','menunggu_verifikasi','aktif','kedaluwarsa','dibatalkan') | NO | menunggu_pembayaran |
| catatan_admin | text | YES | NULL |
| dibuat_oleh | bigint(20) unsigned | YES | NULL |
| created_at | timestamp | YES | current_timestamp() |
| updated_at | timestamp | YES | current_timestamp() |
| Nama Kolom | Tipe | Null | Default |
|---|---|---|---|
| id | bigint(20) unsigned | NO | NULL |
| nama_paket | varchar(100) | NO | NULL |
| kode_paket | varchar(50) | NO | NULL |
| harga | decimal(15,2) | NO | 0.00 |
| durasi_hari | int(10) unsigned | NO | 30 |
| maksimal_warung | int(10) unsigned | NO | 1 |
| deskripsi | text | YES | NULL |
| fitur_json | longtext | YES | NULL |
| aktif | tinyint(1) | NO | 1 |
| created_at | timestamp | YES | current_timestamp() |
| updated_at | timestamp | YES | current_timestamp() |
| Nama Kolom | Tipe | Null | Default |
|---|---|---|---|
| id | bigint(20) unsigned | NO | NULL |
| subscription_id | bigint(20) unsigned | NO | NULL |
| kode_pembayaran | varchar(60) | NO | NULL |
| nominal | decimal(15,2) | NO | NULL |
| metode | enum('transfer','qris','tunai','lainnya') | NO | transfer |
| status | enum('menunggu','terverifikasi','ditolak','dikembalikan') | NO | menunggu |
| referensi_pembayaran | varchar(150) | YES | NULL |
| bukti_pembayaran | varchar(255) | YES | NULL |
| dibayar_pada | datetime | YES | NULL |
| diverifikasi_oleh | bigint(20) unsigned | YES | NULL |
| diverifikasi_pada | datetime | YES | NULL |
| catatan | text | YES | NULL |
| created_at | timestamp | YES | current_timestamp() |
| Nama Kolom | Tipe | Null | Default |
|---|---|---|---|
| id | bigint(20) unsigned | NO | NULL |
| kode_tenant | varchar(40) | NO | NULL |
| nama_pemilik | varchar(150) | NO | NULL |
| nama_usaha | varchar(150) | NO | NULL |
| varchar(190) | YES | NULL | |
| telepon | varchar(30) | YES | NULL |
| alamat | text | YES | NULL |
| status | enum('menunggu','aktif','ditangguhkan','ditolak') | NO | menunggu |
| disetujui_oleh | bigint(20) unsigned | YES | NULL |
| disetujui_pada | datetime | YES | NULL |
| catatan_admin | text | YES | NULL |
| created_at | timestamp | YES | current_timestamp() |
| updated_at | timestamp | YES | current_timestamp() |