facilities


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
appointments.facility_id fk_rails_81e897bb97 R
blood_pressures.facility_id ByRailsConventionConstraint R
blood_sugars.facility_id fk_rails_8e56e1055e R
call_results.facility_id ByRailsConventionConstraint R
cphc_facilities.facility_id ByRailsConventionConstraint R
cphc_facility_mappings.facility_id ByRailsConventionConstraint R
cphc_migration_audit_logs.facility_id ByRailsConventionConstraint R
cphc_migration_error_logs.facility_id ByRailsConventionConstraint R
drug_stocks.facility_id ByRailsConventionConstraint R
encounters.facility_id fk_rails_8df9902cc7 R
facilities_teleconsultation_medical_officers.facility_id ByRailsConventionConstraint R
facility_business_identifiers.facility_id ByRailsConventionConstraint R
patients.assigned_facility_id fk_rails_66733b5dc0 R
patients.registration_facility_id fk_rails_256d8f15cb R
prescription_drugs.facility_id ByRailsConventionConstraint R
questionnaire_responses.facility_id ByRailsConventionConstraint R
teleconsultations.facility_id fk_rails_811d7873b8 R
name varchar 2147483647 √ null
street_address varchar 2147483647 √ null
village_or_colony varchar 2147483647 √ null
district varchar 2147483647 √ null
state varchar 2147483647 √ null
country varchar 2147483647 √ null
pin varchar 2147483647 √ null
facility_type varchar 2147483647 √ null
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
latitude float8 17,17 √ null
longitude float8 17,17 √ null
deleted_at timestamp 29,6 √ null
facility_group_id uuid 2147483647 √ null
facility_groups.id fk_rails_c44117c78f R
slug varchar 2147483647 √ null
zone varchar 2147483647 √ null
enable_diabetes_management bool 1 false
facility_size varchar 2147483647 null
monthly_estimated_opd_load int4 10 √ null
enable_teleconsultation bool 1 false
short_name varchar 2147483647 null
enable_monthly_screening_reports bool 1 false
enable_monthly_supplies_reports bool 1 false

Indexes

Constraint Name Type Sort Column(s)
facilities_pkey Primary key Asc id
index_facilities_on_deleted_at Performance Asc deleted_at
index_facilities_on_enable_diabetes_management Performance Asc enable_diabetes_management
index_facilities_on_facility_group_id Performance Asc facility_group_id
index_facilities_on_slug Must be unique Asc slug
index_facilities_on_updated_at Performance Asc updated_at

Relationships

Close relationships within degrees of separation