iterative_note


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
category_id INT 10 null
iterative_note_category.id FK_jea73hx16ls4x7jl0xpoyfbuy R
create_date DATETIME 19 null
created_by_id INT 10 null
sys_users.user_id FK_mlh1tirn7il2x4pmlve9u8pl8 R
created_by_proxy_id INT 10 √ null
sys_users.user_id FK_kwytvlbkpirfdve7r0bx2jash R
last_update_by_id INT 10 null
sys_users.user_id FK_ay4xx489qy1jgv3nbi8lpqpx4 R
last_update_by_proxy_id INT 10 √ null
sys_users.user_id FK_n2221lhag064vj075ian4k1cy R
last_update_date DATETIME 19 null
notes LONGTEXT 2147483647 √ null
project_id INT 10 √ null
project.id FK_qdblridchgeunqrt31hihha4e R
reference_id BIGINT 19 √ null
site_id INT 10 √ null
site.id FK_1rbchtfwnf0ikagy7g1r88vpg R
subcategory_id INT 10 √ null
project_note_subcategory.id FK_2gfks4o7s6jctg8487cqrkx2t R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1rbchtfwnf0ikagy7g1r88vpg Performance Asc site_id
FK_2gfks4o7s6jctg8487cqrkx2t Performance Asc subcategory_id
FK_ay4xx489qy1jgv3nbi8lpqpx4 Performance Asc last_update_by_id
FK_jea73hx16ls4x7jl0xpoyfbuy Performance Asc category_id
FK_kwytvlbkpirfdve7r0bx2jash Performance Asc created_by_proxy_id
FK_mlh1tirn7il2x4pmlve9u8pl8 Performance Asc created_by_id
FK_n2221lhag064vj075ian4k1cy Performance Asc last_update_by_proxy_id
FK_qdblridchgeunqrt31hihha4e Performance Asc project_id

Relationships

Close relationships within degrees of separation