project_plg


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_plg_category.plg_id FK_project_plg_category_project_plg R
project_plg_item.plg_id FK_project_plg_item_project_plg R
project_plg_recipient.plg_id FK_project_plg_recipient_project_plg R
project_plg_required_signature.plg_id FK_project_plg_req_sig_plg R
project_plg_round.plg_id FK_project_plg_round_plg R
project_id INT 10 null
project.id FK_plg_project_project R
template_id BIGINT 19 √ null
plg_template.id FK_plg_project_template R
template_version INT 10 √ null
status_id INT 10 null
plg_status.id FK_plg_project_status R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_plg_project_project_idx Performance Asc project_id
FK_plg_project_status_idx Performance Asc status_id
FK_plg_project_template_idx Performance Asc template_id

Relationships

Close relationships within degrees of separation