database.sql

-- Create Job Descriptions table
create table job_descriptions (
  id uuid default gen_random_uuid() primary key,
  user_id uuid references auth.users not null,
  title text not null,
  tier text,
  created_at timestamp with time zone default timezone('utc'::text, now()) not null
);

-- Create Scan History table
create table scan_history (
  id uuid default gen_random_uuid() primary key,
  user_id uuid references auth.users not null,
  jd_id uuid references job_descriptions(id),
  candidate_name text,
  score integer,
  outreach_draft text,
  created_at timestamp with time zone default timezone('utc'::text, now()) not null
);

-- Enable RLS
alter table job_descriptions enable row level security;
alter table scan_history enable row level security;

-- Create policies
create policy "Users can view their own JDs"
  on job_descriptions for select
  using ( auth.uid() = user_id );

create policy "Users can insert their own JDs"
  on job_descriptions for insert
  with check ( auth.uid() = user_id );

create policy "Users can view their own history"
  on scan_history for select
  using ( auth.uid() = user_id );

create policy "Users can insert their own history"
  on scan_history for insert
  with check ( auth.uid() = user_id );