References to scientific publications of which teachers use in their course materials to refer to.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| citation_key | text | false | Unique citation key for reference, used in course material | |||
| course_id | uuid | false | public.courses | Course the reference belongs to | ||
| created_at | timestamp with time zone | now() | false | |||
| deleted_at | timestamp with time zone | true | ||||
| id | uuid | uuid_generate_v4() | false | |||
| reference | text | false | Reference in bibtex form | |||
| updated_at | timestamp with time zone | now() | false |
| Name | Type | Definition |
|---|---|---|
| citation_key_uniqueness | UNIQUE | UNIQUE NULLS NOT DISTINCT (course_id, citation_key, deleted_at) |
| material_references_citation_key_not_null | n | NOT NULL citation_key |
| material_references_course_id_fkey | FOREIGN KEY | FOREIGN KEY (course_id) REFERENCES courses(id) |
| material_references_course_id_not_null | n | NOT NULL course_id |
| material_references_created_at_not_null | n | NOT NULL created_at |
| material_references_id_not_null | n | NOT NULL id |
| material_references_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| material_references_reference_not_null | n | NOT NULL reference |
| material_references_updated_at_not_null | n | NOT NULL updated_at |
| Name | Definition |
|---|---|
| citation_key_uniqueness | CREATE UNIQUE INDEX citation_key_uniqueness ON public.material_references USING btree (course_id, citation_key, deleted_at) NULLS NOT DISTINCT |
| material_references_course_id_idx | CREATE INDEX material_references_course_id_idx ON public.material_references USING btree (course_id) |
| material_references_pkey | CREATE UNIQUE INDEX material_references_pkey ON public.material_references USING btree (id) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.material_references FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls