Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,176–19,200 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19176 | 9651 | 2 | 2020-01-12 15:42:17 |
| 19177 | 9650 | 2 | 2020-01-12 15:46:19 |
| 19178 | 9668 | 2 | 2020-01-13 09:52:22 |
| 19179 | 9667 | 2 | 2020-01-13 10:00:21 |
| 19180 | 9666 | 2 | 2020-01-13 10:05:24 |
| 19181 | 9668 | 3 | 2020-01-13 10:39:00 |
| 19182 | 9667 | 3 | 2020-01-13 11:16:44 |
| 19183 | 9666 | 3 | 2020-01-13 11:33:36 |
| 19184 | 9535 | 2 | 2020-01-13 16:48:48 |
| 19185 | 9659 | 3 | 2020-01-14 09:57:16 |
| 19186 | 9660 | 3 | 2020-01-14 10:05:50 |
| 19187 | 9661 | 3 | 2020-01-14 10:08:24 |
| 19188 | 9675 | 1 | 2020-01-14 10:29:25 |
| 19189 | 9659 | 2 | 2020-01-14 10:39:37 |
| 19190 | 9673 | 3 | 2020-01-14 11:20:19 |
| 19191 | 9661 | 2 | 2020-01-14 11:23:23 |
| 19192 | 9660 | 2 | 2020-01-14 11:30:06 |
| 19193 | 9674 | 3 | 2020-01-14 11:30:51 |
| 19194 | 9675 | 2 | 2020-01-14 11:58:14 |
| 19195 | 9676 | 2 | 2020-01-14 12:01:30 |
| 19196 | 9674 | 1 | 2020-01-14 12:39:00 |
| 19197 | 9673 | 1 | 2020-01-14 12:49:21 |
| 19198 | 9676 | 3 | 2020-01-14 12:54:17 |
| 19199 | 9673 | 3 | 2020-01-14 13:41:37 |
| 19200 | 9674 | 3 | 2020-01-14 14:08:05 |
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;