Table pricing_tier_assignment
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 int8 19
free_item bool 1
item_id int8 19
item.id fk76d892d16f7f1a9c R
purchase_pricing_tier_id int8 19  √  null
pricing_tier.id fk76d892d14005525b R
subscription_pricing_tier_id int8 19  √  null
pricing_tier.id fk76d892d11deee77 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pricing_tier_assignment_pkey
item_id Performance Asc assignmentitem
purchase_pricing_tier_id Performance Asc assignmentpurchasetier
subscription_pricing_tier_id Performance Asc assignmentsubscriptiontier
item_id Must be unique Asc pricing_tier_assignment_item_id_key

Close relationships  within of separation: