Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,826–11,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11826 | 5979 | 3 | 2018-07-17 10:16:17 |
| 11827 | 5978 | 3 | 2018-07-17 10:16:22 |
| 11828 | 5992 | 3 | 2018-07-17 10:17:51 |
| 11829 | 6002 | 3 | 2018-07-17 10:18:37 |
| 11830 | 5981 | 3 | 2018-07-17 10:18:41 |
| 11831 | 5966 | 3 | 2018-07-17 10:18:46 |
| 11832 | 6013 | 3 | 2018-07-17 10:18:52 |
| 11833 | 6010 | 3 | 2018-07-17 10:19:18 |
| 11834 | 6004 | 3 | 2018-07-17 10:19:41 |
| 11835 | 5993 | 3 | 2018-07-17 10:19:42 |
| 11836 | 5987 | 3 | 2018-07-17 10:20:17 |
| 11837 | 5988 | 3 | 2018-07-17 10:20:41 |
| 11838 | 6011 | 3 | 2018-07-17 10:20:51 |
| 11839 | 5975 | 3 | 2018-07-17 10:21:09 |
| 11840 | 6005 | 3 | 2018-07-17 10:21:29 |
| 11841 | 5999 | 3 | 2018-07-17 10:21:39 |
| 11842 | 5986 | 3 | 2018-07-17 10:21:41 |
| 11843 | 5990 | 3 | 2018-07-17 10:22:24 |
| 11844 | 6006 | 3 | 2018-07-17 10:22:41 |
| 11845 | 5995 | 3 | 2018-07-17 10:23:42 |
| 11846 | 6008 | 3 | 2018-07-17 10:24:26 |
| 11847 | 5996 | 3 | 2018-07-17 10:24:41 |
| 11848 | 6003 | 3 | 2018-07-17 10:25:06 |
| 11849 | 5989 | 3 | 2018-07-17 10:25:21 |
| 11850 | 5998 | 3 | 2018-07-17 10:26:42 |
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;