project_plg_round


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_plg_category.round_id FK_project_plg_category_round R
project_plg_recipient.round_id FK_project_plg_recipient_round R
project_plg_required_signature.round_id FK_project_plg_req_sig_round R
name VARCHAR 256 √ null
rank INT 10 √ null
plg_id BIGINT 19 null
project_plg.id FK_project_plg_round_plg R
items_complete BIT 1 √ null
signatures_complete BIT 1 √ null
print_request_date DATETIME 19 √ null
email_sent_date DATETIME 19 √ null
plg_round_id BIGINT 19 √ null
plg_round.id FK_project_plg_round_round R
pdf_file_id BIGINT 19 √ null
project_file.id FK_project_plg_round_pdf R
category_label TEXT 65535 √ null
send_email_requested BIT 1 √ null
disclaimer TEXT 65535 √ null
misc_notes TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_project_plg_round_pdf Performance Asc pdf_file_id
FK_project_plg_round_plg_idx Performance Asc plg_id
FK_project_plg_round_round_idx Performance Asc plg_round_id

Relationships

Close relationships within degrees of separation