Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,976–5,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4976 | 2479 | 1 | 2016-07-18 14:53:18 |
| 4977 | 2478 | 1 | 2016-07-18 15:09:50 |
| 4978 | 2477 | 1 | 2016-07-18 15:13:24 |
| 4979 | 2476 | 3 | 2016-07-18 15:23:42 |
| 4980 | 2462 | 2 | 2016-07-18 15:26:58 |
| 4981 | 2461 | 2 | 2016-07-18 15:27:21 |
| 4982 | 2460 | 2 | 2016-07-18 15:32:21 |
| 4983 | 2479 | 3 | 2016-07-18 15:49:03 |
| 4984 | 2477 | 3 | 2016-07-18 15:52:17 |
| 4985 | 2478 | 3 | 2016-07-18 16:02:41 |
| 4986 | 2461 | 1 | 2016-07-18 16:13:10 |
| 4987 | 2462 | 1 | 2016-07-18 16:13:36 |
| 4988 | 2460 | 1 | 2016-07-18 16:23:44 |
| 4989 | 2462 | 3 | 2016-07-18 17:06:57 |
| 4990 | 2460 | 3 | 2016-07-18 17:19:05 |
| 4991 | 2461 | 3 | 2016-07-18 17:28:42 |
| 4992 | 2520 | 2 | 2016-07-19 14:12:57 |
| 4993 | 2521 | 2 | 2016-07-19 14:21:59 |
| 4994 | 2528 | 2 | 2016-07-20 10:24:35 |
| 4995 | 2529 | 2 | 2016-07-20 10:31:07 |
| 4996 | 2529 | 3 | 2016-07-20 12:03:15 |
| 4997 | 2530 | 2 | 2016-07-20 16:51:36 |
| 4998 | 2531 | 2 | 2016-07-20 16:54:14 |
| 4999 | 2536 | 1 | 2016-07-21 15:41:11 |
| 5000 | 2535 | 2 | 2016-07-21 15:53:17 |
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;