Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,201–11,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11201 | 5749 | 3 | 2018-05-12 13:09:07 |
| 11202 | 5757 | 2 | 2018-05-12 15:57:29 |
| 11203 | 5756 | 2 | 2018-05-12 16:03:48 |
| 11204 | 5756 | 1 | 2018-05-12 16:56:47 |
| 11205 | 5757 | 1 | 2018-05-12 17:06:38 |
| 11206 | 5740 | 2 | 2018-05-13 09:46:02 |
| 11207 | 5758 | 1 | 2018-05-13 10:11:29 |
| 11208 | 5759 | 1 | 2018-05-13 10:13:15 |
| 11209 | 5760 | 2 | 2018-05-13 11:01:21 |
| 11210 | 5761 | 2 | 2018-05-13 11:03:48 |
| 11211 | 5758 | 2 | 2018-05-13 11:06:51 |
| 11212 | 5759 | 2 | 2018-05-13 11:25:10 |
| 11213 | 5761 | 3 | 2018-05-13 11:39:03 |
| 11214 | 5760 | 3 | 2018-05-13 12:05:08 |
| 11215 | 5751 | 2 | 2018-05-13 12:17:41 |
| 11216 | 5753 | 2 | 2018-05-13 12:19:13 |
| 11217 | 5752 | 2 | 2018-05-13 12:20:00 |
| 11218 | 5750 | 2 | 2018-05-13 12:20:17 |
| 11219 | 5761 | 1 | 2018-05-13 12:35:26 |
| 11220 | 5760 | 1 | 2018-05-13 12:51:47 |
| 11221 | 5762 | 2 | 2018-05-13 13:18:33 |
| 11222 | 5751 | 1 | 2018-05-13 13:21:07 |
| 11223 | 5763 | 2 | 2018-05-13 13:25:55 |
| 11224 | 5775 | 2 | 2018-05-15 10:11:04 |
| 11225 | 5778 | 2 | 2018-05-15 10:20:06 |
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;