Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,301–3,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3301 | 1741 | 2 | 2016-01-18 09:28:35 |
| 3302 | 1735 | 2 | 2016-01-18 10:04:32 |
| 3303 | 1736 | 2 | 2016-01-18 10:09:41 |
| 3304 | 1742 | 1 | 2016-01-18 10:34:31 |
| 3305 | 1741 | 1 | 2016-01-18 10:58:32 |
| 3306 | 1622 | 1 | 2016-01-21 10:23:07 |
| 3307 | 1621 | 2 | 2016-01-21 10:30:54 |
| 3308 | 1622 | 2 | 2016-01-21 11:40:21 |
| 3309 | 1621 | 3 | 2016-01-21 11:57:53 |
| 3310 | 1622 | 1 | 2016-01-21 12:17:47 |
| 3311 | 1622 | 3 | 2016-01-21 13:14:58 |
| 3312 | 1750 | 1 | 2016-01-22 10:45:05 |
| 3313 | 1751 | 2 | 2016-01-22 10:45:41 |
| 3314 | 1751 | 3 | 2016-01-22 11:56:42 |
| 3315 | 1751 | 1 | 2016-01-22 12:40:37 |
| 3316 | 1751 | 2 | 2016-01-22 13:44:28 |
| 3317 | 1754 | 2 | 2016-01-23 09:27:09 |
| 3318 | 1752 | 2 | 2016-01-23 09:29:27 |
| 3319 | 1753 | 3 | 2016-01-23 09:30:51 |
| 3320 | 1755 | 2 | 2016-01-23 09:38:30 |
| 3321 | 1756 | 2 | 2016-01-23 09:43:56 |
| 3322 | 1753 | 1 | 2016-01-23 10:08:41 |
| 3323 | 1755 | 3 | 2016-01-23 10:24:26 |
| 3324 | 1756 | 3 | 2016-01-23 10:26:22 |
| 3325 | 1757 | 1 | 2016-01-23 11:27:48 |
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;