Table harbinger.public.claim_transaction_cms_modifiers
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('claim_transaction_cms_modifiers_id_seq'::regclass)
claim_transaction_id int8 19
claim_transactions.id claim_transaction_cms_modifiers_claim_fk R
cms_modifier_id int8 19
cms_modifiers.id claim_transaction_cms_modifiers_modifier_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 claim_transaction_cms_modifier_id
claim_transaction_id Performance Asc claim_transaction_cms_modifiers_claim_transaction_fk
cms_modifier_id Performance Asc claim_transaction_cms_modifiers_modifier_fk

Close relationships  within of separation: