← back to Trademarks Copyright

db/referrals.sql

13 lines

CREATE TABLE IF NOT EXISTS referrals (
  id                SERIAL PRIMARY KEY,
  referrer_token    TEXT NOT NULL,
  referred_email    TEXT NOT NULL,
  referred_sub_id   INT REFERENCES subscribers(id) ON DELETE SET NULL,
  created_at        TIMESTAMPTZ DEFAULT NOW(),
  reward_given      BOOLEAN DEFAULT FALSE,
  UNIQUE (referrer_token, referred_email)
);

CREATE INDEX IF NOT EXISTS idx_refs_referrer ON referrals(referrer_token);
CREATE INDEX IF NOT EXISTS idx_refs_reward   ON referrals(reward_given);