image_to_tags


Columns

Column Type Size Nulls Auto Default Children Parents Comments
image_id INT 10 null
images.id image_to_tag_ibfk_imageC
imagetag_id INT 10 null
imagetags.id image_to_tag_ibfk_imagetagC
created_on DATETIME 26 √ CURRENT_TIMESTAMP
updated_on TIMESTAMP 26 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc image_id + imagetag_id
image_to_tag_ibfk_imagetag Performance Asc imagetag_id

Relationships

Close relationships within degrees of separation