CREATE TABLE city (
    id serial NOT NULL,
    name text
);

CREATE TABLE sales_people (
    id serial NOT NULL,
    name text,
    comm double precision,
    city_id integer
);


CREATE TABLE customer (
    id serial NOT NULL,
    name text,
    city_id integer,
    rating integer,
    salespeople_id integer
);

CREATE TABLE order1 (
    id serial NOT NULL,
    amt double precision,
    odate timestamp without time zone,
    salespeople_id integer,
    customer_id integer
);