project_plg_category


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_plg_item.category_id FK_project_plg_item_category R
name VARCHAR 256 √ null
rank INT 10 0
plg_id BIGINT 19 null
project_plg.id FK_project_plg_category_project_plg R
background VARCHAR 256 √ null
details TEXT 65535 √ null
round_id BIGINT 19 √ null
project_plg_round.id FK_project_plg_category_round R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_project_plg_category_project_plg_idx Performance Asc plg_id
FK_project_plg_category_round_idx Performance Asc round_id

Relationships

Close relationships within degrees of separation