intake_field


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
intake_attachment.field_id fk_intake_attachment_field R
intake_display_field.field_id fk_intake_display_field R
intake_field_value.field_id FK_intake_field_value_field R
name VARCHAR 160 null
prop_name VARCHAR 50 √ null
api_name VARCHAR 50 null
field_type VARCHAR 10 √ null
is_admin_view BIT 1 √ null
is_admin_edit BIT 1 √ null
is_readonly BIT 1 √ null
is_public BIT 1 √ b'1'
lookup_query TEXT 65535 √ null
max_length INT 10 √ null
notify_on_change BIT 1 √ null
is_multi BIT 1 √ b'0'
is_system BIT 1 √ b'0'
is_required BIT 1 √ b'0'
is_admin_update BIT 1 √ b'1'
field_data TEXT 65535 √ null
show_on_create BIT 1 √ b'1'
full_width BIT 1 √ b'0'
help_html TEXT 65535 √ null

Indexes

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

Relationships

Close relationships within degrees of separation