Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,901–16,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16901 | 8559 | 2 | 2019-07-15 10:11:36 |
| 16902 | 8559 | 1 | 2019-07-15 11:44:22 |
| 16903 | 8387 | 3 | 2019-07-15 12:40:34 |
| 16904 | 8387 | 2 | 2019-07-15 13:30:30 |
| 16905 | 8387 | 3 | 2019-07-15 14:11:33 |
| 16906 | 8558 | 2 | 2019-07-16 09:52:53 |
| 16907 | 8558 | 3 | 2019-07-16 10:59:28 |
| 16908 | 8530 | 2 | 2019-07-16 11:26:13 |
| 16909 | 8531 | 2 | 2019-07-16 11:26:38 |
| 16910 | 8529 | 2 | 2019-07-16 11:27:54 |
| 16911 | 8399 | 2 | 2019-07-16 11:42:21 |
| 16912 | 8531 | 1 | 2019-07-16 11:53:18 |
| 16913 | 8529 | 1 | 2019-07-16 12:11:01 |
| 16914 | 8399 | 1 | 2019-07-16 12:40:35 |
| 16915 | 8530 | 3 | 2019-07-16 12:42:21 |
| 16916 | 8560 | 2 | 2019-07-18 12:06:42 |
| 16917 | 8566 | 2 | 2019-07-19 09:42:52 |
| 16918 | 8565 | 2 | 2019-07-19 09:56:08 |
| 16919 | 8573 | 1 | 2019-07-19 11:08:08 |
| 16920 | 8552 | 2 | 2019-07-19 12:49:04 |
| 16921 | 8553 | 2 | 2019-07-19 12:57:37 |
| 16922 | 8553 | 1 | 2019-07-19 13:32:09 |
| 16923 | 8572 | 1 | 2019-07-19 15:06:25 |
| 16924 | 8553 | 3 | 2019-07-19 15:07:16 |
| 16925 | 8571 | 1 | 2019-07-19 15:08:50 |
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;