customer_discount

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_id VARCHAR 36 null
customer.id FK_CD25F7219395C3F3C
discount_id VARCHAR 36 null
discount.id FK_CD25F7214C7C611FC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc customer_id + discount_id
IDX_CD25F7214C7C611F Performance Asc discount_id
IDX_CD25F7219395C3F3 Performance Asc customer_id

Relationships

Close relationships within degrees of separation