SchemaSpy - Table harbinger.public.cms_facility_types

Legend:

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

Indexes:

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