← back to Stayclaim

db/migrations/003_address_submission.sql

16 lines

CREATE TABLE IF NOT EXISTS address_submission (
  id              uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  address_line1   text NOT NULL,
  city            text NOT NULL,
  state           text NOT NULL,
  postal_code     text,
  notes           text,
  contact_email   text NOT NULL,
  status          text NOT NULL DEFAULT 'pending',
  submitted_at    timestamptz NOT NULL DEFAULT now(),
  reviewed_at     timestamptz,
  reviewer_note   text,
  ingested_listing_id uuid REFERENCES listing(id)
);
CREATE INDEX IF NOT EXISTS idx_addrsub_status ON address_submission (status);