supabase_flutter_example

A flutter example app using Supabase.

Database

Clothes

create table
  public.clothes (
    id bigint generated by default as identity,
    created_at timestamp with time zone not null default now(),
    updated_at timestamp with time zone null default now(),
    type smallint null default '0'::smallint,
    name text null,
    width smallint null default '0'::smallint,
    length smallint null default '0'::smallint,
    sleeve_length smallint null default '0'::smallint,
    shoulder_width smallint null default '0'::smallint,
    image_id uuid null default gen_random_uuid (),
    user_id uuid not null default auth.uid (),
    constraint clothes_pkey primary key (id),
    constraint clothes_image_id_key unique (image_id),
    constraint clothes_user_id_fkey foreign key (user_id) references auth.users (id)
  ) tablespace pg_default;

Users

create table
  public.users (
    id uuid not null,
    name text null,
    constraint users_pkey primary key (id),
    constraint users_name_key unique (name),
    constraint users_id_fkey foreign key (id) references auth.users (id)
  ) tablespace pg_default;

Storage

• images
• users

Edge Functions

• supabase-delete-user
• supabase-initialize-user

https://github.com/CORDEA/supabase-flutter-example-functions