|
id
|
INT
|
|
|
|
|
no_inventaris
|
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
|
jenis_aset
|
enum('Medis', 'Non-Medis')
|
utf8mb4_unicode_ci
|
|
|
|
nama_aset
|
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
|
kategori
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
merek
|
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
|
model_aset
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
serial_number
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
no_aset_rs
|
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
|
kondisi
|
enum('Baik', 'Dalam Perbaikan', 'Rusak', 'Tidak Aktif')
|
utf8mb4_unicode_ci
|
|
|
|
status_pakai
|
enum('Terpakai', 'Tidak Terpakai', 'Dipinjam')
|
utf8mb4_unicode_ci
|
|
|
|
bagian_id
|
INT
|
|
|
|
|
lokasi
|
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
|
pj_user_id
|
INT
|
|
|
|
|
penanggung_jawab
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
tanggal_beli
|
date
|
|
|
|
|
harga_beli
|
INT
|
|
|
|
|
sumber_dana
|
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
|
no_bast
|
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
|
garansi_sampai
|
date
|
|
|
|
|
tgl_kalibrasi_terakhir
|
date
|
|
|
|
|
tgl_kalibrasi_berikutnya
|
date
|
|
|
|
|
no_sertifikat_kalibrasi
|
varchar(80)
|
utf8mb4_unicode_ci
|
|
|
|
tgl_service_terakhir
|
date
|
|
|
|
|
tgl_service_berikutnya
|
date
|
|
|
|
|
vendor_service
|
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
|
keterangan
|
text
|
utf8mb4_unicode_ci
|
|
|
|
created_by
|
INT
|
|
|
|
|
created_at
|
datetime
|
|
|
|
|
updated_at
|
datetime
|
|
|
|
