Feedback360 Table Schema (feedback360)


Description

360 feedback360 form (recipients - feedback360_RECIPIENT_* bitmask).

feedback360 table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
feedback360_grp_cohort.feedback360id feedgrpcoho_fee2_fk R
feedback360_grp_org.feedback360id feedgrporg_fee2_fk R
feedback360_grp_pos.feedback360id feedgrppos_fee2_fk R
feedback360_quest_field.feedback360id feedquesfiel_fee2_fk R
feedback360_user_assignment.feedback360id feeduserassi_fee2_fk R
name VARCHAR 255
description LONGTEXT 2147483647 √ null
status BIT 1 0
userid BIGINT 19 null
user.id feed_use2_fk R
recipients INT 10 0
anonymous BIT 1 0
selfevaluation TINYINT 3 1

Table contained -1 rows

feedback360 table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
feed_nam_ix Performance Asc name
feed_use_ix Performance Asc userid

feedback360 table relationships

Close relationships within degrees of separation