Feedback360 Resp Assignment Table Schema (feedback360_resp_assignment)


Description

feedback360 responders assignments

feedback360_resp_assignment table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
feedback360_scale_data.feedback360respassignmentid feedscaldata_fee5_fk R
feedback360userassignmentid BIGINT 19 null
feedback360_user_assignment.id feedrespassi_fee3_fk R
userid BIGINT 19 null
user.id feedrespassi_use2_fk R
timeassigned BIGINT 19 null
timecompleted BIGINT 19 0
viewed BIT 1 0
feedback360emailassignmentid BIGINT 19 √ null
feedback360_email_assignment.id feedrespassi_fee4_fk R

Email assignments
requestertoken VARCHAR 40

Table contained -1 rows

feedback360_resp_assignment table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
feedrespassi_fee2_ix Performance Asc feedback360emailassignmentid
feedrespassi_fee_ix Performance Asc feedback360userassignmentid
feedrespassi_use_ix Performance Asc userid

feedback360_resp_assignment table relationships

Close relationships within degrees of separation