Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,051–10,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10051 | 5015 | 1 | 2018-01-19 16:41:14 |
| 10052 | 5028 | 1 | 2018-01-19 16:41:20 |
| 10053 | 5013 | 1 | 2018-01-19 16:41:24 |
| 10054 | 5006 | 1 | 2018-01-19 16:41:51 |
| 10055 | 5007 | 1 | 2018-01-19 16:44:48 |
| 10056 | 5026 | 1 | 2018-01-19 16:46:10 |
| 10057 | 5031 | 1 | 2018-01-19 16:46:15 |
| 10058 | 5016 | 1 | 2018-01-19 16:47:28 |
| 10059 | 4999 | 1 | 2018-01-19 16:51:22 |
| 10060 | 4997 | 1 | 2018-01-19 16:53:23 |
| 10061 | 5003 | 1 | 2018-01-19 17:00:54 |
| 10062 | 5024 | 1 | 2018-01-19 17:19:24 |
| 10063 | 5018 | 1 | 2018-01-19 17:38:37 |
| 10064 | 5134 | 2 | 2018-01-20 11:05:39 |
| 10065 | 5135 | 2 | 2018-01-20 11:09:55 |
| 10066 | 5205 | 2 | 2018-01-20 11:28:50 |
| 10067 | 5207 | 2 | 2018-01-20 11:31:25 |
| 10068 | 5206 | 2 | 2018-01-20 11:36:00 |
| 10069 | 5134 | 3 | 2018-01-20 11:38:37 |
| 10070 | 5206 | 3 | 2018-01-20 12:12:02 |
| 10071 | 5135 | 3 | 2018-01-20 12:40:15 |
| 10072 | 5205 | 3 | 2018-01-20 12:40:45 |
| 10073 | 5207 | 3 | 2018-01-20 12:44:03 |
| 10074 | 5207 | 1 | 2018-01-20 13:19:03 |
| 10075 | 5133 | 2 | 2018-01-20 15:33:35 |
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;