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