schema.sql

-- =============================================================
-- Section 2 — Filtering Data
-- =============================================================
-- Creates the sqlf_filtering schema and a single `person` table.
-- Uses the same shape as section 09 so the mental model carries
-- over, but lives in its own schema so the two sections are
-- independent.
--
-- Load from your shell:
--   psql -U postgres -d sql_exercise \
--        -f 02-sql-fundamentals/02-filtering-data/schema.sql
--   psql -U postgres -d sql_exercise \
--        -f 02-sql-fundamentals/02-filtering-data/seed.sql
-- =============================================================

DROP SCHEMA IF EXISTS sqlf_filtering CASCADE;
CREATE SCHEMA sqlf_filtering;
SET search_path TO sqlf_filtering;

CREATE TABLE person (
    id                INTEGER,
    first_name        VARCHAR(50)  NOT NULL,
    last_name         VARCHAR(50)  NOT NULL,
    gender            CHAR(1)      NOT NULL,
    dob               DATE         NOT NULL,
    email             VARCHAR(150),
    phone_number      VARCHAR(15),
    country_of_origin VARCHAR(50)  NOT NULL
);