Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,126–12,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12126 | 6290 | 2 | 2018-07-28 10:24:54 |
| 12127 | 6300 | 3 | 2018-07-28 10:42:05 |
| 12128 | 6289 | 2 | 2018-07-28 11:04:09 |
| 12129 | 6301 | 3 | 2018-07-28 11:06:45 |
| 12130 | 6287 | 2 | 2018-07-28 11:14:00 |
| 12131 | 6288 | 2 | 2018-07-28 11:15:43 |
| 12132 | 6300 | 1 | 2018-07-28 11:39:18 |
| 12133 | 6301 | 1 | 2018-07-28 11:58:17 |
| 12134 | 6303 | 2 | 2018-07-28 13:29:38 |
| 12135 | 6310 | 1 | 2018-07-29 09:32:17 |
| 12136 | 6307 | 1 | 2018-07-29 09:33:02 |
| 12137 | 6309 | 1 | 2018-07-29 09:35:39 |
| 12138 | 6308 | 3 | 2018-07-29 09:42:55 |
| 12139 | 6309 | 3 | 2018-07-29 10:31:40 |
| 12140 | 6307 | 3 | 2018-07-29 10:48:04 |
| 12141 | 6310 | 3 | 2018-07-29 10:50:59 |
| 12142 | 6308 | 1 | 2018-07-29 11:14:49 |
| 12143 | 6219 | 3 | 2018-07-29 11:28:43 |
| 12144 | 6220 | 3 | 2018-07-29 11:28:45 |
| 12145 | 6309 | 2 | 2018-07-29 11:55:33 |
| 12146 | 6307 | 2 | 2018-07-29 12:04:18 |
| 12147 | 6310 | 2 | 2018-07-29 12:05:03 |
| 12148 | 6219 | 2 | 2018-07-29 12:30:16 |
| 12149 | 6279 | 2 | 2018-07-29 12:34:38 |
| 12150 | 6278 | 2 | 2018-07-29 12:36:04 |
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;