Used to figure out which exercises are the same in different course language versions. Each page belongs to one language group though the exercises.exercise_language_group_id column. If two exercises have the same exercise language group, they are the same exercise but in different languages. For finding course language versions itself, please see the table course_language_groups. This table is not used for exercises not related to courses, like exam exercises.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| course_language_group_id | uuid | false | public.course_language_groups | The course language group the courses using these exercises use. Can be used to find the language versions of the courses. | ||
| created_at | timestamp with time zone | now() | false | Timestamp when the record was created. | ||
| deleted_at | timestamp with time zone | true | Timestamp when the record was deleted. If null, the record is not deleted. | |||
| id | uuid | uuid_generate_v4() | false | public.exercises | A unique, stable identifier for the record. | |
| updated_at | timestamp with time zone | now() | false | Timestamp when the record was last updated. The field is updated automatically by the set_timestamp trigger. |
| Name | Type | Definition |
|---|---|---|
| exercise_language_groups_course_language_group_id_fkey | FOREIGN KEY | FOREIGN KEY (course_language_group_id) REFERENCES course_language_groups(id) |
| exercise_language_groups_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| Name | Definition |
|---|---|
| exercise_language_groups_pkey | CREATE UNIQUE INDEX exercise_language_groups_pkey ON public.exercise_language_groups USING btree (id) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.exercise_language_groups FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls