project_plg_required_signature


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_plg_signature.signature_id FK_project_plg_signature_signature R
project_plg_signature_role.signature_id FK_prj_plg_sig_role_signature R
plg_id BIGINT 19 null
project_plg.id FK_project_plg_req_sig_plg R
round_id BIGINT 19 √ null
project_plg_round.id FK_project_plg_req_sig_round R
signature_id BIGINT 19 √ null
plg_signature.id FK_project_plg_req_sig_sig R
name VARCHAR 256 √ null
rank INT 10 √ null
complete BIT 1 √ null
signature_type INT 10 √ null
sys_monitor_types.type Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_project_plg_req_sig_plg_idx Performance Asc plg_id
FK_project_plg_req_sig_round_idx Performance Asc round_id
FK_project_plg_req_sig_sig Performance Asc signature_id

Relationships

Close relationships within degrees of separation