Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,101–14,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14101 | 7246 | 2 | 2018-12-07 09:46:37 |
| 14102 | 7243 | 1 | 2018-12-07 09:52:40 |
| 14103 | 7244 | 1 | 2018-12-07 09:52:53 |
| 14104 | 7241 | 3 | 2018-12-07 10:12:34 |
| 14105 | 7246 | 1 | 2018-12-07 10:30:01 |
| 14106 | 7243 | 2 | 2018-12-07 10:33:59 |
| 14107 | 7245 | 2 | 2018-12-07 10:34:14 |
| 14108 | 7242 | 2 | 2018-12-07 10:52:46 |
| 14109 | 7244 | 2 | 2018-12-07 10:53:38 |
| 14110 | 7243 | 3 | 2018-12-07 11:10:46 |
| 14111 | 7245 | 3 | 2018-12-07 11:57:26 |
| 14112 | 7242 | 3 | 2018-12-07 12:03:56 |
| 14113 | 7244 | 3 | 2018-12-07 12:11:04 |
| 14114 | 7217 | 2 | 2018-12-08 12:04:34 |
| 14115 | 7218 | 2 | 2018-12-08 12:12:05 |
| 14116 | 7214 | 2 | 2018-12-08 13:34:56 |
| 14117 | 7080 | 2 | 2018-12-08 16:35:05 |
| 14118 | 7080 | 3 | 2018-12-08 17:37:57 |
| 14119 | 7249 | 2 | 2018-12-09 10:37:58 |
| 14120 | 7248 | 2 | 2018-12-09 10:40:42 |
| 14121 | 7225 | 2 | 2018-12-09 11:11:32 |
| 14122 | 7248 | 1 | 2018-12-09 11:25:32 |
| 14123 | 7225 | 1 | 2018-12-09 12:39:09 |
| 14124 | 7248 | 3 | 2018-12-09 12:42:43 |
| 14125 | 6800 | 2 | 2018-12-09 12:49:00 |
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;