project_milestone


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
project_milestone.dependency_id FK_a7svrnqcdi6axm20um3ofp26i R
project_id INT 10 null
project.id FK2C0913CAFE2B983 R
task_id INT 10 null
milestone_tasks.task_id FK2C0913CAF0C07700 R
due_date DATE 10 √ null
scheduled DATE 10 √ null
complete DATE 10 √ null
comments VARCHAR 255 √ null
removed INT 10 √ 0
optional INT 10 √ 0
version BIGINT 19 √ 1
note_required BIT 1 √ null
detail_id INT 10 √ null
milestone_task_detail.id FK_alv8066m70p3qw7t6fw5l4w4n R
dependency_id INT 10 √ null
project_milestone.id FK_a7svrnqcdi6axm20um3ofp26i R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK2C0913CAF0C07700 Performance Asc task_id
FK2C0913CAFE2B983 Performance Asc project_id
FK_a7svrnqcdi6axm20um3ofp26i Performance Asc dependency_id
FK_alv8066m70p3qw7t6fw5l4w4n Performance Asc detail_id
store_id Must be unique Asc/Asc project_id + task_id

Relationships

Close relationships within degrees of separation