CREATE TABLE IF NOT EXISTS returns (
  id            bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  created_at    timestamptz DEFAULT now() NOT NULL,
  return_date   date        DEFAULT CURRENT_DATE NOT NULL,
  product_id    bigint,
  quantity      integer     NOT NULL DEFAULT 1,
  reason        text        NOT NULL DEFAULT 'other',
  status        text        NOT NULL DEFAULT 'defective',
  refund_amount numeric     DEFAULT 0,
  original_sale text,
  notes         text
);
ALTER TABLE returns DISABLE ROW LEVEL SECURITY;