Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,401–13,425 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13401 | 6868 | 3 | 2018-10-09 14:33:52 |
| 13402 | 6847 | 2 | 2018-10-09 15:01:22 |
| 13403 | 6867 | 2 | 2018-10-09 15:11:39 |
| 13404 | 6866 | 2 | 2018-10-09 15:13:52 |
| 13405 | 6703 | 2 | 2018-10-09 15:23:33 |
| 13406 | 6702 | 2 | 2018-10-09 15:28:41 |
| 13407 | 6868 | 2 | 2018-10-09 16:09:19 |
| 13408 | 6773 | 2 | 2018-10-10 13:24:42 |
| 13409 | 6772 | 3 | 2018-10-10 13:28:34 |
| 13410 | 6772 | 1 | 2018-10-10 14:06:57 |
| 13411 | 6772 | 3 | 2018-10-10 14:51:29 |
| 13412 | 6789 | 2 | 2018-10-10 16:52:06 |
| 13413 | 6788 | 2 | 2018-10-10 17:00:56 |
| 13414 | 6789 | 3 | 2018-10-10 17:40:46 |
| 13415 | 6869 | 2 | 2018-10-11 11:02:03 |
| 13416 | 6508 | 3 | 2018-10-11 11:46:34 |
| 13417 | 6507 | 3 | 2018-10-11 11:53:32 |
| 13418 | 6871 | 1 | 2018-10-11 11:57:55 |
| 13419 | 6870 | 1 | 2018-10-11 12:00:40 |
| 13420 | 6869 | 1 | 2018-10-11 12:07:15 |
| 13421 | 6508 | 1 | 2018-10-11 12:22:03 |
| 13422 | 6507 | 1 | 2018-10-11 12:57:07 |
| 13423 | 6869 | 3 | 2018-10-11 13:10:33 |
| 13424 | 6870 | 2 | 2018-10-11 13:27:28 |
| 13425 | 6871 | 2 | 2018-10-11 13:29:17 |
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;