Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,151–3,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3151 | 1620 | 2 | 2015-12-22 10:37:57 |
| 3152 | 1618 | 1 | 2015-12-22 10:54:14 |
| 3153 | 1620 | 3 | 2015-12-22 11:13:01 |
| 3154 | 1619 | 3 | 2015-12-22 11:19:06 |
| 3155 | 1456 | 2 | 2015-12-22 12:19:53 |
| 3156 | 1456 | 1 | 2015-12-22 12:47:23 |
| 3157 | 1625 | 2 | 2015-12-22 15:40:43 |
| 3158 | 1625 | 1 | 2015-12-22 16:20:48 |
| 3159 | 1607 | 1 | 2015-12-22 16:32:26 |
| 3160 | 1606 | 1 | 2015-12-22 16:44:03 |
| 3161 | 1607 | 3 | 2015-12-22 17:04:02 |
| 3162 | 1629 | 1 | 2015-12-23 09:11:29 |
| 3163 | 1628 | 1 | 2015-12-23 09:15:19 |
| 3164 | 1626 | 1 | 2015-12-23 09:18:01 |
| 3165 | 1630 | 1 | 2015-12-23 09:18:37 |
| 3166 | 1627 | 1 | 2015-12-23 09:22:00 |
| 3167 | 1628 | 3 | 2015-12-23 09:42:27 |
| 3168 | 1629 | 3 | 2015-12-23 10:01:14 |
| 3169 | 1630 | 3 | 2015-12-23 10:36:25 |
| 3170 | 1626 | 3 | 2015-12-23 10:37:41 |
| 3171 | 1627 | 3 | 2015-12-23 10:40:05 |
| 3172 | 1610 | 1 | 2015-12-24 11:38:31 |
| 3173 | 1610 | 3 | 2015-12-24 12:43:11 |
| 3174 | 1585 | 2 | 2015-12-25 14:29:46 |
| 3175 | 1585 | 3 | 2015-12-25 15:56:32 |
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;