Waitlist System

Database Schema

The waitlist system uses the following table structure:

CREATE TABLE waitlist (
    id UUID DEFAULT uuid_generate_v4() PRIMARY KEY,
    email TEXT UNIQUE NOT NULL,
    first_name TEXT NOT NULL,
    last_name TEXT NOT NULL,
    twitter_handle TEXT,
    role TEXT NOT NULL,
    phone_prefix TEXT,
    phone_number TEXT,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

Features

  • Email uniqueness validation.

  • Optional social media integration.

  • Contact information management.

  • Role-based categorization.