Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,001–16,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16001 | 8214 | 2 | 2019-05-17 10:34:06 |
| 16002 | 8213 | 1 | 2019-05-17 10:35:59 |
| 16003 | 8215 | 2 | 2019-05-17 10:37:04 |
| 16004 | 8197 | 2 | 2019-05-17 10:37:46 |
| 16005 | 8233 | 1 | 2019-05-17 10:41:15 |
| 16006 | 7542 | 2 | 2019-05-17 10:49:11 |
| 16007 | 7549 | 2 | 2019-05-17 10:49:21 |
| 16008 | 7548 | 2 | 2019-05-17 10:49:30 |
| 16009 | 7563 | 2 | 2019-05-17 10:50:27 |
| 16010 | 7562 | 2 | 2019-05-17 10:50:50 |
| 16011 | 7554 | 2 | 2019-05-17 10:51:35 |
| 16012 | 8234 | 1 | 2019-05-17 10:53:54 |
| 16013 | 7557 | 2 | 2019-05-17 10:54:11 |
| 16014 | 7570 | 2 | 2019-05-17 10:54:18 |
| 16015 | 7541 | 2 | 2019-05-17 10:55:09 |
| 16016 | 7533 | 2 | 2019-05-17 10:55:33 |
| 16017 | 7569 | 2 | 2019-05-17 10:56:09 |
| 16018 | 7531 | 2 | 2019-05-17 10:56:52 |
| 16019 | 7571 | 2 | 2019-05-17 10:57:26 |
| 16020 | 8235 | 1 | 2019-05-17 10:57:41 |
| 16021 | 7532 | 2 | 2019-05-17 10:57:42 |
| 16022 | 7545 | 2 | 2019-05-17 10:57:44 |
| 16023 | 7572 | 2 | 2019-05-17 10:58:33 |
| 16024 | 7561 | 2 | 2019-05-17 10:58:56 |
| 16025 | 7544 | 2 | 2019-05-17 10:59:04 |
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;