program_milestone


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_milestone.dependency_id FK_n5yb1w4xq2r9j7p585rnhu099 R
program_milestone_note.milestone_id FK_m9xd67rojug8txtoh7ke4furi R
version BIGINT 19 null
complete BIT 1 √ null
complete_date DATETIME 19 √ null
completion_percentage INT 10 null
manager_responsible BIT 1 null
program_id BIGINT 19 null
program.id FK_94f1es7fuwfx6eodfhede9sf9 R
responsible_company_contact_id BIGINT 19 √ null
program_company_contact.id FK_6d8hsnvuchj474hq71cu5gj2w R
responsible_contact_id BIGINT 19 √ null
program_contact.id FK_abprjpuypqei0is6se1r1aax7 R
responsible_user_id BIGINT 19 √ null
program_support.id FK_o11rmeid5cspw1jfg0q9dby6r R
scheduled_date DATETIME 19 √ null
type_id BIGINT 19 null
program_milestone_type.id FK_4jm7vjb4gdu4ucse9m3ey608v R
dependency_id BIGINT 19 √ null
program_milestone.id FK_n5yb1w4xq2r9j7p585rnhu099 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_4jm7vjb4gdu4ucse9m3ey608v Performance Asc type_id
FK_6d8hsnvuchj474hq71cu5gj2w Performance Asc responsible_company_contact_id
FK_94f1es7fuwfx6eodfhede9sf9 Performance Asc program_id
FK_abprjpuypqei0is6se1r1aax7 Performance Asc responsible_contact_id
FK_n5yb1w4xq2r9j7p585rnhu099 Performance Asc dependency_id
FK_o11rmeid5cspw1jfg0q9dby6r Performance Asc responsible_user_id

Relationships

Close relationships within degrees of separation