program_milestone_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_milestone.type_id FK_4jm7vjb4gdu4ucse9m3ey608v R
program_milestone_action.milestone_type_id FK_2oki99le54sh0b5nmkd9ekm6l R
program_milestone_type.dependency_id FK_aipncr8pihfshvltcrcmt5g8n R
version BIGINT 19 null
active BIT 1 null
description LONGTEXT 2147483647 √ null
rank INT 10 null
responsible_role_id INT 10 √ null
sys_roles.role_id FK_pu0i08qc6t8bl3i3p2hk7k7jr R
section_id BIGINT 19 null
program_milestone_section.id FK_rxnamks19ah04kkj79hxqn1hr R
title VARCHAR 75 null
dependency_id BIGINT 19 √ null
program_milestone_type.id FK_aipncr8pihfshvltcrcmt5g8n R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_aipncr8pihfshvltcrcmt5g8n Performance Asc dependency_id
FK_pu0i08qc6t8bl3i3p2hk7k7jr Performance Asc responsible_role_id
FK_rxnamks19ah04kkj79hxqn1hr Performance Asc section_id
UK_khpy8nharnuvr6ipqgle8jjdw Must be unique Asc title

Relationships

Close relationships within degrees of separation