Table

exhibition_booking

A ticket's place in a slot; a trigger stops overbooking.

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 976–1,000 of 2,015

exhibition_booking, page 40 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
976	215	6138	2018-06-30 13:28:55
977	215	6139	2018-06-30 13:28:55
978	215	6140	2018-06-30 13:28:55
979	215	6141	2018-06-30 13:28:55
980	215	6142	2018-06-30 13:28:55
981	215	6143	2018-06-30 13:28:55
982	215	6144	2018-06-30 13:28:55
983	215	6145	2018-06-30 13:28:55
984	215	6146	2018-06-30 13:28:55
985	215	6147	2018-06-30 13:28:55
986	215	6148	2018-06-30 13:28:55
987	215	6149	2018-06-30 13:28:55
988	215	6150	2018-06-30 13:28:55
989	215	6151	2018-06-30 13:28:55
990	215	6152	2018-06-30 13:28:55
991	215	6153	2018-06-30 13:28:55
992	215	6154	2018-06-30 13:28:55
993	215	6155	2018-06-30 13:28:55
994	215	6156	2018-06-30 13:28:55
995	215	6157	2018-06-30 13:28:55
996	215	6158	2018-06-30 13:28:55
997	215	6159	2018-06-30 13:28:55
998	215	6160	2018-06-30 13:28:55
999	215	6161	2018-06-30 13:28:55
1000	215	6162	2018-06-30 13:28:55

Table definition

CREATE TABLE exhibition_booking (
  booking_id INTEGER PRIMARY KEY,
  slot_id    INTEGER NOT NULL REFERENCES exhibition_slot (slot_id),
  ticket_id  INTEGER NOT NULL REFERENCES ticket (ticket_id),
  booked_at  TEXT NOT NULL,
  UNIQUE (slot_id, ticket_id)
) STRICT;