SchemaSpy - Table harbinger.public.sites

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('sites_id_seq'::regclass)

card_case_facts.site_id	card_case_facts_site_fk R
card_cases.site_id	card_cases_site_fk R
claim_transaction_facts.site_id	claim_transaction_facts_site_id_fk R
claims.site_id	claim_site_fk R
metasite_associations.site_id	sites_metasite_associations_fk R
orders.site_id	orders_site_fk R
rad_exam_departments.site_id	rad_exam_depts_site_fk R
rad_exam_facts.scheduling_site_id	rad_exam_facts_scheduling_site_id_fk R
rad_exam_facts.site_id	rad_exam_facts_site_id_fk R
rad_exams.site_id	rad_exam_site_fk R
radonc_cases.site_id	radonc_cases_site_fk R
resources.site_id	resource_site_fk R
scheduling_task_groupings.site_id	scheduling_task_site_fk R
services.site_id	services_site_fk R
site_classes.site_id	sites_site_classes_fk R
site_locations.site_id	site_location_fk R
visits.site_id	visits_site_fk R

site

text

2147483647

name

text

2147483647

√

null

cms_gpci_id

int8

19

√

null

cms_gpci.id

site_cms_gpci_fk R

cms_facility

bool

1

√

null

application_visible

bool

1

true

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	site_id
cms_gpci_id	Performance	Asc	fki_site_cms_gpci_fk
site	Performance	Asc	site_idx