Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,976–10,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9976 | 5015 | 2 | 2018-01-19 14:39:58 |
| 9977 | 5021 | 3 | 2018-01-19 14:41:10 |
| 9978 | 5019 | 2 | 2018-01-19 14:42:22 |
| 9979 | 5025 | 2 | 2018-01-19 14:43:10 |
| 9980 | 5027 | 3 | 2018-01-19 14:45:03 |
| 9981 | 5007 | 2 | 2018-01-19 14:45:16 |
| 9982 | 4994 | 3 | 2018-01-19 14:45:35 |
| 9983 | 5009 | 2 | 2018-01-19 14:45:45 |
| 9984 | 5020 | 3 | 2018-01-19 14:46:40 |
| 9985 | 4993 | 3 | 2018-01-19 14:49:01 |
| 9986 | 5031 | 2 | 2018-01-19 14:49:20 |
| 9987 | 5018 | 2 | 2018-01-19 14:49:30 |
| 9988 | 5022 | 2 | 2018-01-19 14:53:00 |
| 9989 | 5023 | 2 | 2018-01-19 14:54:20 |
| 9990 | 4996 | 2 | 2018-01-19 14:55:05 |
| 9991 | 5024 | 2 | 2018-01-19 15:02:16 |
| 9992 | 5004 | 3 | 2018-01-19 15:03:27 |
| 9993 | 4995 | 2 | 2018-01-19 15:03:49 |
| 9994 | 5005 | 1 | 2018-01-19 15:06:32 |
| 9995 | 5006 | 3 | 2018-01-19 15:09:25 |
| 9996 | 5002 | 3 | 2018-01-19 15:09:39 |
| 9997 | 4998 | 3 | 2018-01-19 15:10:17 |
| 9998 | 5011 | 3 | 2018-01-19 15:10:22 |
| 9999 | 5007 | 3 | 2018-01-19 15:10:56 |
| 10000 | 5017 | 3 | 2018-01-19 15:12:48 |
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;