site_support


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
version BIGINT 19 0
role_id INT 10 null
sys_roles.role_id FKD4E3CED7839C9EC3 R
site_id INT 10 null
site.id FKD4E3CED792D2B99F R
user_id INT 10 null
sys_users.user_id FKD4E3CED728C762A3 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKD4E3CED728C762A3 Performance Asc user_id
FKD4E3CED7839C9EC3 Performance Asc role_id
FKD4E3CED792D2B99F Performance Asc site_id
IX_site_support_unique Must be unique Asc/Asc site_id + role_id

Relationships

Close relationships within degrees of separation