Used to figure out which pages are the same in different course language versions. Each page belongs to one language group though the pages.page_language_group_id column. If two pages have the same page language group, they are the same page but in different languages. For finding course language versions itself, please see the table course_language_groups. This table is not used for pages not related to courses, like exam pages.
| 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 pages 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.pages | 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 |
|---|---|---|
| page_language_groups_course_language_group_id_fkey | FOREIGN KEY | FOREIGN KEY (course_language_group_id) REFERENCES course_language_groups(id) |
| page_language_groups_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| Name | Definition |
|---|---|
| page_language_groups_pkey | CREATE UNIQUE INDEX page_language_groups_pkey ON public.page_language_groups USING btree (id) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.page_language_groups FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls