text: CREATE DATABASE wildlife;
  \c wildlife;
  
  CREATE TABLE IF NOT EXISTS animals(
  id SERIAL PRIMARY KEY,
  sighting_id INTEGER,
  animal_name VARCHAR
  );
  
  CREATE TABLE IF NOT EXISTS endangeredAnimals(
  id SERIAL PRIMARY KEY,
  animal_name VARCHAR,
  animal_age VARCHAR,
  animal_health VARCHAR,
  sighting_id INTEGER
  );
  
  CREATE TABLE IF NOT EXISTS sightings(
  id SERIAL PRIMARY KEY,
  animal_location VARCHAR,
  ranger_name VARCHAR
  sighted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  );
  
  --CREATE DATABASE wildlife_test WITH TEMPLATE wildlife;
  
  