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


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

CREATE TABLE customer_customer_demo (

  shipped_date DATE,
  ship_via SMALLINT REFERENCES shippers,
  freight REAL,
  ship_name VARCHAR(40),
  ship_address VARCHAR(60),
  ship_city VARCHAR(15),
  ship_region VARCHAR(15),
  ship_postal_code VARCHAR(10),
  ship_country VARCHAR(15)
);

CREATE TABLE territories (
  territory_id VARCHAR(20) NOT NULL PRIMARY KEY,
  territory_description BPCHAR NOT NULL,
  region_id SMALLINT NOT NULL REFERENCES region
);

CREATE TABLE employee_territories (
  employee_id SMALLINT NOT NULL REFERENCES employees,
  territory_id VARCHAR(20) NOT NULL REFERENCES territories,
  PRIMARY KEY (employee_id, territory_id)
);

