Table

exhibition_booking

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

Replaces in 2020: Exhibition Booking, Booking Ticket

Rows 476–500 of 2,015

exhibition_booking, page 20 of 81
booking_idINTEGER	slot_id→ exhibition_slot.slot_id	ticket_id→ ticket.ticket_id	booked_atTEXT
476	85	3549	2017-02-20 13:29:06
477	85	3550	2017-02-20 13:29:06
478	88	3553	2017-02-21 14:59:32
479	88	3554	2017-02-21 14:59:32
480	88	3555	2017-02-21 14:59:32
481	100	3557	2017-02-21 17:46:03
482	89	3559	2017-02-22 18:50:47
483	87	3560	2017-02-24 15:50:35
484	103	3561	2017-02-24 17:10:45
485	103	3562	2017-02-24 17:10:45
486	92	3564	2017-02-26 08:09:02
487	92	3565	2017-02-26 08:09:02
488	92	3566	2017-02-26 08:09:02
489	92	3567	2017-02-26 08:09:02
490	98	3576	2017-03-01 12:55:10
491	98	3577	2017-03-01 12:55:10
492	98	3578	2017-03-01 12:55:10
493	98	3579	2017-03-01 12:55:10
494	98	3580	2017-03-01 12:55:10
495	90	3590	2017-03-03 10:22:11
496	101	3594	2017-03-05 18:31:56
497	93	3609	2017-03-09 13:42:08
498	91	3610	2017-03-10 07:36:14
499	91	3611	2017-03-10 07:36:14
500	99	3615	2017-03-12 19:46:51

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;