assessments

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
assessment_id CHAR 36 null
assessment_choice_answers.assessment_id choice_answers_assessment_id_foreignC
assessment_free_text_answers.assessment_id free_text_answers_assessment_id_foreignC
assessment_organization_choice_answers.assessment_id organization_choice_answers_assessment_id_foreignC
assessment_organization_free_text_answers.assessment_id organization_free_text_answers_assessment_id_foreignC
employee_id CHAR 36 null
created_at BIGINT UNSIGNED 20 unix_timestamp(now())
distribution_id INT UNSIGNED 10 √ null
assessment_distributions.distribution_id assessments_distribution_foreignR

配信ID
organization_id VARCHAR 100 √ null
assessment_distributions.organization_id assessments_distribution_foreignR

組織ID

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc assessment_id
assessments_distribution_foreign Performance Asc/Asc distribution_id + organization_id

Relationships

Close relationships within degrees of separation