Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,751–13,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13751 | 7005 | 1 | 2018-11-12 11:09:07 |
| 13752 | 7006 | 1 | 2018-11-12 11:14:49 |
| 13753 | 7006 | 2 | 2018-11-12 12:29:44 |
| 13754 | 7005 | 2 | 2018-11-12 12:38:52 |
| 13755 | 7052 | 2 | 2018-11-13 11:30:41 |
| 13756 | 7052 | 1 | 2018-11-13 12:55:29 |
| 13757 | 7052 | 3 | 2018-11-13 14:10:34 |
| 13758 | 7054 | 3 | 2018-11-13 14:21:50 |
| 13759 | 7053 | 2 | 2018-11-13 14:24:29 |
| 13760 | 7056 | 2 | 2018-11-13 14:26:06 |
| 13761 | 7055 | 2 | 2018-11-13 14:27:01 |
| 13762 | 7057 | 2 | 2018-11-13 14:33:12 |
| 13763 | 7054 | 2 | 2018-11-13 15:15:41 |
| 13764 | 7057 | 3 | 2018-11-13 15:44:52 |
| 13765 | 7055 | 3 | 2018-11-13 15:48:00 |
| 13766 | 7053 | 3 | 2018-11-13 15:49:41 |
| 13767 | 7054 | 3 | 2018-11-13 16:21:47 |
| 13768 | 7063 | 2 | 2018-11-14 15:28:11 |
| 13769 | 7061 | 2 | 2018-11-15 10:57:55 |
| 13770 | 7059 | 2 | 2018-11-15 10:59:47 |
| 13771 | 7060 | 3 | 2018-11-15 11:06:06 |
| 13772 | 7058 | 2 | 2018-11-15 11:09:09 |
| 13773 | 7061 | 3 | 2018-11-15 11:28:47 |
| 13774 | 7065 | 2 | 2018-11-15 11:49:23 |
| 13775 | 7066 | 1 | 2018-11-15 11:51:23 |
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;