local_units_healthdata

4985 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('local_units_healthdata_id_seq'::regclass)
local_units_healthdata_blood_services.healthdata_id local_units_healthda_healthdata_id_acf7ce10_fk_local_uniR
local_units_healthdata_general_medical_services.healthdata_id local_units_healthda_healthdata_id_282df0b3_fk_local_uniR
local_units_healthdata_professional_training_facilities.healthdata_id local_units_healthda_healthdata_id_81eac66d_fk_local_uniR
local_units_healthdata_specialized_medical_beyond_primary_level.healthdata_id local_units_healthda_healthdata_id_a5318d17_fk_local_uniR
local_units_localunit.health_id local_units_localuni_health_id_ad8076af_fk_local_uniR
other_affiliation text 2147483647 √ null
focal_point_email varchar 255 √ null
focal_point_phone_number varchar 255 √ null
focal_point_position varchar 255 √ null
other_facility_type text 2147483647 √ null
speciality varchar 255 √ null
is_teaching_hospital bool 1 √ null
is_in_patient_capacity bool 1 √ null
is_isolation_rooms_wards bool 1 √ null
maximum_capacity int4 10 √ null
number_of_isolation_rooms int4 10 √ null
is_warehousing bool 1 √ null
is_cold_chain bool 1 √ null
ambulance_type_a int4 10 √ null
ambulance_type_b int4 10 √ null
ambulance_type_c int4 10 √ null
other_services text 2147483647 √ null
total_number_of_human_resource int4 10 √ null
general_practitioner int4 10 √ null
specialist int4 10 √ null
residents_doctor int4 10 √ null
nurse int4 10 √ null
dentist int4 10 √ null
nursing_aid int4 10 √ null
midwife int4 10 √ null
other_medical_heal bool 1 √ null
other_profiles varchar 200 √ null
feedback text 2147483647 √ null
affiliation_id int8 19 null
local_units_affiliation.id local_units_healthda_affiliation_id_da5ef557_fk_local_uniR
functionality_id int8 19 null
local_units_functionality.id local_units_healthda_functionality_id_b1029a77_fk_local_uniR
health_facility_type_id int8 19 null
local_units_facilitytype.id local_units_healthda_health_facility_type_cf3d7763_fk_local_uniR
hospital_type_id int8 19 √ null
local_units_hospitaltype.id local_units_healthda_hospital_type_id_cfa24340_fk_local_uniR
primary_health_care_center_id int8 19 √ null
local_units_primaryhcc.id local_units_healthda_primary_health_care__f444b85e_fk_local_uniR
created_by_id int4 10 √ null
auth_user.id local_units_healthdata_created_by_id_5d14b960_fk_auth_user_idR
modified_at timestamptz 35,6 null
modified_by_id int4 10 √ null
auth_user.id local_units_healthdata_modified_by_id_74f4b945_fk_auth_user_idR
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
local_units_healthdata_pkey Primary key Asc id
local_units_healthdata_affiliation_id_da5ef557 Performance Asc affiliation_id
local_units_healthdata_created_by_id_5d14b960 Performance Asc created_by_id
local_units_healthdata_functionality_id_b1029a77 Performance Asc functionality_id
local_units_healthdata_health_facility_type_id_cf3d7763 Performance Asc health_facility_type_id
local_units_healthdata_hospital_type_id_cfa24340 Performance Asc hospital_type_id
local_units_healthdata_modified_by_id_74f4b945 Performance Asc modified_by_id
local_units_healthdata_primary_health_care_center_id_f444b85e Performance Asc primary_health_care_center_id

Relationships

Close relationships within degrees of separation