| id | int(10) unsigned |
|
|
|
| profile_id | int(10) unsigned |
|
|
|
| short_name | varchar(80) |
|
|
|
| hospital_type | varchar(80) |
|
|
|
| hospital_class | varchar(40) |
|
|
|
| ownership_status | varchar(100) |
|
|
|
| legal_entity | varchar(180) |
|
|
|
| hospital_code | varchar(80) |
|
|
|
| satusehat_org_id | varchar(120) |
|
|
|
| nib | varchar(80) |
|
|
|
| npwp | varchar(40) |
|
|
|
| permit_issued_at | date |
|
|
|
| permit_expires_at | date |
|
|
|
| accreditation_status | varchar(80) |
|
|
|
| accreditation_level | varchar(80) |
|
|
|
| accreditation_body | varchar(160) |
|
|
|
| accreditation_issued_at | date |
|
|
|
| accreditation_expires_at | date |
|
|
|
| emergency_phone | varchar(80) |
|
|
|
| whatsapp | varchar(80) |
|
|
|
| website | varchar(255) |
|
|
|
| latitude | varchar(32) |
|
|
|
| longitude | varchar(32) |
|
|
|
| emergency_24h | tinyint(1) |
|
|
0
|
| operating_hours | varchar(255) |
|
|
|
| featured_services | text |
|
|
|
| tagline | varchar(180) |
|
|
|
| created_by | varchar(120) |
|
|
|
| created_at | datetime |
|
|
2026-10-04 20:10:52.000000
|
| updated_by | varchar(120) |
|
|
|
| updated_at | datetime |
|
|
2026-10-04 20:10:52.000000
|