schema.sql

-- =============================================================
-- Section 1 — Insert and Query Data
-- =============================================================
-- Creates the sqlf_insert_query schema and a single `person`
-- table that you'll populate and query throughout the exercises.
--
-- Load from your shell:
--   psql -U postgres -d sql_exercise \
--        -f 02-sql-fundamentals/01-insert-and-query-data/schema.sql
--
-- Then load the seed data:
--   psql -U postgres -d sql_exercise \
--        -f 02-sql-fundamentals/01-insert-and-query-data/seed.sql
--
-- Safe to re-run — DROP SCHEMA ... CASCADE at the top wipes
-- everything first.
-- =============================================================

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

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
);