CREATE TABLE booking (
ticket_no INTEGER NOT NULL,
perf_date DATE NOT NULL,
perf_time TIME NOT NULL,
row_no CHAR(3) NOT NULL,
person_id INTEGER NOT NULL,
PRIMARY KEY (ticket_no),
FOREIGN KEY (perf_date) REFERENCES performance (perf_date)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (perf_time) REFERENCES
performance (perf_time)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (row_no) REFERENCES seat (row_no)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (person_id) REFERENCES customer (person_id)
ON DELETE SET NULL
ON UPDATE CASCADE
);