Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,851–11,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11851 | 5973 | 1 | 2018-07-17 10:34:49 |
| 11852 | 5969 | 1 | 2018-07-17 10:41:55 |
| 11853 | 6012 | 1 | 2018-07-17 10:42:35 |
| 11854 | 5979 | 1 | 2018-07-17 10:43:19 |
| 11855 | 6243 | 3 | 2018-07-17 10:44:41 |
| 11856 | 5974 | 1 | 2018-07-17 10:47:10 |
| 11857 | 5988 | 1 | 2018-07-17 10:49:34 |
| 11858 | 6009 | 1 | 2018-07-17 10:51:47 |
| 11859 | 5967 | 1 | 2018-07-17 10:53:29 |
| 11860 | 6008 | 1 | 2018-07-17 10:54:55 |
| 11861 | 6242 | 3 | 2018-07-17 10:54:58 |
| 11862 | 5966 | 1 | 2018-07-17 10:55:52 |
| 11863 | 6011 | 1 | 2018-07-17 10:56:33 |
| 11864 | 5975 | 1 | 2018-07-17 10:56:58 |
| 11865 | 5965 | 1 | 2018-07-17 10:57:06 |
| 11866 | 5982 | 1 | 2018-07-17 11:00:23 |
| 11867 | 5985 | 1 | 2018-07-17 11:03:39 |
| 11868 | 5999 | 1 | 2018-07-17 11:05:31 |
| 11869 | 6014 | 1 | 2018-07-17 11:05:45 |
| 11870 | 5962 | 1 | 2018-07-17 11:06:56 |
| 11871 | 5980 | 1 | 2018-07-17 11:08:52 |
| 11872 | 5996 | 1 | 2018-07-17 11:10:22 |
| 11873 | 5983 | 1 | 2018-07-17 11:11:57 |
| 11874 | 5961 | 1 | 2018-07-17 11:12:47 |
| 11875 | 5964 | 1 | 2018-07-17 11:13:32 |
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;