Feedback Item Table Schema (feedback_item)


Description

feedback_items

feedback_item table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
feedback_value.item feedvalu_ite3_fk R
feedback_value_history.item feedvaluhist_ite2_fk R
feedback_valuetmp.item feedvalu_ite4_fk R
feedback BIGINT 19 0
feedback.id feeditem_fee2_fk R
template BIGINT 19 0
feedback_template.id feeditem_tem2_fk R
name VARCHAR 255
label VARCHAR 255
presentation LONGTEXT 2147483647 null
typ VARCHAR 255
hasvalue BIT 1 0
position SMALLINT 5 0
required BIT 1 0
dependitem BIGINT 19 0
dependvalue VARCHAR 255
options VARCHAR 255

Table contained -1 rows

feedback_item table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
feeditem_fee_ix Performance Asc feedback
feeditem_tem_ix Performance Asc template

feedback_item table relationships

Close relationships within degrees of separation