Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,126–3,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3126 | 1603 | 1 | 2015-12-19 16:23:01 |
| 3127 | 1602 | 2 | 2015-12-19 16:38:05 |
| 3128 | 1603 | 2 | 2015-12-19 17:24:53 |
| 3129 | 1590 | 1 | 2015-12-21 12:36:41 |
| 3130 | 1613 | 1 | 2015-12-21 12:59:25 |
| 3131 | 1611 | 1 | 2015-12-21 13:01:09 |
| 3132 | 1612 | 1 | 2015-12-21 13:03:55 |
| 3133 | 1590 | 2 | 2015-12-21 13:31:41 |
| 3134 | 1611 | 3 | 2015-12-21 13:38:29 |
| 3135 | 1613 | 3 | 2015-12-21 13:42:53 |
| 3136 | 1612 | 3 | 2015-12-21 13:50:40 |
| 3137 | 1612 | 2 | 2015-12-21 14:17:26 |
| 3138 | 1590 | 1 | 2015-12-21 14:25:40 |
| 3139 | 1611 | 2 | 2015-12-21 14:39:29 |
| 3140 | 1613 | 2 | 2015-12-21 15:05:26 |
| 3141 | 1617 | 2 | 2015-12-21 15:12:33 |
| 3142 | 1616 | 2 | 2015-12-21 15:15:07 |
| 3143 | 1615 | 2 | 2015-12-21 15:18:00 |
| 3144 | 1614 | 2 | 2015-12-21 15:19:04 |
| 3145 | 1616 | 3 | 2015-12-21 15:56:55 |
| 3146 | 1614 | 3 | 2015-12-21 16:09:34 |
| 3147 | 1617 | 3 | 2015-12-21 16:15:44 |
| 3148 | 1615 | 3 | 2015-12-21 16:16:23 |
| 3149 | 1618 | 2 | 2015-12-22 09:54:35 |
| 3150 | 1619 | 2 | 2015-12-22 10:33: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;