Files
tsumugu/backend/migrations/20261017T160000Z_element_references.sql
LarsandCursor f27df3ff35
Deploy Development / deploy (push) Successful in 27s
Test Suite / pytest-backend (push) Successful in 1m10s
Test Suite / smoke-dev (push) Successful in 0s
Test Suite / frontend-build (push) Successful in 8s
Zeige den Bezug zwischen Schreiben und lies eine E-Mail vor dem Uebernehmen.
Die Liste behaelt die Schreiben dazwischen. Richtung, Absender, Empfaenger und Anhaenge bleiben an der Nachricht erkennbar.

Co-authored-by: Cursor <cursoragent@cursor.com>
2026-10-17 17:27:17 +02:00

10 lines
433 B
SQL

CREATE TABLE element_references (
element_id uuid NOT NULL REFERENCES elements (id) ON DELETE CASCADE,
refers_to_element_id uuid NOT NULL REFERENCES elements (id) ON DELETE CASCADE,
created_at timestamptz NOT NULL DEFAULT now(),
PRIMARY KEY (element_id, refers_to_element_id),
CHECK (element_id <> refers_to_element_id)
);
CREATE INDEX element_references_target_idx ON element_references (refers_to_element_id);