Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,726–11,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11726 | 6196 | 3 | 2018-07-10 15:07:37 |
| 11727 | 6065 | 1 | 2018-07-11 09:55:10 |
| 11728 | 6064 | 1 | 2018-07-11 09:56:14 |
| 11729 | 6064 | 2 | 2018-07-11 10:45:20 |
| 11730 | 6065 | 2 | 2018-07-11 10:50:35 |
| 11731 | 6202 | 1 | 2018-07-11 10:58:52 |
| 11732 | 6108 | 2 | 2018-07-11 11:43:24 |
| 11733 | 6109 | 3 | 2018-07-11 11:49:13 |
| 11734 | 6202 | 3 | 2018-07-11 12:26:21 |
| 11735 | 6109 | 1 | 2018-07-11 12:36:50 |
| 11736 | 6108 | 1 | 2018-07-11 13:11:02 |
| 11737 | 6202 | 2 | 2018-07-11 13:48:59 |
| 11738 | 6202 | 3 | 2018-07-11 14:36:15 |
| 11739 | 6169 | 1 | 2018-07-12 10:35:07 |
| 11740 | 6168 | 2 | 2018-07-12 10:38:13 |
| 11741 | 6207 | 3 | 2018-07-12 10:47:48 |
| 11742 | 6169 | 3 | 2018-07-12 11:06:10 |
| 11743 | 6209 | 2 | 2018-07-12 11:46:28 |
| 11744 | 6211 | 1 | 2018-07-12 11:47:07 |
| 11745 | 6212 | 1 | 2018-07-12 11:47:49 |
| 11746 | 6208 | 1 | 2018-07-12 11:48:37 |
| 11747 | 6210 | 2 | 2018-07-12 11:55:56 |
| 11748 | 6207 | 2 | 2018-07-12 12:22:48 |
| 11749 | 6211 | 2 | 2018-07-12 12:24:40 |
| 11750 | 6210 | 3 | 2018-07-12 12:28:53 |
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;