| id |
int(11)
|
|
|
|
| tenant_id |
int(11)
|
|
|
|
| production_number |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| production_type |
enum('ternak', 'sawit', 'padi', 'karet')
|
utf8mb4_general_ci
|
|
|
| production_date |
date
|
|
|
|
| location_id |
int(11)
|
|
|
|
| location_code |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| location_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| ternak_jumlah_ayam |
int(11)
|
|
|
|
| ternak_telur_butir |
int(11)
|
|
|
|
| ternak_telur_kg |
decimal(10,2)
|
|
|
|
| ternak_telur_pecah |
int(11)
|
|
|
|
| ternak_mortalitas |
int(11)
|
|
|
|
| ternak_pakan_kg |
decimal(10,2)
|
|
|
|
| sawit_tonase_tbs |
decimal(10,2)
|
|
|
|
| sawit_berat_rerata |
decimal(10,2)
|
|
|
|
| sawit_jumlah_tandan |
int(11)
|
|
|
|
| sawit_kualitas |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| padi_hasil_panen |
decimal(10,2)
|
|
|
|
| pci_produktivitas |
decimal(10,2)
|
|
|
|
| pci_luas_lahan |
decimal(10,2)
|
|
|
|
| pci_bibit_kg |
decimal(10,2)
|
|
|
|
| karet_hasil_getah |
decimal(10,2)
|
|
|
|
| karet_kadar_karet |
decimal(5,2)
|
|
|
|
| karet_jumlah_pohon |
int(11)
|
|
|
|
| total_quantity |
decimal(12,2)
|
|
|
|
| unit |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| status |
enum('pending', 'confirmed', 'cancelled')
|
utf8mb4_general_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|