project_support_auto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
user_id INT 10 null
sys_users.user_id FK_project_support_auto_user R
role_id INT 10 null
sys_roles.role_id FK_project_support_auto R
program_id INT 10 √ null
project_sd_group.group_id FK_project_support_auto_program R
project_type_id BIGINT 19 √ null
project_type.id FK_project_support_auto_project_type R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IX_project_support_auto_key Performance Asc/Asc/Asc role_id + program_id + project_type_id
IX_project_support_auto_program Performance Asc program_id
IX_project_support_auto_role Performance Asc role_id
IX_project_support_auto_type Performance Asc project_type_id
IX_project_support_auto_user Performance Asc user_id

Relationships

Close relationships within degrees of separation