 
 drop table if exists commodity;
 
-drop table if exists pathfinder_application;
-
-drop table if exists pathfinder_user;
-
 drop table if exists vehicle;
 
+drop table if exists application cascade;
+
+drop table if exists capacity_parameter cascade;
+
+drop table if exists customer cascade;
+
+drop table if exists objective_function cascade;
+
+drop table if exists objective_parameter cascade;

    ADD CONSTRAINT fk_commodity_cluster_id FOREIGN KEY (cluster_id) REFERENCES cluster(id) ON UPDATE RESTRICT ON DELETE RESTRICT;


ALTER TABLE ONLY pathfinder_application
    ADD CONSTRAINT fk_pathfinder_application_cluster_id FOREIGN KEY (cluster_id) REFERENCES cluster(id) ON UPDATE RESTRICT ON DELETE RESTRICT;


ALTER TABLE ONLY vehicle
    ADD CONSTRAINT fk_vehicle_cluster_id FOREIGN KEY (cluster_id) REFERENCES cluster(id) ON UPDATE RESTRICT ON DELETE RESTRICT;


# --- !Downs

    ADD CONSTRAINT pk_commodity PRIMARY KEY (id);


ALTER TABLE ONLY vehicle
    ADD CONSTRAINT pk_vehicle PRIMARY KEY (id);

