Feedback Completed History Table Schema (feedback_completed_history)


Description

history of filled out feedback

feedback_completed_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
feedback_value_history.completed feedvaluhist_com2_fk R
feedback BIGINT 19 0
feedback.id feedcomphist_fee2_fk R
userid BIGINT 19 0
user.id feedcomphist_use2_fk R
timemodified BIGINT 19 0
random_response BIGINT 19 0
anonymous_response BIT 1 0
timearchived BIGINT 19 null
idarchived BIGINT 19 null

Table contained -1 rows

feedback_completed_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
feedcomphist_fee_ix Performance Asc feedback
feedcomphist_use_ix Performance Asc userid

feedback_completed_history table relationships

Close relationships within degrees of separation