An early attempt to create SQL tables with sqlite3

sqltables.sql

CREATE TABLE species (
    id INTEGER PRIMARY KEY,
    name TEXT
);

CREATE TABLE breed (
    id INTEGER PRIMARY KEY,
    name TEXT,
    species_id INTEGER
);

CREATE TABLE pet (
    id INTEGER PRIMARY KEY,
    name TEXT,
    dead INTEGER,
    breed_id INTEGER,
    adopted INTEGER
);

CREATE TABLE person (
    id INTEGER PRIMARY KEY,
    first_name TEXT,
    last_name TEXT,
    age INTEGER,
    email TEXT,
    phone TEXT
);

CREATE TABLE person_pet (
    person_id INTEGER,
    pet_id INTEGER
);

INSERT INTO species (id, name) VALUES (1, "dog");
INSERT INTO species (id, name) VALUES (2, "cat");

INSERT INTO breed (id, name, species_id) VALUES (1, "labrador", 1);
INSERT INTO breed (id, name, species_id) VALUES (2, "poodle", 1);
INSERT INTO breed (id, name, species_id) VALUES (3, "tabby", 2);

INSERT INTO pet (id, name, dead, breed_id, adopted) 
    VALUES (1, "Jackson", 0, 1, 0);
INSERT INTO pet (id, name, dead, breed_id, adopted) 
    VALUES (2, "Ms. Puffy", 1, 2, 0);
INSERT INTO pet (id, name, dead, breed_id, adopted) 
    VALUES (3, "Solomon", 0, 3, 1);

INSERT INTO person (id, first_name, last_name, age, email, phone)
    VALUES (1, "Pedro", "Saltador", 34, "p@skip", "123-456-7890");
INSERT INTO person (id, first_name, last_name, age, email, phone)
    VALUES (2, "Patty", "Tranton", 28, "p@tran", "123-456-0987");

INSERT INTO person_pet (person_id, pet_id) VALUES (1,1);
INSERT INTO person_pet (person_id, pet_id) VALUES (2,2);
INSERT INTO person_pet (person_id, pet_id) VALUES (2,3);