Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,201–3,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3201 | 1649 | 1 | 2015-12-28 13:28:57 |
| 3202 | 1650 | 1 | 2015-12-28 13:54:23 |
| 3203 | 1649 | 2 | 2015-12-28 14:24:08 |
| 3204 | 1650 | 2 | 2015-12-28 14:25:41 |
| 3205 | 1652 | 2 | 2015-12-29 10:55:19 |
| 3206 | 1652 | 3 | 2015-12-29 11:52:39 |
| 3207 | 1652 | 1 | 2015-12-29 13:04:12 |
| 3208 | 1623 | 1 | 2015-12-29 15:19:51 |
| 3209 | 1624 | 3 | 2015-12-29 15:22:35 |
| 3210 | 1623 | 2 | 2015-12-29 16:35:07 |
| 3211 | 1654 | 1 | 2015-12-30 15:25:11 |
| 3212 | 1653 | 3 | 2015-12-30 15:30:37 |
| 3213 | 1653 | 2 | 2015-12-30 16:24:31 |
| 3214 | 1654 | 2 | 2015-12-30 16:40:13 |
| 3215 | 1656 | 2 | 2015-12-30 16:52:49 |
| 3216 | 1655 | 2 | 2015-12-30 17:05:50 |
| 3217 | 1657 | 3 | 2015-12-31 10:30:46 |
| 3218 | 1657 | 1 | 2015-12-31 11:20:28 |
| 3219 | 1658 | 3 | 2015-12-31 12:55:03 |
| 3220 | 1659 | 3 | 2015-12-31 12:55:19 |
| 3221 | 1659 | 1 | 2015-12-31 13:47:25 |
| 3222 | 1658 | 1 | 2015-12-31 13:59:52 |
| 3223 | 1633 | 2 | 2016-01-01 13:57:13 |
| 3224 | 1633 | 3 | 2016-01-01 15:12:40 |
| 3225 | 1672 | 2 | 2016-01-02 09:17: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;