Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,126–15,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15126 | 7515 | 3 | 2019-03-15 13:24:51 |
| 15127 | 7513 | 3 | 2019-03-15 13:24:56 |
| 15128 | 7506 | 3 | 2019-03-15 13:25:40 |
| 15129 | 7523 | 3 | 2019-03-15 13:26:00 |
| 15130 | 7478 | 3 | 2019-03-15 13:26:46 |
| 15131 | 7500 | 3 | 2019-03-15 13:26:54 |
| 15132 | 7497 | 3 | 2019-03-15 13:27:15 |
| 15133 | 7490 | 3 | 2019-03-15 13:28:24 |
| 15134 | 7522 | 3 | 2019-03-15 13:29:00 |
| 15135 | 7509 | 3 | 2019-03-15 13:29:33 |
| 15136 | 7494 | 3 | 2019-03-15 13:29:45 |
| 15137 | 7516 | 3 | 2019-03-15 13:29:50 |
| 15138 | 7489 | 3 | 2019-03-15 13:29:57 |
| 15139 | 7512 | 3 | 2019-03-15 13:30:03 |
| 15140 | 7499 | 3 | 2019-03-15 13:30:18 |
| 15141 | 7525 | 3 | 2019-03-15 13:33:17 |
| 15142 | 7517 | 3 | 2019-03-15 13:33:52 |
| 15143 | 7511 | 3 | 2019-03-15 13:35:09 |
| 15144 | 7483 | 2 | 2019-03-15 13:44:02 |
| 15145 | 7487 | 2 | 2019-03-15 13:47:36 |
| 15146 | 7486 | 2 | 2019-03-15 13:49:12 |
| 15147 | 7485 | 2 | 2019-03-15 13:49:15 |
| 15148 | 7505 | 2 | 2019-03-15 13:51:36 |
| 15149 | 7518 | 2 | 2019-03-15 13:55:58 |
| 15150 | 7489 | 2 | 2019-03-15 13:56:16 |
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;