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