Table harbinger.public.cms_facility_types
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('cms_facility_types_id_seq'::regclass)
site_classes.cms_facility_type_id site_classes_cms_facility_type_fk R
pos_code int8 19
facility_type text 2147483647
cms_facility bool 1
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Column(s) Type Sort Constraint Name
id Primary key Asc cms_facility_type_id
cms_facility Performance Asc cms_facility_type_cms_facility_idx
facility_type Performance Asc cms_facility_type_facilty_type_idx
pos_code Performance Asc cms_facility_type_pos_code_idx

Close relationships  within of separation: