Shareable-link tokens for existing exercise slide submissions (the share capability behind the exercise-services client share endpoint).
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| created_at | timestamp with time zone | now() | false | Timestamp when the share was created. | ||
| created_by | uuid | false | public.users | User who created the share. | ||
| deleted_at | timestamp with time zone | true | Soft delete timestamp. Null means active (revoked shares are soft-deleted). | |||
| exercise_slide_submission_id | uuid | false | public.exercise_slide_submissions | The submission this share links to. | ||
| id | uuid | gen_random_uuid() | false | Unique, unguessable token; forms part of the shareable submission URL. | ||
| updated_at | timestamp with time zone | now() | false | Timestamp when the share was last updated by trigger_set_timestamp. |
| Name | Type | Definition |
|---|---|---|
| exercise_slide_submission_s_exercise_slide_submission__not_null | n | NOT NULL exercise_slide_submission_id |
| exercise_slide_submission_sha_exercise_slide_submission_id_fkey | FOREIGN KEY | FOREIGN KEY (exercise_slide_submission_id) REFERENCES exercise_slide_submissions(id) |
| exercise_slide_submission_shares_created_at_not_null | n | NOT NULL created_at |
| exercise_slide_submission_shares_created_by_fkey | FOREIGN KEY | FOREIGN KEY (created_by) REFERENCES users(id) |
| exercise_slide_submission_shares_created_by_not_null | n | NOT NULL created_by |
| exercise_slide_submission_shares_id_not_null | n | NOT NULL id |
| exercise_slide_submission_shares_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| exercise_slide_submission_shares_updated_at_not_null | n | NOT NULL updated_at |
| Name | Definition |
|---|---|
| exercise_slide_submission_shares_pkey | CREATE UNIQUE INDEX exercise_slide_submission_shares_pkey ON public.exercise_slide_submission_shares USING btree (id) |
| idx_exercise_slide_submission_shares_created_by | CREATE INDEX idx_exercise_slide_submission_shares_created_by ON public.exercise_slide_submission_shares USING btree (created_by) |
| idx_exercise_slide_submission_shares_submission_id | CREATE INDEX idx_exercise_slide_submission_shares_submission_id ON public.exercise_slide_submission_shares USING btree (exercise_slide_submission_id) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.exercise_slide_submission_shares FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls