label_tree_user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
label_tree_id int4 10 null
label_trees.id label_tree_user_label_tree_id_foreignC
user_id int4 10 null
users.id label_tree_user_user_id_foreignC
role_id int4 10 null
roles.id label_tree_user_role_id_foreignR

Indexes

Constraint Name Type Sort Column(s)
label_tree_user_label_tree_id_user_id_unique Must be unique Asc/Asc label_tree_id + user_id

Relationships

Close relationships within degrees of separation