create table
  public.category (
    id uuid not null default uuid_generate_v4 (),
    name character varying(255) not null,
    constraint category_pkey primary key (id)
  ) tablespace pg_default;

create table
  public.companion (
    id uuid not null default uuid_generate_v4 (),
    user_id uuid not null default gen_random_uuid (),
    username character varying(255) not null,
    src character varying(255) not null,
    name text not null,
    description text not null,
    instructions text not null,
    seed text not null,
    created_at timestamp with time zone not null default timezone ('UTC'::text, now()),
    updated_at timestamp with time zone not null default timezone ('UTC'::text, now()),
    category_id uuid not null,
    constraint companion_pkey primary key (id),
    constraint companion_category_id_fkey foreign key (category_id) references category (id) on update cascade on delete cascade,
    constraint public_companion_user_id_fkey foreign key (user_id) references auth.users (id) on update cascade on delete cascade
  ) tablespace pg_default;

true

(user_id = auth.uid())

create table
  public.messages (
    id uuid not null default uuid_generate_v4 (),
    role public.role not null,
    content text not null,
    created_at timestamp with time zone not null default timezone ('UTC'::text, now()),
    updated_at timestamp with time zone not null default timezone ('UTC'::text, now()),
    companion_id uuid not null,
    user_id character varying(255) not null,
    constraint message_pkey primary key (id)
  ) tablespace pg_default;

true

true

create table
  public.user_subscription (
    id uuid not null default uuid_generate_v4 (),
    user_id character varying(255) not null,
    stripe_customer_id character varying(255) null,
    stripe_subscription_id character varying(255) null,
    stripe_price_id character varying(255) null,
    stripe_current_period_end timestamp with time zone null,
    constraint usersubscription_pkey primary key (id),
    constraint usersubscription_stripecustomerid_key unique (stripe_customer_id),
    constraint usersubscription_stripesubscriptionid_key unique (stripe_subscription_id),
    constraint usersubscription_userid_key unique (user_id)
  ) tablespace pg_default;

create table
  public.users (
    id uuid not null,
    created_at timestamp with time zone not null default now(),
    email text not null,
    avatar_url text null,
    providers text[] not null default '{}'::text[],
    role text[] not null default '{USER}'::text[],
    constraint users_duplicate_pkey primary key (id),
    constraint users_id_fkey foreign key (id) references auth.users (id) on update cascade on delete cascade
  ) tablespace pg_default;

(id = auth.uid())

(id = auth.uid())