favorite_stores

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 20 √ null
user_id VARCHAR 128 null
users.id fk_favorite_stores_user_id R
store_id VARCHAR 36 null
stores.id fk_favorite_stores_store_id R
created_at TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_favorite_stores_store_id Performance Asc store_id
idx_favorite_stores_unique Must be unique Asc/Asc user_id + store_id

Relationships

Close relationships within degrees of separation