Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,926–11,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11926 | 5993 | 3 | 2018-07-17 12:01:11 |
| 11927 | 5985 | 3 | 2018-07-17 12:05:29 |
| 11928 | 6014 | 3 | 2018-07-17 12:05:32 |
| 11929 | 5983 | 3 | 2018-07-17 12:07:47 |
| 11930 | 6001 | 3 | 2018-07-17 12:09:20 |
| 11931 | 6242 | 2 | 2018-07-17 12:14:52 |
| 11932 | 5999 | 3 | 2018-07-17 12:16:00 |
| 11933 | 5984 | 3 | 2018-07-17 12:16:08 |
| 11934 | 5982 | 3 | 2018-07-17 12:18:59 |
| 11935 | 5966 | 3 | 2018-07-17 12:19:22 |
| 11936 | 5971 | 3 | 2018-07-17 12:20:08 |
| 11937 | 5961 | 3 | 2018-07-17 12:21:16 |
| 11938 | 5965 | 3 | 2018-07-17 12:22:11 |
| 11939 | 6003 | 3 | 2018-07-17 12:24:52 |
| 11940 | 5997 | 3 | 2018-07-17 12:24:53 |
| 11941 | 6010 | 3 | 2018-07-17 12:25:43 |
| 11942 | 6243 | 3 | 2018-07-17 12:35:49 |
| 11943 | 5991 | 3 | 2018-07-17 12:37:39 |
| 11944 | 5989 | 3 | 2018-07-17 12:37:52 |
| 11945 | 5981 | 3 | 2018-07-17 12:39:45 |
| 11946 | 5960 | 3 | 2018-07-17 12:40:11 |
| 11947 | 5964 | 3 | 2018-07-17 12:40:54 |
| 11948 | 5972 | 3 | 2018-07-17 12:41:20 |
| 11949 | 6013 | 3 | 2018-07-17 12:47:08 |
| 11950 | 6005 | 3 | 2018-07-17 12:48:04 |
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;