| id |
bigint(20)
|
|
|
|
| kode_fasilitas |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| nama_fasilitas |
varchar(200)
|
utf8mb4_unicode_ci
|
|
|
| jenis_fasilitas |
enum('rumah_sakit', 'klinik')
|
utf8mb4_unicode_ci
|
|
|
| kelas_rumah_sakit |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| jenis_klinik |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| kepemilikan |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| provinsi |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| kode_provinsi |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| kabupaten_kota |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| kode_kabupaten_kota |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| kecamatan |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| kelurahan |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| kode_pos |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| alamat |
text
|
utf8mb4_unicode_ci
|
|
|
| telepon |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| email |
varchar(150)
|
utf8mb4_unicode_ci
|
|
|
| website |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| latitude |
decimal(10,7)
|
|
|
|
| longitude |
decimal(10,7)
|
|
|
|
| status_operasional |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| akreditasi |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| sumber_data |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| terakhir_sinkronisasi |
datetime
|
|
|
|
| aktif |
tinyint(1)
|
|
|
|
| dibuat_pada |
timestamp
|
|
|
|
| diperbarui_pada |
timestamp
|
|
|
|