mirror of
https://github.com/acaloiaro/garbagespeak.com
synced 2026-07-21 10:12:19 +00:00
11 lines
417 B
SQL
11 lines
417 B
SQL
CREATE TABLE IF NOT EXISTS garbages(
|
|
id uuid PRIMARY KEY default uuid_generate_v4(),
|
|
owner_id uuid,
|
|
title text NOT NULL,
|
|
content text NOT NULL,
|
|
metadata jsonb default '{}'::jsonb,
|
|
created_at timestamp with time zone default now(),
|
|
updated_at timestamp with time zone
|
|
);
|
|
|
|
ALTER TABLE ONLY public.garbages ADD CONSTRAINT onwer_id_fkey FOREIGN KEY (owner_id) REFERENCES public.users(id) ON DELETE CASCADE;
|