Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,801–11,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11801 | 5964 | 3 | 2018-07-17 10:07:43 |
| 11802 | 6009 | 3 | 2018-07-17 10:08:24 |
| 11803 | 5984 | 3 | 2018-07-17 10:08:26 |
| 11804 | 5976 | 3 | 2018-07-17 10:08:59 |
| 11805 | 6014 | 3 | 2018-07-17 10:09:54 |
| 11806 | 5967 | 3 | 2018-07-17 10:10:38 |
| 11807 | 5971 | 3 | 2018-07-17 10:11:07 |
| 11808 | 5974 | 3 | 2018-07-17 10:11:13 |
| 11809 | 5960 | 3 | 2018-07-17 10:11:25 |
| 11810 | 5965 | 3 | 2018-07-17 10:11:35 |
| 11811 | 6000 | 3 | 2018-07-17 10:12:34 |
| 11812 | 5994 | 3 | 2018-07-17 10:12:36 |
| 11813 | 5963 | 3 | 2018-07-17 10:13:06 |
| 11814 | 5980 | 3 | 2018-07-17 10:13:15 |
| 11815 | 5970 | 3 | 2018-07-17 10:13:24 |
| 11816 | 5985 | 3 | 2018-07-17 10:13:52 |
| 11817 | 6007 | 3 | 2018-07-17 10:14:12 |
| 11818 | 5982 | 3 | 2018-07-17 10:14:27 |
| 11819 | 5997 | 3 | 2018-07-17 10:14:27 |
| 11820 | 6012 | 3 | 2018-07-17 10:14:32 |
| 11821 | 5983 | 3 | 2018-07-17 10:14:33 |
| 11822 | 5968 | 3 | 2018-07-17 10:15:13 |
| 11823 | 6001 | 3 | 2018-07-17 10:15:20 |
| 11824 | 5969 | 3 | 2018-07-17 10:15:53 |
| 11825 | 5991 | 3 | 2018-07-17 10:15:56 |
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;