project_note_subcategory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
iterative_note.subcategory_id FK_2gfks4o7s6jctg8487cqrkx2t R
project_field_pending_change_request.subcategory_id FK_project_field_pending_change_subcategory R
project_note.subcategory_id FK_d2hklp4l4sj6ma7stx7llk7fx R
version BIGINT 19 null
active BIT 1 null
category_id INT 10 null
project_note_category.id FK_serty8byymhmjot4mf25ei01h R
name VARCHAR 50 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
unique_name Must be unique Asc/Asc category_id + name

Relationships

Close relationships within degrees of separation