project_note


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
project_id INT 10 null
project.id FK37FE2558FE2B983 R
timestamp DATETIME 19 √ null
user_id INT 10 √ null
sys_users.user_id FK37FE255828C762A3 R
notes TEXT 65535 √ null
private INT 10 √ 0
new_hub VARCHAR 200 √ null
subcategory_id INT 10 √ null
project_note_subcategory.id FK_d2hklp4l4sj6ma7stx7llk7fx R
update_proxy_user_id INT 10 √ null
sys_users.user_id FK_tm1vyu1bq9y6v3vuifo4ai8iy R
update_timestamp DATETIME 19 √ null
update_user_id INT 10 √ null
sys_users.user_id FK_2y4dip11fk3flautkoh31qx2c R
notes_raod TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK37FE255828C762A3 Performance Asc user_id
FK37FE2558FE2B983 Performance Asc project_id
FK_2y4dip11fk3flautkoh31qx2c Performance Asc update_user_id
FK_d2hklp4l4sj6ma7stx7llk7fx Performance Asc subcategory_id
FK_tm1vyu1bq9y6v3vuifo4ai8iy Performance Asc update_proxy_user_id

Relationships

Close relationships within degrees of separation