— USERS TABLE CREATE TABLE users ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), full_name VARCHAR(100), email VARCHAR(100) UNIQUE NOT NULL, phone VARCHAR(30), country VARCHAR(50), role VARCHAR(20) DEFAULT ‘member’, — member / ambassador / admin ref_code VARCHAR(10) UNIQUE, — Ambassador referral code referrer_code VARCHAR(10), — Who referred them created_at TIMESTAMP DEFAULT NOW(), verified BOOLEAN DEFAULT FALSE );— REFERRALS TABLE CREATE TABLE referrals ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), referrer_code VARCHAR(10), referred_user UUID REFERENCES users(id) ON DELETE CASCADE, level INT, — Tier 1 or Tier 2 created_at TIMESTAMP DEFAULT NOW() );— SALES TABLE CREATE TABLE sales ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID REFERENCES users(id) ON DELETE CASCADE, amount DECIMAL(10,2), currency VARCHAR(10), payment_gateway VARCHAR(20), — ‘stripe’ or ‘billplz’ transaction_id VARCHAR(100), ref_code VARCHAR(10), — linked to ambassador status VARCHAR(20) DEFAULT ‘pending’, — success / failed / pending created_at TIMESTAMP DEFAULT NOW() );— PAYOUTS TABLE CREATE TABLE payouts ( id uuid PRIMARY KEY DEFAULT gen_random_uuid(), ambassador_code VARCHAR(10), amount DECIMAL(10,2), payment_date TIMESTAMP DEFAULT NOW(), status VARCHAR(20) DEFAULT ‘unpaid’, — unpaid / paid note TEXT );— TIERS TABLE CREATE TABLE tiers ( id SERIAL PRIMARY KEY, tier_number INT, commission_rate DECIMAL(5,2), description TEXT );— DEFAULT DATA INSERT INTO tiers (tier_number, commission_rate, description) VALUES (1, 15.00, ‘Tier 1 – Direct Ambassador referrals’), (2, 5.00, ‘Tier 2 – Downline member activations’);