project_support


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
project_id INT 10 null
project.id FK2C648A9FE2B983 R
role_id INT 10 null
sys_roles.role_id FK2C648A9839C9EC3 R
user_id INT 10 null
sys_users.user_id FK2C648A928C762A3 R
version BIGINT 19 √ 1
auto_assigned BIT 1 b'0'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK2C648A928C762A3 Performance Asc user_id
FK2C648A9839C9EC3 Performance Asc role_id
FK2C648A9FE2B983 Performance Asc project_id
IX_project_support_role_user Performance Asc/Asc/Asc project_id + role_id + user_id

Relationships

Close relationships within degrees of separation