 
 CREATE TABLE customers (
   customer_id BPCHAR NOT NULL PRIMARY KEY,
-  company_name CHARACTER VARYING(40) NOT NULL,
-  contact_name CHARACTER VARYING(30),
-  contact_title CHARACTER VARYING(30),
-  address CHARACTER VARYING(60),
-  city CHARACTER VARYING(15),
-  region CHARACTER VARYING(15),
-  postal_code CHARACTER VARYING(10),
-  country CHARACTER VARYING(15),
-  phone CHARACTER VARYING(24),
-  fax CHARACTER VARYING(24)
+  company_name VARCHAR(40) NOT NULL,
+  contact_name VARCHAR(30),
+  contact_title VARCHAR(30),
+  address VARCHAR(60),
+  city VARCHAR(15),
+  region VARCHAR(15),
+  postal_code VARCHAR(10),
+  country VARCHAR(15),
+  phone VARCHAR(24),
+  fax VARCHAR(24)
 );
 
 CREATE TABLE customer_customer_demo (


CREATE TABLE shippers (
  shipper_id SMALLINT NOT NULL PRIMARY KEY,
  company_name CHARACTER VARYING(40) NOT NULL,
  phone CHARACTER VARYING(24)
);

CREATE TABLE orders (


CREATE TABLE employees (
  employee_id SMALLINT NOT NULL PRIMARY KEY,
  last_name VARCHAR(20) NOT NULL,
  first_name VARCHAR(10) NOT NULL,
  title VARCHAR(30),
  title_of_courtesy VARCHAR(25),
  birth_date DATE,
  hire_date DATE,
  address VARCHAR(60),
  city VARCHAR(15),
  region VARCHAR(15),
  postal_code VARCHAR(10),
  country VARCHAR(15),
  home_phone VARCHAR(24),
  extension VARCHAR(4),
  photo BYTEA,
  notes TEXT,
  reports_to SMALLINT REFERENCES employees,
  photo_path VARCHAR(255)
);

CREATE TABLE suppliers (
  supplier_id SMALLINT NOT NULL PRIMARY KEY,
  company_name VARCHAR(40) NOT NULL,
  contact_name VARCHAR(30),
  contact_title VARCHAR(30),
  address VARCHAR(60),
  city VARCHAR(15),
  region VARCHAR(15),
  postal_code VARCHAR(10),
  country VARCHAR(15),
  phone VARCHAR(24),
  fax VARCHAR(24),
  homepage TEXT
);

CREATE TABLE products (
  product_id SMALLINT NOT NULL PRIMARY KEY,
  product_name VARCHAR(40) NOT NULL,
  supplier_id SMALLINT REFERENCES suppliers,
  category_id SMALLINT REFERENCES categories,
  quantity_per_unit VARCHAR(20),
  unit_price REAL,
  units_in_stock SMALLINT,
  units_on_order SMALLINT,
