Create table samples for Pluralsight's gorilla toolkit course

pluralsight_gorilla_toolkit_db

CREATE TABLE employee(
   id serial PRIMARY KEY     NOT NULL,
   given_name           varchar(255),
   surname           varchar(255),
   address            text,
   city              varchar(255),
   state             varchar(255),
   postal_code             varchar(255),
   role_id int,
   hire_date date,
   pay_rate decimal,
   employee_number int,
   password text
);

CREATE TABLE engine(
   id serial PRIMARY KEY     NOT NULL,
   description text
);

CREATE TABLE make(
   id serial PRIMARY KEY     NOT NULL,
   name varchar(255)
);

CREATE TABLE model(
   id serial PRIMARY KEY     NOT NULL,
   name varchar(255),
   make_id int
);

CREATE TABLE model_year(
   id serial PRIMARY KEY     NOT NULL,
   year_id int,
   model_id int
);

CREATE TABLE model_year_engine(
   id serial PRIMARY KEY     NOT NULL,
   year_id int,
   model_id int,
   engine_id int
);

CREATE TABLE model_year_engine_part(
   id serial PRIMARY KEY     NOT NULL,
   year_id int,
   model_id int,
   engine_id int,
   part_id int
);

CREATE TABLE part(
   id serial PRIMARY KEY     NOT NULL,
   part_number varchar(255),
   price decimal,
   supplier varchar(255),
   quality varchar(255),
   image_name varchar(255),
   type_id   int
);

CREATE TABLE part_category(
   id serial PRIMARY KEY     NOT NULL,
   name varchar(255)
);

CREATE TABLE part_subcategory(
   id serial PRIMARY KEY     NOT NULL,
   name varchar(255),
   category_id int
);

CREATE TABLE part_type(
   id serial PRIMARY KEY     NOT NULL,
   name varchar(255),
   subcategory_id int
);

CREATE TABLE role(
   id serial PRIMARY KEY     NOT NULL,
   name varchar(255)
);

CREATE TABLE store_inventory(
   id serial PRIMARY KEY     NOT NULL,
   part_id int,
   quantity int,
   location varchar(255)
);

CREATE TABLE year(
   id serial PRIMARY KEY     NOT NULL,
   year int
);