|
id
|
INT
|
|
|
|
|
tanggal
|
date
|
|
|
|
|
waktu
|
time
|
|
|
|
|
petugas
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
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)
|
utf8mb4_unicode_ci
|
|
|
|
kondisi_ac2
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
kondisi_listrik
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
kondisi_kebersihan
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
kondisi_pintu
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
kondisi_cctv
|
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
|
ada_alarm
|
INT
|
|
|
|
|
ada_banjir
|
INT
|
|
|
|
|
ada_asap
|
INT
|
|
|
|
|
catatan
|
text
|
utf8mb4_unicode_ci
|
|
|
|
status_overall
|
enum('Normal', 'Perhatian', 'Kritis')
|
utf8mb4_unicode_ci
|
|
|
|
created_by
|
INT
|
|
|
|
|
created_at
|
datetime
|
|
|
|
|
updated_at
|
datetime
|
|
|
|
