gQuest

Database Viewer

Browse the SQL that builds any database used across the lessons, without running it.

Loaded: Lesson 4 database ยท constraints.database-init

CREATE TABLE products (
  id SERIAL PRIMARY KEY,
  sku TEXT NOT NULL UNIQUE,
  name TEXT NOT NULL,
  price_cents INTEGER NOT NULL CHECK (price_cents > 0)
);


INSERT INTO products (sku, name, price_cents)
VALUES
  ('BOOK-001', 'SQL Pocket Guide', 2500),
  ('MUG-001', 'PgQuest Mug', 1800);