Table harbinger.public.card_cases
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('card_cases_id_seq'::regclass)
card_case_authorizations.card_case_id card_case_authorizations_card_case_fk R
card_case_claim_transactions.card_case_id card_case_claim_transactions_card_case_fk R
card_case_claims.card_case_id card_case_claims_card_case_fk R
card_case_details.card_case_id card_case_details_card_case_fk R
card_case_facts.card_case_id card_case_facts_card_case_fk R
card_case_metadata.card_case_id card_case_metadata_card_case_fk R
card_case_metrics.card_case_id card_case_metrics_card_case_fk R
card_case_personnel.card_case_id card_case_personnel_card_case_fk R
card_case_procedure_mappings.card_case_id card_case_procedure_mappings_card_case_fk R
card_case_times.card_case_id card_case_times_card_case_fk R
card_reports.card_case_id card_reports_card_case_fk R
dicom_studies.card_case_id dicom_studies_card_case_fk R
accession text 2147483647
external_system_id int8 19
external_systems.id card_cases_external_system_fk R
order_id int8 19  √  null
orders.id card_cases_order_fk R
visit_id int8 19  √  null
visits.id card_cases_visit_fk R
patient_mrn_id int8 19
patient_mrns.id card_cases_patient_mrn_fk R
site_class_id int8 19  √  null
site_classes.id card_cases_site_class_fk R
site_sublocation_id int8 19  √  null
site_sublocations.id card_cases_site_sublocation_fk R
resource_id int8 19  √  null
resources.id card_cases_resource_fk R
case_priority_id int8 19  √  null
exam_priorities.id card_cases_case_priority_fk R
service_id int8 19  √  null
services.id card_cases_service_fk R
first_prelim_report_id int8 19  √  null
card_reports.id card_cases_first_prelim_report_fk R
last_prelim_report_id int8 19  √  null
card_reports.id card_cases_last_prelim_report_fk R
first_final_report_id int8 19  √  null
card_reports.id card_cases_first_final_report_fk R
last_final_report_id int8 19  √  null
card_reports.id card_cases_last_final_report_fk R
current_status_id int8 19
external_system_statuses.id card_cases_current_status_fk R
first_report_id int8 19  √  null
card_reports.id card_cases_first_report_fk R
current_report_id int8 19  √  null
card_reports.id card_cases_current_report_fk R
site_id int8 19
sites.id card_cases_site_fk R
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 card_cases_id
accession Performance Asc card_cases_acc_idx
external_system_id Performance Asc card_cases_accextsys_idx
current_report_id Performance Asc card_cases_currentreportid_idx
current_status_id Performance Asc card_cases_currentstatus_idx
accession + external_system_id Performance Asc/Asc card_cases_dm_idx
first_final_report_id Performance Asc card_cases_firstfinalreportid_idx
first_prelim_report_id Performance Asc card_cases_firstprelimreportid_idx
first_report_id Performance Asc card_cases_firstreportid_idx
last_final_report_id Performance Asc card_cases_lastfinalreportid_idx
last_prelim_report_id Performance Asc card_cases_lastprelimreportid_idx
order_id Performance Asc card_cases_orderid_idx
patient_mrn_id Performance Asc card_cases_patient_mrn_id_idx
case_priority_id Performance Asc card_cases_priority_idx
resource_id Performance Asc card_cases_res_idx
service_id Performance Asc card_cases_service_idx
site_id Performance Asc card_cases_site_idx
site_sublocation_id Performance Asc card_cases_site_sublocation_idx
site_class_id Performance Asc card_cases_siteclass_idx
visit_id Performance Asc card_cases_visit_idx

Close relationships  within of separation: