drop table reference_types;
drop sequence reference_types_seq;
drop table reference_codes;
drop table products;
drop sequence products_seq;
drop table tariffs;
drop table product_tariffs;
drop table suburbs;
drop sequence suburbs_city_id_seq;
drop table streets;
drop sequence streets_seq;
drop table users;
drop sequence users_seq;
drop table articles;
drop sequence articles_seq;
drop table readings;
drop sequence readings_seq;
drop table groups;
drop sequence groups_seq;
drop table memberships;
drop table membership_statuses;
drop sequence membership_statuses_seq;
drop table departments;
drop sequence departments_seq;
drop table employees;
drop sequence employees_seq;
drop table comments;
drop sequence comments_seq;
drop table restaurants;
drop table restaurants_suburbs;
drop table dorms;
drop sequence dorms_seq;
drop table rooms;
drop table room_attributes;
drop sequence room_attributes_seq;
drop table room_attribute_assignments;
drop table room_assignments;
drop table students;
drop sequence students_seq;
drop table capitols;
drop table products_restaurants;
drop table employees_groups;