project_form


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
project_form_action.form_id FK6B2015EB82389340 R
project_form_field.form_id FK1441BEA582389340 R
project_form_layout_cell.form_id FKE91A2C282389340 R
project_form_log.form_id FK_scf4nfhk38nr9hkfmvv9m9aup R
project_form_section.form_id fk_form_section_form R
project_form_validation.form_id FK9F2AFDAE82389340 R
sitepack_approval_type.form_id FK_mnul0ik4se7fgj22bgycj66wv R
workflow_type.form_id FK44116FBA82389340 R
name VARCHAR 40 null
description VARCHAR 400 √ null
code VARCHAR 10 √ null
edit_links INT 10 √ 0
options VARCHAR 500 √ null
email_to INT 10 √ 0
attachment1 VARCHAR 40 √ null
attachment2 VARCHAR 40 √ null
attachment3 VARCHAR 40 √ null
attachment4 VARCHAR 40 √ null
attachment5 VARCHAR 40 √ null
header INT 10 √ 1
customization LONGTEXT 2147483647 √ null
type VARCHAR 50 √ UPDATE
bulk_eligible BIT 1 √ null
stay_on_page BIT 1 √ null
eligibility VARCHAR 500 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
code Must be unique Asc code
name Must be unique Asc name

Relationships

Close relationships within degrees of separation