schema.sql

-- Supabase / PostgreSQL schema for personal-Review app
-- Run this in the Supabase SQL editor or psql

-- Enable pgcrypto for gen_random_uuid()
create extension if not exists pgcrypto;

create table if not exists users (
  id uuid primary key default gen_random_uuid(),
  name text,
  username text unique,
  email text unique,
  age integer,
  gender text,
  created_at timestamptz default now()
);

create table if not exists reviews (
  id uuid primary key default gen_random_uuid(),
  user_id uuid references users(id) on delete set null,
  username text,
  app_name text not null,
  rating integer check (rating >= 0 and rating <= 5),
  description text,
  created_at timestamptz default now()
);

create index if not exists idx_reviews_app_name on reviews(app_name);