An audio file can be played on a course material page. This table stores data regarding files uploaded to any page by teachers.
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| 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 | A unique, stable identifier for the record. | ||
| mime_type | varchar(32) | false | The mime type of the uploaded file. | |||
| page_id | uuid | false | public.pages | The page the audio files belong to. | ||
| path | varchar(255) | false | The path to the uploaded audio file. |
| Name | Type | Definition |
|---|---|---|
| page_audio_files_page_id_fkey | FOREIGN KEY | FOREIGN KEY (page_id) REFERENCES pages(id) |
| page_audio_files_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| Name | Definition |
|---|---|
| page_audio_files_pkey | CREATE UNIQUE INDEX page_audio_files_pkey ON public.page_audio_files USING btree (id) |
Generated by tbls