Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,701–5,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5701 | 2894 | 1 | 2016-10-18 13:40:45 |
| 5702 | 2893 | 1 | 2016-10-18 13:41:42 |
| 5703 | 2895 | 1 | 2016-10-18 13:47:06 |
| 5704 | 2896 | 1 | 2016-10-18 13:51:35 |
| 5705 | 2919 | 3 | 2016-10-19 13:00:15 |
| 5706 | 2923 | 1 | 2016-10-22 10:21:17 |
| 5707 | 2922 | 2 | 2016-10-22 10:22:01 |
| 5708 | 2924 | 2 | 2016-10-22 10:23:32 |
| 5709 | 2925 | 2 | 2016-10-22 10:26:48 |
| 5710 | 2926 | 2 | 2016-10-22 10:29:37 |
| 5711 | 2924 | 3 | 2016-10-22 10:51:00 |
| 5712 | 2922 | 1 | 2016-10-22 10:51:52 |
| 5713 | 2926 | 3 | 2016-10-22 11:27:56 |
| 5714 | 2925 | 3 | 2016-10-22 11:39:14 |
| 5715 | 2922 | 2 | 2016-10-22 12:15:09 |
| 5716 | 2922 | 3 | 2016-10-22 13:05:28 |
| 5717 | 2928 | 3 | 2016-10-22 16:33:08 |
| 5718 | 2927 | 3 | 2016-10-22 16:43:23 |
| 5719 | 2933 | 2 | 2016-10-25 12:03:43 |
| 5720 | 2934 | 2 | 2016-10-25 12:06:32 |
| 5721 | 2933 | 3 | 2016-10-25 12:36:07 |
| 5722 | 2934 | 3 | 2016-10-25 12:52:33 |
| 5723 | 2918 | 1 | 2016-10-26 17:15:15 |
| 5724 | 2704 | 2 | 2016-10-28 11:25:41 |
| 5725 | 2697 | 2 | 2016-10-28 11:25:53 |
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;