Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,026–10,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10026 | 5027 | 1 | 2018-01-19 15:54:57 |
| 10027 | 4998 | 1 | 2018-01-19 15:57:44 |
| 10028 | 4997 | 3 | 2018-01-19 15:58:30 |
| 10029 | 5031 | 3 | 2018-01-19 15:58:47 |
| 10030 | 5008 | 1 | 2018-01-19 15:59:02 |
| 10031 | 5019 | 1 | 2018-01-19 16:00:38 |
| 10032 | 5013 | 3 | 2018-01-19 16:01:55 |
| 10033 | 4994 | 1 | 2018-01-19 16:06:49 |
| 10034 | 5012 | 1 | 2018-01-19 16:06:54 |
| 10035 | 4996 | 1 | 2018-01-19 16:07:33 |
| 10036 | 5017 | 1 | 2018-01-19 16:08:34 |
| 10037 | 5018 | 3 | 2018-01-19 16:10:05 |
| 10038 | 5004 | 1 | 2018-01-19 16:11:07 |
| 10039 | 5025 | 1 | 2018-01-19 16:12:57 |
| 10040 | 5009 | 1 | 2018-01-19 16:13:07 |
| 10041 | 5023 | 1 | 2018-01-19 16:16:56 |
| 10042 | 5029 | 1 | 2018-01-19 16:19:26 |
| 10043 | 5011 | 1 | 2018-01-19 16:24:13 |
| 10044 | 5030 | 1 | 2018-01-19 16:24:46 |
| 10045 | 5000 | 1 | 2018-01-19 16:30:54 |
| 10046 | 5022 | 1 | 2018-01-19 16:31:40 |
| 10047 | 4995 | 1 | 2018-01-19 16:31:42 |
| 10048 | 5002 | 1 | 2018-01-19 16:33:09 |
| 10049 | 5024 | 3 | 2018-01-19 16:37:05 |
| 10050 | 5014 | 1 | 2018-01-19 16:39:31 |
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;