Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,751–8,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8751 | 4559 | 3 | 2017-09-07 17:20:44 |
| 8752 | 4562 | 2 | 2017-09-08 11:38:35 |
| 8753 | 4562 | 1 | 2017-09-08 12:20:22 |
| 8754 | 4393 | 1 | 2017-09-08 12:41:24 |
| 8755 | 4562 | 3 | 2017-09-08 13:06:05 |
| 8756 | 4562 | 1 | 2017-09-08 14:00:55 |
| 8757 | 4553 | 1 | 2017-09-09 10:24:45 |
| 8758 | 4553 | 2 | 2017-09-09 10:53:24 |
| 8759 | 4553 | 3 | 2017-09-09 12:14:22 |
| 8760 | 4531 | 1 | 2017-09-10 11:18:17 |
| 8761 | 4564 | 2 | 2017-09-10 11:32:11 |
| 8762 | 4563 | 2 | 2017-09-10 11:34:03 |
| 8763 | 4564 | 1 | 2017-09-10 12:31:51 |
| 8764 | 4531 | 3 | 2017-09-10 12:37:06 |
| 8765 | 4420 | 2 | 2017-09-10 12:47:14 |
| 8766 | 4563 | 1 | 2017-09-10 12:54:53 |
| 8767 | 4419 | 2 | 2017-09-10 13:00:14 |
| 8768 | 4420 | 3 | 2017-09-10 13:24:41 |
| 8769 | 4419 | 3 | 2017-09-10 14:02:48 |
| 8770 | 4539 | 3 | 2017-09-11 10:57:39 |
| 8771 | 4567 | 2 | 2017-09-11 11:00:59 |
| 8772 | 4568 | 2 | 2017-09-11 11:03:37 |
| 8773 | 4569 | 2 | 2017-09-11 11:04:52 |
| 8774 | 4537 | 3 | 2017-09-11 11:05:10 |
| 8775 | 4538 | 3 | 2017-09-11 11:05:25 |
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;