mirror of
https://github.com/CompassConnections/Compass.git
synced 2025-12-31 18:08:40 -05:00
23 lines
676 B
SQL
23 lines
676 B
SQL
create table if not exists
|
|
reports (
|
|
content_id text not null,
|
|
content_owner_id text not null,
|
|
content_type text not null,
|
|
created_time timestamp with time zone default now(),
|
|
description text,
|
|
id text default uuid_generate_v4 () not null,
|
|
parent_id text,
|
|
parent_type text,
|
|
user_id text
|
|
);
|
|
|
|
-- Foreign Keys
|
|
alter table reports
|
|
add constraint reports_content_owner_id_fkey foreign key (content_owner_id) references users (id) on delete set null;
|
|
|
|
alter table reports
|
|
add constraint reports_user_id_fkey foreign key (user_id) references users (id) on delete set null;
|
|
|
|
-- Row Level Security
|
|
alter table reports enable row level security;
|