Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,976–12,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11976 | 6250 | 1 | 2018-07-17 14:28:19 |
| 11977 | 6252 | 1 | 2018-07-17 14:30:47 |
| 11978 | 6248 | 1 | 2018-07-17 14:35:44 |
| 11979 | 6251 | 1 | 2018-07-17 14:35:54 |
| 11980 | 6239 | 1 | 2018-07-17 14:40:32 |
| 11981 | 6237 | 2 | 2018-07-17 14:46:57 |
| 11982 | 6250 | 2 | 2018-07-17 15:04:07 |
| 11983 | 6240 | 2 | 2018-07-17 15:07:46 |
| 11984 | 6252 | 2 | 2018-07-17 15:08:41 |
| 11985 | 6238 | 2 | 2018-07-17 15:17:47 |
| 11986 | 6251 | 2 | 2018-07-17 15:23:00 |
| 11987 | 6215 | 3 | 2018-07-17 15:34:42 |
| 11988 | 6249 | 2 | 2018-07-17 16:01:26 |
| 11989 | 6239 | 2 | 2018-07-17 16:06:08 |
| 11990 | 6255 | 2 | 2018-07-18 10:11:42 |
| 11991 | 6256 | 1 | 2018-07-18 10:13:18 |
| 11992 | 6253 | 3 | 2018-07-18 10:16:45 |
| 11993 | 6254 | 3 | 2018-07-18 10:18:28 |
| 11994 | 6255 | 1 | 2018-07-18 10:39:39 |
| 11995 | 6254 | 2 | 2018-07-18 10:47:42 |
| 11996 | 6256 | 3 | 2018-07-18 11:03:49 |
| 11997 | 6253 | 2 | 2018-07-18 11:41:55 |
| 11998 | 6254 | 3 | 2018-07-18 11:42:05 |
| 11999 | 6257 | 2 | 2018-07-18 12:03:49 |
| 12000 | 6258 | 2 | 2018-07-18 12:13:30 |
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;