project_sd_group


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sd_name VARCHAR 20 null
sd_group VARCHAR 50 null
group_id INT 10 √ null
dealer_request.project_group_id fk_project_sd_group_id R
milestone_task_program.projectsdgroup_id FK_7uvohkok8buiex03gb1y56jwu R
program.type_id FK_3e48e26m2gno1rdgnndnbvoy0 R
project.prj_program_id FKED904B19D8855999 R
project_support_auto.program_id FK_project_support_auto_program R
srs_program_settings.project_group_id fk_srs_program_settings_project_group_id R
grouping INT 10 √ null
department TEXT 65535 √ null
dynamism TEXT 65535 √ null
dept LONGTEXT 2147483647 √ null
active INT 10 √ null
survey_template_id BIGINT 19 √ null
ivueit_survey_template.id FK_project_sd_group_survey_template_id R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc group_id
FK_project_sd_group_survey_template_id Performance Asc survey_template_id
group_id Performance Asc/Asc group_id + sd_name

Relationships

Close relationships within degrees of separation