Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,051–15,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15051 | 7789 | 3 | 2019-03-11 10:13:54 |
| 15052 | 7793 | 1 | 2019-03-11 10:20:15 |
| 15053 | 7792 | 3 | 2019-03-11 10:23:35 |
| 15054 | 7740 | 2 | 2019-03-11 10:25:01 |
| 15055 | 7794 | 2 | 2019-03-11 10:35:46 |
| 15056 | 7791 | 2 | 2019-03-11 10:44:27 |
| 15057 | 7790 | 3 | 2019-03-11 10:46:42 |
| 15058 | 7792 | 2 | 2019-03-11 11:11:26 |
| 15059 | 7788 | 2 | 2019-03-11 11:16:25 |
| 15060 | 7740 | 3 | 2019-03-11 11:32:12 |
| 15061 | 7793 | 3 | 2019-03-11 11:43:29 |
| 15062 | 7789 | 2 | 2019-03-11 11:47:32 |
| 15063 | 7792 | 1 | 2019-03-11 11:49:30 |
| 15064 | 7794 | 1 | 2019-03-11 12:07:52 |
| 15065 | 7790 | 2 | 2019-03-11 12:12:02 |
| 15066 | 7798 | 3 | 2019-03-12 10:58:12 |
| 15067 | 7799 | 3 | 2019-03-12 11:02:00 |
| 15068 | 7739 | 3 | 2019-03-12 11:06:58 |
| 15069 | 7800 | 2 | 2019-03-12 12:30:48 |
| 15070 | 7800 | 3 | 2019-03-12 13:15:57 |
| 15071 | 7800 | 2 | 2019-03-12 14:20:30 |
| 15072 | 7771 | 2 | 2019-03-12 15:17:29 |
| 15073 | 7772 | 2 | 2019-03-12 15:18:20 |
| 15074 | 7772 | 3 | 2019-03-12 15:59:25 |
| 15075 | 7771 | 3 | 2019-03-12 16:33:21 |
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;