Table harbinger.public.card_reports
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_reports_id_seq'::regclass)
card_cases.current_report_id card_cases_current_report_fk R
card_cases.first_final_report_id card_cases_first_final_report_fk R
card_cases.first_prelim_report_id card_cases_first_prelim_report_fk R
card_cases.first_report_id card_cases_first_report_fk R
card_cases.last_final_report_id card_cases_last_final_report_fk R
card_cases.last_prelim_report_id card_cases_last_prelim_report_fk R
report_body text 2147483647  √  null
body_fts tsvector 2147483647  √  null
report_impression text 2147483647  √  null
impression_fts tsvector 2147483647  √  null
report_status_id int8 19  √  null
external_system_statuses.id card_reports_report_status_fk R
transcriptionist_id int8 19  √  null
employees.id card_reports_transcriptionist_fk R
card1_id int8 19  √  null
employees.id card_reports_card1_fk R
card2_id int8 19  √  null
employees.id card_reports_card2_fk R
card3_id int8 19  √  null
employees.id card_reports_card3_fk R
card4_id int8 19  √  null
employees.id card_reports_card4_fk R
card_case_id int8 19  √  null
card_cases.id card_reports_card_case_fk R
report_event timestamptz 35,6  √  null
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_reports_id
card1_id Performance Asc card_reports_card1_idx
card2_id Performance Asc card_reports_card2_idx
card3_id Performance Asc card_reports_card3_idx
card4_id Performance Asc card_reports_card4_idx
card_case_id Performance Asc card_reports_card_case_idx
report_event Performance Asc card_reports_report_event_idx
report_status_id Performance Asc card_reports_report_status_idx
transcriptionist_id Performance Asc card_reports_transcriptionist_idx
body_fts Performance Asc idx_fts_card_reports_body
impression_fts Performance Asc idx_fts_card_reports_impression

Close relationships  within of separation: