Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,776–18,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18776 | 9351 | 2 | 2019-12-18 13:50:26 |
| 18777 | 9352 | 3 | 2019-12-18 13:55:35 |
| 18778 | 9539 | 2 | 2019-12-19 11:17:09 |
| 18779 | 9539 | 3 | 2019-12-19 12:33:28 |
| 18780 | 9539 | 1 | 2019-12-19 13:08:11 |
| 18781 | 9568 | 3 | 2019-12-19 14:28:03 |
| 18782 | 9539 | 3 | 2019-12-19 14:32:49 |
| 18783 | 9553 | 3 | 2019-12-20 09:40:57 |
| 18784 | 9552 | 1 | 2019-12-20 09:44:02 |
| 18785 | 9553 | 1 | 2019-12-20 10:29:37 |
| 18786 | 9552 | 2 | 2019-12-20 11:18:32 |
| 18787 | 9553 | 2 | 2019-12-20 11:49:44 |
| 18788 | 9552 | 1 | 2019-12-20 12:20:55 |
| 18789 | 9553 | 3 | 2019-12-20 13:04:38 |
| 18790 | 9552 | 3 | 2019-12-20 13:28:47 |
| 18791 | 9247 | 2 | 2019-12-20 14:05:52 |
| 18792 | 9248 | 2 | 2019-12-20 14:07:06 |
| 18793 | 9253 | 2 | 2019-12-20 14:07:10 |
| 18794 | 9250 | 2 | 2019-12-20 14:07:45 |
| 18795 | 9252 | 2 | 2019-12-20 14:07:53 |
| 18796 | 9259 | 2 | 2019-12-20 14:08:39 |
| 18797 | 9242 | 2 | 2019-12-20 14:08:45 |
| 18798 | 9258 | 2 | 2019-12-20 14:09:26 |
| 18799 | 9272 | 2 | 2019-12-20 14:09:44 |
| 18800 | 9261 | 2 | 2019-12-20 14:10:37 |
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;