program_milestone_note


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
milestone_id BIGINT 19 null
program_milestone.id FK_m9xd67rojug8txtoh7ke4furi R
note LONGTEXT 2147483647 null
proxy_user_id INT 10 √ null
sys_users.user_id FK_h1s4pi3nrj9khds2rlu3bhjt1 R
timestamp DATETIME 19 null
user_id INT 10 null
sys_users.user_id FK_jb07xi2c80h4vjkmi2igexp9b R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_h1s4pi3nrj9khds2rlu3bhjt1 Performance Asc proxy_user_id
FK_jb07xi2c80h4vjkmi2igexp9b Performance Asc user_id
FK_m9xd67rojug8txtoh7ke4furi Performance Asc milestone_id

Relationships

Close relationships within degrees of separation