cphc_facilities


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
cphc_facilities.cphc_facility_id ByRailsConventionConstraint R
facility_id uuid 2147483647 √ null
facilities.id ByRailsConventionConstraint R
cphc_facility_id int4 10 √ null
cphc_facilities.id ByRailsConventionConstraint R
cphc_facility_name varchar 2147483647 √ null
cphc_district_id int4 10 √ null
cphc_district_name varchar 2147483647 √ null
cphc_taluka_id int4 10 √ null
cphc_taluka_name varchar 2147483647 √ null
cphc_state_name varchar 2147483647 √ null
cphc_state_id int4 10 √ null
cphc_facility_type varchar 2147483647 √ null
cphc_facility_type_id varchar 2147483647 √ null
cphc_user_details json 2147483647 √ null
deleted_at timestamp 29,6 √ null
created_at timestamp 29,6 null
updated_at timestamp 29,6 null
cphc_location_details json 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
cphc_facilities_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation