milestone_tasks


Columns

Column Type Size Nulls Auto Default Children Parents Comments
task_id INT 10 √ null
milestone_action.milestone_task_id FK1F80E3E569BC731 R
milestone_task_detail.dependency_id FK_6eiey6tcjifyim5isukm4kutg R
milestone_task_detail.task_id FK79905FFCF0C07700 R
milestone_task_log.task_id FK_kfxsu92rc2xlrmkq89qwef3m8 R
notification.complete_on_send_id FK237A88EB1EE1B683 R
notification_scheduled.complete_on_send_id FK5D8D5A591EE1B683 R
project_field.task_id FKC752D854F0C07700 R
project_milestone.task_id FK2C0913CAF0C07700 R
task VARCHAR 75 null
description VARCHAR 500 √ null
section_id INT 10 null
milestone_sections.section_id FK96B423FF2AA21A74 R
major BIT 1 √ null
legal BIT 1 √ null
mobile_eligible BIT 1 √ null
archived BIT 1 b'0'
notes LONGTEXT 2147483647 √ null
backdate_option INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc task_id
FK96B423FF2AA21A74 Performance Asc section_id
task Must be unique Asc task

Relationships

Close relationships within degrees of separation