Table survey.image_attributes
The many-to-many image attribute relation

 Generated by
SchemaSpy
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
imid int 10 0
images.id FK_image_attributes_imid
Image id
aid int 10 0
attributes.id FK_image_attributes_aid
Attribute id

Analyzed at Tue Aug 24 23:21 EDT 2010

Indexes:
Column(s) Type Sort Constraint Name
imid + aid Primary key Asc/Asc PRIMARY
aid Performance Asc IDX_image_attributes_aid

Close relationships  within of separation: