mirror of
https://github.com/CompassConnections/Compass.git
synced 2026-01-02 10:58:10 -05:00
15 lines
406 B
SQL
15 lines
406 B
SQL
create table if not exists
|
|
contact (
|
|
id text default uuid_generate_v4 () not null primary key,
|
|
created_time timestamp with time zone default now(),
|
|
user_id text,
|
|
content jsonb
|
|
);
|
|
|
|
-- Foreign Keys
|
|
alter table contact
|
|
add constraint contact_user_id_fkey foreign key (user_id) references users (id) on delete set null;
|
|
|
|
-- Row Level Security
|
|
alter table contact enable row level security;
|