Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,651–15,675 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15651 | 7847 | 2 | 2019-04-15 13:01:19 |
| 15652 | 7858 | 2 | 2019-04-15 13:02:58 |
| 15653 | 7869 | 2 | 2019-04-15 13:02:59 |
| 15654 | 7861 | 2 | 2019-04-15 13:04:45 |
| 15655 | 7872 | 2 | 2019-04-15 13:07:08 |
| 15656 | 7839 | 2 | 2019-04-15 13:07:36 |
| 15657 | 7831 | 2 | 2019-04-15 13:11:46 |
| 15658 | 7868 | 2 | 2019-04-15 13:12:18 |
| 15659 | 7863 | 2 | 2019-04-15 13:13:42 |
| 15660 | 7829 | 2 | 2019-04-15 13:15:30 |
| 15661 | 7843 | 2 | 2019-04-15 13:16:41 |
| 15662 | 7832 | 2 | 2019-04-15 13:18:16 |
| 15663 | 7854 | 2 | 2019-04-15 13:18:59 |
| 15664 | 7850 | 2 | 2019-04-15 13:28:59 |
| 15665 | 7836 | 2 | 2019-04-15 13:29:16 |
| 15666 | 7859 | 2 | 2019-04-15 13:29:21 |
| 15667 | 7826 | 2 | 2019-04-15 13:29:22 |
| 15668 | 7840 | 2 | 2019-04-15 13:32:42 |
| 15669 | 7870 | 2 | 2019-04-15 13:34:35 |
| 15670 | 7856 | 2 | 2019-04-15 13:35:22 |
| 15671 | 7867 | 2 | 2019-04-15 13:36:01 |
| 15672 | 7864 | 2 | 2019-04-15 13:39:37 |
| 15673 | 7857 | 2 | 2019-04-15 13:42:06 |
| 15674 | 7837 | 2 | 2019-04-15 13:44:13 |
| 15675 | 7849 | 2 | 2019-04-15 13:44:31 |
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;