chapter_image_path |
varchar(255) |
|
true |
|
|
Chapter image path is converted to chapter image url once fetched from database. |
chapter_number |
integer |
|
false |
|
|
|
color |
varchar(128) |
|
true |
|
|
Color of the chapter in the front page. |
copied_from |
uuid |
|
true |
|
public.chapters |
The original chapter record of a copy. |
course_id |
uuid |
|
false |
|
public.courses public.course_modules |
Which course this chapter belongs to. |
course_module_id |
uuid |
|
false |
|
public.course_modules |
The module the chapter is a part of. If null, the chapter is part of the default module. |
created_at |
timestamp with time zone |
now() |
false |
|
|
Timestamp when the record was created |
deadline |
timestamp with time zone |
|
true |
|
|
The deadline for all the exercises in the chapter. |
deleted_at |
timestamp with time zone |
|
true |
|
|
Timestamp when the record was deleted. If null, the record is not deleted. |
front_page_id |
uuid |
|
true |
|
public.pages |
Page which is the front page of the chapter i.e. the page where the students end up when they select a chapter in the course material. |
id |
uuid |
uuid_generate_v4() |
false |
public.chapters public.exercises public.pages |
|
A unique, stable identifier for the record. |
name |
varchar(255) |
|
false |
|
|
A human readable name of the chapter. Shown in the chapter lists. |
opens_at |
timestamp with time zone |
|
true |
|
|
If set, the chapter is closed to students before the timestamp and opens automatically at the given time. Students are informed of the opening time. If null, the chapter is always open. |
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. |