gift_photo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
photo_id INT UNSIGNED 10 null
photos.id gift_photo_photo_id_foreign C
gift_id INT UNSIGNED 10 null
gifts.id gift_photo_gift_id_foreign C
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc photo_id + gift_id
gift_photo_gift_id_foreign Performance Asc gift_id

Relationships

Close relationships within degrees of separation