| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| activity_progress | activity_progress | ‘initialized’::activity_progress | false | |||
| course_instance_id | uuid | true | ||||
| created_at | timestamp with time zone | now() | false | |||
| deleted_at | timestamp with time zone | true | ||||
| exam_id | uuid | true | ||||
| exercise_id | uuid | false | ||||
| grading_progress | grading_progress | ‘not-ready’::grading_progress | false | |||
| id | uuid | uuid_generate_v4() | false | |||
| reviewing_stage | reviewing_stage | ‘not_started’::reviewing_stage | false | |||
| score_given | real | true | ||||
| selected_exercise_slide_id | uuid | true | ||||
| updated_at | timestamp with time zone | now() | false | |||
| user_id | uuid | false |
| Name | Type | Definition |
|---|---|---|
| course_instance_or_exam_id_set | CHECK | CHECK (((course_instance_id IS NULL) <> (exam_id IS NULL))) |
| user_exercise_states_activity_progress_not_null | n | NOT NULL activity_progress |
| user_exercise_states_created_at_not_null | n | NOT NULL created_at |
| user_exercise_states_exercise_id_not_null | n | NOT NULL exercise_id |
| user_exercise_states_exercise_progress_not_null | n | NOT NULL reviewing_stage |
| user_exercise_states_grading_progress_not_null | n | NOT NULL grading_progress |
| user_exercise_states_id_not_null | n | NOT NULL id |
| user_exercise_states_updated_at_not_null | n | NOT NULL updated_at |
| user_exercise_states_user_id_not_null | n | NOT NULL user_id |
Generated by tbls