| org_id |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| created_date |
datetime
|
|
|
|
| last_update_date |
datetime
|
|
|
|
| trans_id |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| no_assets |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| no_laporan_penilaian_assets |
varchar(1000)
|
utf8mb4_general_ci
|
|
|
| name |
varchar(1000)
|
utf8mb4_general_ci
|
|
|
| noiventaris |
varchar(1000)
|
utf8mb4_general_ci
|
|
|
| spesifikasi |
varchar(1000)
|
utf8mb4_general_ci
|
|
|
| serialnumber |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| volume |
double
|
|
|
|
| tahun_perolehan |
varchar(4)
|
utf8mb4_general_ci
|
|
|
| estimasi_penggunaan_day |
float
|
|
|
|
| jenis_id |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| status_id |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| sumber_id |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| location_id |
varchar(36)
|
utf8mb4_general_ci
|
|
|
| air |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| listrik |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| internet |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| vollistrik |
double
|
|
|
|
| operasional |
varchar(1)
|
utf8mb4_general_ci
|
|
|
| tgldibuat |
varchar(24)
|
utf8mb4_unicode_ci
|
|
|
| lastupdatedate |
varchar(24)
|
utf8mb4_unicode_ci
|
|
|
| tglbeli |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| nilai_perolehan |
double
|
|
|
|
| nilai_bunga_pinjaman |
double
|
|
|
|
| nilai_pemeliharaan |
double
|
|
|
|
| nilaibangunanpermeter |
double(17,0)
|
|
|
|
| waktu_depresiasi |
float
|
|
|
|
| waktu_bunga |
float
|
|
|
|
| perolehantahunan |
double(17,0)
|
|
|
|
| perolehanbulanan |
double(17,0)
|
|
|
|
| perolehanharian |
double(17,0)
|
|
|
|
| perolehanpasien |
double(17,0)
|
|
|
|
| pinjamantahunan |
double(17,0)
|
|
|
|
| pinjamanbulanan |
double(17,0)
|
|
|
|
| pinjamanharian |
double(17,0)
|
|
|
|
| pinjamanpasien |
double(17,0)
|
|
|
|
| pemeliharaantahunan |
double(17,0)
|
|
|
|
| pemeliharaanbulanan |
double(17,0)
|
|
|
|
| pemeliharaanharian |
double(17,0)
|
|
|
|
| pemeliharaanpasien |
double(17,0)
|
|
|
|
| costperpasien |
double(17,0)
|
|
|
|
| kategori |
varchar(1000)
|
utf8mb4_general_ci
|
|
|
| statusassets |
varchar(1000)
|
utf8mb4_general_ci
|
|
|
| sumber |
varchar(1000)
|
utf8mb4_general_ci
|
|
|
| dibuatoleh |
varchar(1000)
|
utf8mb4_general_ci
|
|
|
| rincianasset |
mediumtext
|
utf8mb4_general_ci
|
|
|
