Table harbinger.public.card_case_metadata
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_case_metadata_id_seq'::regclass)
metadata text 2147483647
card_case_metadata_type_id int8 19 card_case_metadata_exam_metadata_type_fk R
card_case_id int8 19 card_case_metadata_card_case_fk R
external_system_id int8 19 card_case_metadata_external_system_fk R
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Column(s) Type Sort Constraint Name
id Primary key Asc card_case_metadata_id
card_case_id Performance Asc card_case_metadata_card_case_id_idx
card_case_metadata_type_id Performance Asc card_case_metadata_card_case_metadata_type_id_idx
card_case_id + card_case_metadata_type_id + external_system_id Performance Asc/Asc/Asc card_case_metadata_dm_idx
external_system_id Performance Asc card_case_metadata_external_system_id_idx

Close relationships  within of separation: