| id | int(10) unsigned |
|
|
|
| tanggal | date |
|
|
|
| waktu | time |
|
|
|
| petugas | varchar(100) |
|
|
|
| suhu_in | decimal(5,2) |
|
|
|
| suhu_out | decimal(5,2) |
|
|
|
| kelembaban | decimal(5,2) |
|
|
|
| tegangan_pln | decimal(7,2) |
|
|
|
| tegangan_ups | decimal(7,2) |
|
|
|
| beban_ups | decimal(5,2) |
|
|
|
| baterai_ups | decimal(5,2) |
|
|
|
| kondisi_ac1 | varchar(50) |
|
|
Normal
|
| kondisi_ac2 | varchar(50) |
|
|
Normal
|
| kondisi_listrik | varchar(50) |
|
|
Normal
|
| kondisi_kebersihan | varchar(50) |
|
|
Bersih
|
| kondisi_pintu | varchar(50) |
|
|
Terkunci
|
| kondisi_cctv | varchar(50) |
|
|
Normal
|
| ada_alarm | tinyint(1) |
|
|
0
|
| ada_banjir | tinyint(1) |
|
|
0
|
| ada_asap | tinyint(1) |
|
|
0
|
| catatan | text |
|
|
|
| status_overall | enum | -- |
|
Normal
|
| created_by | int(10) unsigned |
|
|
|
| created_at | datetime |
|
|
current_timestamp()
|
| updated_at | datetime |
|
|
|