create_tables.sql

-- users table
CREATE TABLE public.users (
    id UUID PRIMARY KEY,
    email TEXT,
    created_at TIMESTAMP WITH TIME ZONE
);

-- table to store files that users create
CREATE TABLE public.files (
    id UUID DEFAULT uuid_generate_v4() PRIMARY KEY,
    data TEXT
);

-- table that records file permissions that users have.
-- role_name can be Owner, Editor, or Viewer
CREATE TABLE public.file_access (
    id UUID DEFAULT uuid_generate_v4() PRIMARY KEY,
    file_id UUID REFERENCES public.files,
    user_id UUID REFERENCES public.users,
    role_name TEXT
);