/**********************************
 Drop tables for ticket database
 for Oracle
**********************************/

DROP TABLE Booking cascade constraints;
DROP TABLE Genre cascade constraints;
DROP TABLE Performance cascade constraints;
DROP TABLE Price_Band cascade constraints;
DROP TABLE Price_Structure cascade constraints;
DROP TABLE Purchase cascade constraints;
DROP TABLE Registered_User cascade constraints;
DROP TABLE Seat cascade constraints;
DROP TABLE Seat_Class cascade constraints;
DROP TABLE Seat_Plan_Seat cascade constraints;
DROP TABLE Seat_Status cascade constraints;
DROP TABLE Seating_Plan cascade constraints;
DROP TABLE Show cascade constraints;