All pastes #358919 Raw Edit

Something

public text v1 · immutable
·published 2007-02-16 13:44 UTC
rendered paste body
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
);