Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,976–16,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15976 | 8208 | 1 | 2019-05-14 13:13:06 |
| 15977 | 8209 | 1 | 2019-05-14 13:22:51 |
| 15978 | 8210 | 1 | 2019-05-14 13:29:20 |
| 15979 | 8208 | 3 | 2019-05-14 13:46:29 |
| 15980 | 8210 | 3 | 2019-05-14 13:59:48 |
| 15981 | 8209 | 3 | 2019-05-14 14:53:11 |
| 15982 | 8224 | 1 | 2019-05-15 11:14:14 |
| 15983 | 8223 | 2 | 2019-05-15 11:21:06 |
| 15984 | 8225 | 1 | 2019-05-15 11:28:35 |
| 15985 | 8224 | 2 | 2019-05-15 12:10:01 |
| 15986 | 8223 | 3 | 2019-05-15 12:40:14 |
| 15987 | 8225 | 3 | 2019-05-15 12:55:33 |
| 15988 | 8223 | 2 | 2019-05-15 13:49:36 |
| 15989 | 8225 | 1 | 2019-05-15 14:20:56 |
| 15990 | 8223 | 3 | 2019-05-15 14:45:15 |
| 15991 | 8225 | 3 | 2019-05-15 14:56:45 |
| 15992 | 8188 | 1 | 2019-05-16 14:48:43 |
| 15993 | 8190 | 1 | 2019-05-16 14:50:00 |
| 15994 | 8189 | 1 | 2019-05-16 14:52:39 |
| 15995 | 8196 | 3 | 2019-05-17 09:17:23 |
| 15996 | 8197 | 3 | 2019-05-17 09:21:27 |
| 15997 | 8233 | 2 | 2019-05-17 09:51:29 |
| 15998 | 8235 | 2 | 2019-05-17 09:53:02 |
| 15999 | 8234 | 2 | 2019-05-17 10:04:06 |
| 16000 | 8196 | 2 | 2019-05-17 10:33:34 |
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;