image_labels


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('image_labels_id_seq'::regclass)
image_id int4 10 null
images.id image_labels_image_id_foreignC
label_id int4 10 null
labels.id image_labels_label_id_foreignR
user_id int4 10 null
users.id image_labels_user_id_foreignN
created_at timestamp 22 null
updated_at timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
image_labels_pkey Primary key Asc id
image_labels_image_id_index Performance Asc image_id
image_labels_image_id_label_id_unique Must be unique Asc/Asc image_id + label_id
image_labels_label_id_index Performance Asc label_id

Relationships