ivueit_survey_request


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_id INT 10 √ null
project.id FK_survey_request_project_id R
request_id VARCHAR 256 √ null
site_id INT 10 √ null
site.id FK_survey_request_site_id R
status VARCHAR 255 null
template_id BIGINT 19 null
ivueit_survey_template.id FK_survey_request_survey_template_id R
requested_by_id INT 10 √ null
sys_users.user_id FK_survey_request_requested_by_id R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_survey_request_project_id Performance Asc project_id
FK_survey_request_requested_by_id Performance Asc requested_by_id
FK_survey_request_site_id Performance Asc site_id
FK_survey_request_survey_template_id Performance Asc template_id

Relationships

Close relationships within degrees of separation