Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,901–4,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4901 | 2495 | 3 | 2016-07-15 10:16:28 |
| 4902 | 2456 | 2 | 2016-07-15 10:23:27 |
| 4903 | 2493 | 1 | 2016-07-15 10:23:49 |
| 4904 | 2454 | 2 | 2016-07-15 10:23:53 |
| 4905 | 2489 | 2 | 2016-07-15 10:25:18 |
| 4906 | 2494 | 2 | 2016-07-15 10:32:10 |
| 4907 | 2455 | 2 | 2016-07-15 10:34:21 |
| 4908 | 2447 | 2 | 2016-07-15 10:49:20 |
| 4909 | 2489 | 3 | 2016-07-15 11:13:44 |
| 4910 | 2496 | 3 | 2016-07-15 11:41:31 |
| 4911 | 2447 | 3 | 2016-07-15 11:51:27 |
| 4912 | 2494 | 1 | 2016-07-15 11:55:10 |
| 4913 | 2454 | 3 | 2016-07-15 11:56:41 |
| 4914 | 2455 | 3 | 2016-07-15 12:03:34 |
| 4915 | 2447 | 1 | 2016-07-15 12:20:50 |
| 4916 | 2454 | 2 | 2016-07-15 12:25:12 |
| 4917 | 2455 | 2 | 2016-07-15 13:03:41 |
| 4918 | 2454 | 3 | 2016-07-15 13:07:03 |
| 4919 | 2496 | 1 | 2016-07-15 13:16:15 |
| 4920 | 2447 | 3 | 2016-07-15 13:34:11 |
| 4921 | 2455 | 3 | 2016-07-15 13:55:16 |
| 4922 | 2481 | 3 | 2016-07-15 14:56:40 |
| 4923 | 2480 | 3 | 2016-07-15 15:07:02 |
| 4924 | 2481 | 1 | 2016-07-15 16:05:06 |
| 4925 | 2480 | 1 | 2016-07-15 16:26:39 |
Table definition
CREATE TABLE wing_scan (
scan_id INTEGER PRIMARY KEY,
ticket_id INTEGER NOT NULL REFERENCES ticket (ticket_id),
wing_id INTEGER NOT NULL REFERENCES wing (wing_id),
scanned_at TEXT NOT NULL
) STRICT;