| institution_id | int(11) |
|
|
|
| institution_group_id | char(2) |
|
|
|
| institution_code | varchar(15) |
|
|
|
| institution_registration_code | varchar(15) |
|
|
|
| institution_name | varchar(36) |
|
|
|
| institution_province_code | varchar(2) |
|
|
|
| institution_city_code | varchar(5) |
|
|
|
| institution_address | varchar(250) |
|
|
|
| institution_district_code | varchar(7) |
|
|
|
| institution_district_name | varchar(31) |
|
|
|
| institution_city_name | varchar(26) |
|
|
|
| institution_province_name | varchar(19) |
|
|
|
| institution_care_code | int(11) |
|
|
|
| institution_area_characteristic_code | int(11) |
|
|
|
| institution_publication_date | date |
|
|
|
| institution_type | varchar(14) |
|
|
|
| institution_class | varchar(2) |
|
|
|
| institution_ownership_id | varchar(2) |
|
|
|
| institution_ownership_name | varchar(30) |
|
|
|
| institution_director | varchar(100) |
|
|
|
| institution_director_email | varchar(100) |
|
|
|
| institution_email | varchar(100) |
|
|
|
| institution_specialize | varchar(5) |
|
|
|
| institution_is_education | char(1) |
|
|
|
| institution_is_partnership | int(11) |
|
|
0
|
| institution_partnership_ed | date |
|
|
|
| institution_total_bed | varchar(5) |
|
|
|
| institution_start_date | date |
|
|
|
| institution_operational_number | varchar(100) |
|
|
|
| institution_operational_date_end | date |
|
|
|
| institution_ipal_number | varchar(100) |
|
|
|
| institution_ipal_date_end | date |
|
|
|
| institution_waste_number | varchar(100) |
|
|
|
| institution_waste_date_end | date |
|
|
|
| institution_distance | varchar(250) |
|
|
|
| institution_other_information | text |
|
|
|
| institution_longitude | varchar(30) |
|
|
|
| institution_latitude | varchar(30) |
|
|
|
| institution_accreditation_status | int(11) |
|
|
|
| institution_accreditation_status_date | date |
|
|
|
| institution_accreditation_expired | date |
|
|
|
| institution_insert_date | datetime |
|
|
|
| institution_insert_by | varchar(6) |
|
|
|
| institution_update_date | datetime |
|
|
|
| institution_update_by | varchar(6) |
|
|
|
| institution_delete_date | datetime |
|
|
|
| institution_delete_by | varchar(6) |
|
|
|
| institution_record_status | char(1) |
|
|
A
|