create table
  public.posts (
    id bigint generated by default as identity not null,
    created_at timestamp with time zone null default now(),
    content text not null default ''::text,
    authorId uuid not null,
    constraint posts_pkey primary key (id),
    constraint posts_authorId_fkey foreign key ("authorId") references profiles (id) on delete cascade
  ) tablespace pg_default;

create table
  public.profiles (
    id uuid not null,
    username text not null,
    constraint profiles_pkey primary key (id),
    constraint profiles_username_key unique (username),
    constraint profiles_id_fkey foreign key (id) references auth.users (id) on delete cascade
  ) tablespace pg_default;