onasty: migrations/20240724122920_notes_authors.up.sql (86dba8ea0dc14c9a08dbb0baa9b0441168638328)

onasty/migrations/20240724122920_notes_authors.up.sql (view raw)

Smirnov Oleksandr feat: notes manipulations for the note authors (#117)..., 1 year ago

CREATE TABLE notes_authors (
    id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
    note_id uuid REFERENCES notes (id) ON DELETE CASCADE,
    user_id uuid REFERENCES users (id) ON DELETE CASCADE,
    created_at timestamptz NOT NULL DEFAULT now()
);

1	CREATE TABLE notes_authors (
2	id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
3	note_id uuid REFERENCES notes (id) ON DELETE CASCADE,
4	user_id uuid REFERENCES users (id) ON DELETE CASCADE,
5	created_at timestamptz NOT NULL DEFAULT now()
6	);