Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,701–9,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9701 | 4941 | 3 | 2017-12-17 11:34:27 |
| 9702 | 4915 | 1 | 2017-12-17 11:40:05 |
| 9703 | 4940 | 2 | 2017-12-17 12:26:53 |
| 9704 | 4914 | 1 | 2017-12-17 13:03:57 |
| 9705 | 4914 | 2 | 2017-12-17 14:05:40 |
| 9706 | 4918 | 1 | 2017-12-18 09:55:23 |
| 9707 | 4917 | 1 | 2017-12-18 09:58:21 |
| 9708 | 4916 | 1 | 2017-12-18 09:58:43 |
| 9709 | 4916 | 3 | 2017-12-18 10:42:58 |
| 9710 | 4918 | 3 | 2017-12-18 11:00:32 |
| 9711 | 4962 | 1 | 2017-12-18 11:08:26 |
| 9712 | 4917 | 3 | 2017-12-18 11:14:02 |
| 9713 | 4961 | 1 | 2017-12-18 11:20:44 |
| 9714 | 4962 | 2 | 2017-12-18 11:35:05 |
| 9715 | 4966 | 1 | 2017-12-18 12:33:44 |
| 9716 | 4961 | 2 | 2017-12-18 12:36:33 |
| 9717 | 4965 | 2 | 2017-12-18 12:38:20 |
| 9718 | 4963 | 2 | 2017-12-18 12:40:20 |
| 9719 | 4964 | 2 | 2017-12-18 12:40:49 |
| 9720 | 4962 | 3 | 2017-12-18 12:44:49 |
| 9721 | 4961 | 3 | 2017-12-18 13:20:44 |
| 9722 | 4969 | 2 | 2017-12-18 13:49:02 |
| 9723 | 4965 | 3 | 2017-12-18 13:50:10 |
| 9724 | 4967 | 2 | 2017-12-18 13:53:31 |
| 9725 | 4968 | 2 | 2017-12-18 13:56:03 |
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;