Table harbinger.public.reasons
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('reasons_id_seq'::regclass)
card_case_details.delay_reason_id card_case_details_delay_reason_fk R
card_case_details.procedure_change_reason_id card_case_details_procedure_change_reason_fk R
card_case_facts.delay_reason_id card_case_facts_delay_reason_fk R
claim_transaction_facts.claim_denial_reason_id claim_transaction_facts_claim_denial_reason_id_fk R
claim_transactions.claim_denial_reason_id claim_transaction_claim_denial_reason_fk R
patient_events.event_reason_id patient_events_event_reason_id_fk R
patient_events_history.event_reason_id patient_events_history_event_reason_fk R
rad_exam_details.delay_reason_id rad_exam_details_delay_reason_fk R
rad_exam_details.procedure_change_reason_id rad_exam_details_procedure_change_reason_fk R
rad_exam_facts.delay_reason_id rad_exam_facts_delay_reason_id_fk R
external_system_id int8 19
external_systems.id reasons_extsys_fk R
reason text 2147483647
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 reasons_id
external_system_id Performance Asc reasons_extsys_id_idx
reason Performance Asc reasons_idx

Close relationships  within of separation: