survey_response


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
company_type_id INT 10 null
sys_company_types.type_id FK_fp5mvl50ttg02gxfkvmyxi17g R
project_id INT 10 null
project.id FK_21y6p4me43e8qeguo8o7fljv9 R
question_id BIGINT 19 null
survey_question.id FK_7gqks7ck92wbbkr9vn0im46c4 R
respondent_id INT 10 null
sys_users.user_id FK_krba9o9mplas321hyf6da29u4 R
respondent_role_id INT 10 null
sys_roles.role_id FK_n24daevdemv8xenlwxfhijiu3 R
response_time DATETIME 19 √ null
rating INT 10 null
reason TEXT 65535 null
vendor_survey_id BIGINT 19 1

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_7gqks7ck92wbbkr9vn0im46c4 Performance Asc question_id
FK_fp5mvl50ttg02gxfkvmyxi17g Performance Asc company_type_id
FK_krba9o9mplas321hyf6da29u4 Performance Asc respondent_id
FK_n24daevdemv8xenlwxfhijiu3 Performance Asc respondent_role_id
IX_survey_response Performance Asc/Asc/Asc/Asc project_id + company_type_id + respondent_role_id + question_id

Relationships

Close relationships within degrees of separation