Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,376–19,400 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19376 | 9758 | 1 | 2020-02-05 13:20:04 |
| 19377 | 9771 | 2 | 2020-02-05 13:36:20 |
| 19378 | 9770 | 2 | 2020-02-05 13:41:26 |
| 19379 | 9769 | 2 | 2020-02-05 13:42:29 |
| 19380 | 9742 | 3 | 2020-02-05 13:43:10 |
| 19381 | 9772 | 2 | 2020-02-05 13:45:17 |
| 19382 | 9758 | 3 | 2020-02-05 14:00:24 |
| 19383 | 9769 | 1 | 2020-02-05 14:17:48 |
| 19384 | 9744 | 2 | 2020-02-05 14:23:33 |
| 19385 | 9771 | 1 | 2020-02-05 14:34:13 |
| 19386 | 9758 | 2 | 2020-02-05 15:04:02 |
| 19387 | 9772 | 1 | 2020-02-05 15:16:51 |
| 19388 | 9776 | 2 | 2020-02-06 09:19:33 |
| 19389 | 9775 | 2 | 2020-02-06 09:22:38 |
| 19390 | 9750 | 1 | 2020-02-07 13:33:12 |
| 19391 | 9750 | 2 | 2020-02-07 14:26:27 |
| 19392 | 9781 | 1 | 2020-02-08 09:12:06 |
| 19393 | 9782 | 3 | 2020-02-08 10:13:56 |
| 19394 | 9781 | 3 | 2020-02-08 10:22:39 |
| 19395 | 9783 | 3 | 2020-02-08 10:23:26 |
| 19396 | 9778 | 2 | 2020-02-09 09:32:31 |
| 19397 | 9777 | 1 | 2020-02-09 09:33:12 |
| 19398 | 9754 | 2 | 2020-02-09 11:26:41 |
| 19399 | 9755 | 2 | 2020-02-09 11:30:34 |
| 19400 | 9663 | 2 | 2020-02-09 11:55:16 |
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;