Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,351–15,375 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15351 | 7905 | 2 | 2019-03-27 13:53:17 |
| 15352 | 7906 | 3 | 2019-03-27 13:56:36 |
| 15353 | 7906 | 2 | 2019-03-27 14:53:06 |
| 15354 | 7904 | 2 | 2019-03-27 15:25:42 |
| 15355 | 7728 | 2 | 2019-03-28 10:40:55 |
| 15356 | 7728 | 1 | 2019-03-28 11:07:44 |
| 15357 | 7894 | 2 | 2019-03-29 14:32:34 |
| 15358 | 7913 | 1 | 2019-03-29 15:28:00 |
| 15359 | 7894 | 1 | 2019-03-29 15:31:17 |
| 15360 | 7913 | 3 | 2019-03-29 16:54:13 |
| 15361 | 7808 | 2 | 2019-03-30 09:35:59 |
| 15362 | 7807 | 2 | 2019-03-30 09:44:23 |
| 15363 | 7916 | 1 | 2019-03-30 09:56:15 |
| 15364 | 7917 | 1 | 2019-03-30 09:57:38 |
| 15365 | 7915 | 1 | 2019-03-30 09:59:32 |
| 15366 | 7914 | 1 | 2019-03-30 10:01:29 |
| 15367 | 7807 | 3 | 2019-03-30 11:05:57 |
| 15368 | 7808 | 3 | 2019-03-30 11:11:07 |
| 15369 | 7898 | 2 | 2019-03-30 13:02:21 |
| 15370 | 7897 | 2 | 2019-03-30 13:05:23 |
| 15371 | 7899 | 2 | 2019-03-30 13:11:30 |
| 15372 | 7895 | 3 | 2019-03-30 13:11:41 |
| 15373 | 7896 | 2 | 2019-03-30 13:11:47 |
| 15374 | 7899 | 1 | 2019-03-30 14:11:08 |
| 15375 | 7898 | 3 | 2019-03-30 14:13:18 |
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;