milestone_task_detail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
milestone_task_program.detail_id FK_g5fb2rovtj4rpocelxdrnclqb R
milestone_task_project_type.detail_id FK3CDFA00B270BB200 R
milestone_task_template.detail_id FKC9EDD565270BB200 R
project_milestone.detail_id FK_alv8066m70p3qw7t6fw5l4w4n R
task_id INT 10 null
milestone_tasks.task_id FK79905FFCF0C07700 R
accountable_role_id INT 10 √ null
sys_roles.role_id FK79905FFCABE08F8B R
days INT 10 √ null
optional BIT 1 √ null
rank INT 10 √ null
removed BIT 1 √ null
responsible_role_id INT 10 √ null
sys_roles.role_id FK79905FFCFD6A367A R
note_required BIT 1 √ null
dependency_id INT 10 √ null
milestone_tasks.task_id FK_6eiey6tcjifyim5isukm4kutg R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK79905FFCABE08F8B Performance Asc accountable_role_id
FK79905FFCF0C07700 Performance Asc task_id
FK79905FFCFD6A367A Performance Asc responsible_role_id
FK_6eiey6tcjifyim5isukm4kutg Performance Asc dependency_id

Relationships

Close relationships within degrees of separation