This table stores custom privacy links for specific courses. By default, a generic privacy link is displayed in the website footer, but adding rows to this table allows overriding the default link with course-specific privacy URLs.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| course_id | uuid | false | public.courses | The course ID the privacy link is associated with. | ||
| created_at | timestamp with time zone | now() | false | Timestamp of when the record was created. | ||
| deleted_at | timestamp with time zone | true | Timestamp of when the record was marked as deleted, if applicable. | |||
| id | uuid | uuid_generate_v4() | false | A unique identifier for the privacy link record. | ||
| title | varchar(255) | false | The title or description of the privacy link. | |||
| updated_at | timestamp with time zone | now() | false | Timestamp of the last update, automatically set by the set_timestamp trigger. | ||
| url | text | false | The URL for the privacy link content. |
| Name | Type | Definition |
|---|---|---|
| privacy_links_course_id_fkey | FOREIGN KEY | FOREIGN KEY (course_id) REFERENCES courses(id) |
| privacy_links_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| Name | Definition |
|---|---|
| privacy_links_pkey | CREATE UNIQUE INDEX privacy_links_pkey ON public.privacy_links USING btree (id) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.privacy_links FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls