Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,526–19,545 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19526 | 9827 | 2 | 2020-02-23 17:26:41 |
| 19527 | 9824 | 1 | 2020-02-23 17:46:15 |
| 19528 | 9825 | 1 | 2020-02-23 17:47:12 |
| 19529 | 9808 | 3 | 2020-02-24 12:02:00 |
| 19530 | 9807 | 1 | 2020-02-24 12:04:17 |
| 19531 | 9810 | 1 | 2020-02-24 12:05:41 |
| 19532 | 9809 | 1 | 2020-02-24 12:07:49 |
| 19533 | 9810 | 2 | 2020-02-24 12:39:50 |
| 19534 | 9809 | 2 | 2020-02-24 12:40:06 |
| 19535 | 9807 | 2 | 2020-02-24 12:57:25 |
| 19536 | 9834 | 2 | 2020-02-24 15:59:34 |
| 19537 | 9835 | 2 | 2020-02-24 16:01:45 |
| 19538 | 9833 | 2 | 2020-02-24 16:09:18 |
| 19539 | 9834 | 3 | 2020-02-24 17:22:45 |
| 19540 | 9837 | 3 | 2020-02-27 14:51:02 |
| 19541 | 9836 | 2 | 2020-02-29 10:01:22 |
| 19542 | 9838 | 1 | 2020-02-29 11:20:39 |
| 19543 | 9839 | 1 | 2020-02-29 11:25:03 |
| 19544 | 9839 | 2 | 2020-02-29 12:12:12 |
| 19545 | 9838 | 2 | 2020-02-29 12:39:45 |
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;