Table
hall_napoleon_scan
Admission at the Hall Napoleon door, at most one per booking.
Replaces in 2020: Hall Napoleon, Actual Number of Visitor
Rows 1–25 of 1,775
| scan_idINTEGER | booking_id→ exhibition_booking.booking_id | scanned_atTEXT |
|---|---|---|
| 1 | 60 | 2015-03-23 11:04:57 |
| 2 | 108 | 2015-03-31 15:55:25 |
| 3 | 107 | 2015-03-31 15:58:21 |
| 4 | 110 | 2015-04-04 12:08:18 |
| 5 | 109 | 2015-04-04 12:09:21 |
| 6 | 36 | 2015-04-25 11:30:05 |
| 7 | 32 | 2015-04-25 11:30:06 |
| 8 | 29 | 2015-04-25 11:30:09 |
| 9 | 37 | 2015-04-25 11:30:10 |
| 10 | 34 | 2015-04-25 11:30:11 |
| 11 | 25 | 2015-04-25 11:30:15 |
| 12 | 39 | 2015-04-25 11:30:29 |
| 13 | 43 | 2015-04-25 11:30:45 |
| 14 | 33 | 2015-04-25 11:31:01 |
| 15 | 45 | 2015-04-25 11:31:26 |
| 16 | 22 | 2015-04-25 11:31:30 |
| 17 | 42 | 2015-04-25 11:31:59 |
| 18 | 4 | 2015-04-25 11:32:48 |
| 19 | 6 | 2015-04-25 11:32:49 |
| 20 | 17 | 2015-04-25 11:33:12 |
| 21 | 9 | 2015-04-25 11:33:15 |
| 22 | 41 | 2015-04-25 11:34:08 |
| 23 | 38 | 2015-04-25 11:34:33 |
| 24 | 20 | 2015-04-25 11:34:35 |
| 25 | 35 | 2015-04-25 11:34:42 |
Table definition
CREATE TABLE hall_napoleon_scan (
scan_id INTEGER PRIMARY KEY,
booking_id INTEGER NOT NULL UNIQUE REFERENCES exhibition_booking (booking_id),
scanned_at TEXT NOT NULL
) STRICT;