Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,026–15,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15026 | 7783 | 2 | 2019-03-08 11:35:45 |
| 15027 | 7731 | 1 | 2019-03-08 11:43:37 |
| 15028 | 7767 | 2 | 2019-03-08 11:57:19 |
| 15029 | 7732 | 1 | 2019-03-08 12:22:50 |
| 15030 | 7767 | 1 | 2019-03-08 12:37:48 |
| 15031 | 7782 | 2 | 2019-03-08 12:38:16 |
| 15032 | 7767 | 3 | 2019-03-08 13:03:19 |
| 15033 | 7783 | 1 | 2019-03-08 13:06:09 |
| 15034 | 7782 | 1 | 2019-03-08 13:20:35 |
| 15035 | 7784 | 2 | 2019-03-09 11:58:51 |
| 15036 | 7787 | 2 | 2019-03-09 12:03:24 |
| 15037 | 7785 | 2 | 2019-03-09 12:03:46 |
| 15038 | 7786 | 2 | 2019-03-09 12:10:42 |
| 15039 | 7786 | 3 | 2019-03-09 13:10:47 |
| 15040 | 7786 | 1 | 2019-03-09 14:09:55 |
| 15041 | 7614 | 2 | 2019-03-10 12:37:52 |
| 15042 | 7613 | 2 | 2019-03-10 12:43:52 |
| 15043 | 7615 | 2 | 2019-03-10 12:50:39 |
| 15044 | 7788 | 2 | 2019-03-11 09:25:56 |
| 15045 | 7791 | 2 | 2019-03-11 09:31:45 |
| 15046 | 7790 | 2 | 2019-03-11 09:32:07 |
| 15047 | 7789 | 2 | 2019-03-11 09:42:38 |
| 15048 | 7791 | 3 | 2019-03-11 09:58:52 |
| 15049 | 7788 | 3 | 2019-03-11 10:08:11 |
| 15050 | 7794 | 3 | 2019-03-11 10:10: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;