Seed data
from your schema.

-- An online shop: customers place orders for products.
CREATE TABLE customers (
  id           SERIAL PRIMARY KEY,
  first_name   VARCHAR(50)  NOT NULL,
  last_name    VARCHAR(50)  NOT NULL,
  email        VARCHAR(120) NOT NULL UNIQUE,
  phone        VARCHAR(30),
  city         VARCHAR(80)  NOT NULL,
  country      VARCHAR(60)  NOT NULL,
  postal_code  VARCHAR(12),
  is_verified  BOOLEAN NOT NULL DEFAULT FALSE,
  created_at   TIMESTAMP NOT NULL DEFAULT now()
);

CREATE TABLE products (
  id           SERIAL PRIMARY KEY,
  sku          VARCHAR(20)  NOT NULL UNIQUE,
  name         VARCHAR(120) NOT NULL,
  category     VARCHAR(40)  NOT NULL,
  price        NUMERIC(10,2) NOT NULL,
  stock        INTEGER NOT NULL DEFAULT 0,
  description  TEXT
);

CREATE TABLE orders (
  id                SERIAL PRIMARY KEY,
  customer_id       INTEGER NOT NULL REFERENCES customers(id),
  status            VARCHAR(20) NOT NULL
                    CHECK (status IN ('pending','paid','shipped','delivered','cancelled')),
  shipping_address  VARCHAR(200) NOT NULL,
…