// Users table
users {
  id: uuid // primary key
  google_id: string // from OAuth
  email: string
  name: string
  avatar_url: string // Google profile pic
  newsletter_opt_in: boolean // did they check the box?
  is_admin: boolean // default false, true for you
  created_at: timestamp
}

// Ideas table
ideas {
  id: uuid // primary key
  user_id: uuid // foreign key → users
  title: string // short headline
  description: string // optional longer explanation
  status: enum // 'open' | 'planned' | 'filmed'
  video_url: string? // YouTube link when filmed
  created_at: timestamp
}

// Votes table (join table)
votes {
  id: uuid // primary key
  user_id: uuid // foreign key → users
  idea_id: uuid // foreign key → ideas
  created_at: timestamp

  // unique constraint on (user_id, idea_id) — one vote per user per idea
}

-- Get ideas sorted by vote count (leaderboard)
SELECT ideas.*, COUNT(votes.id) as vote_count
FROM ideas
LEFT JOIN votes ON votes.idea_id = ideas.id
GROUP BY ideas.id
ORDER BY vote_count DESC;

-- Check if user voted for an idea
SELECT * FROM votes
WHERE user_id = :current_user AND idea_id = :idea_id;

-- Get newsletter subscribers (for export)
SELECT email, name FROM users
WHERE newsletter_opt_in = true;

Why this: Supabase has built-in Google OAuth. One command to set up. Database is ready. You're building, not configuring.

1. Admin page has "Export Subscribers" button
2. Downloads CSV of emails where newsletter_opt_in = true
3. Import into Beehiiv/ConvertKit/whatever you use

Good enough to start. Do this weekly.

// When user signs up with newsletter_opt_in = true
// Call your email provider's API

if (user.newsletter_opt_in) {
  await fetch('https://api.beehiiv.com/v2/subscribers', {
    method: 'POST',
    headers: { Authorization: `Bearer ${BEEHIIV_API_KEY}` },
    body: JSON.stringify({
      email: user.email,
      publication_id: 'your-publication-id'
    })
  });
}

Add this once you have volume. Not needed day one.