Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,601–14,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14601 | 7625 | 3 | 2019-02-12 10:56:25 |
| 14602 | 7626 | 3 | 2019-02-12 10:57:00 |
| 14603 | 7627 | 2 | 2019-02-12 11:02:44 |
| 14604 | 7635 | 2 | 2019-02-12 11:12:00 |
| 14605 | 7634 | 3 | 2019-02-12 11:12:39 |
| 14606 | 7633 | 2 | 2019-02-12 11:18:50 |
| 14607 | 7627 | 3 | 2019-02-12 11:32:42 |
| 14608 | 7627 | 2 | 2019-02-12 12:28:48 |
| 14609 | 7634 | 1 | 2019-02-12 12:34:12 |
| 14610 | 7637 | 2 | 2019-02-12 13:47:29 |
| 14611 | 7636 | 2 | 2019-02-12 13:50:40 |
| 14612 | 7599 | 3 | 2019-02-12 14:47:11 |
| 14613 | 7639 | 2 | 2019-02-12 14:47:58 |
| 14614 | 7598 | 3 | 2019-02-12 14:51:09 |
| 14615 | 7638 | 2 | 2019-02-12 15:00:47 |
| 14616 | 7451 | 3 | 2019-02-12 15:02:14 |
| 14617 | 7639 | 3 | 2019-02-12 15:27:48 |
| 14618 | 7598 | 2 | 2019-02-12 15:32:21 |
| 14619 | 7638 | 3 | 2019-02-12 15:33:32 |
| 14620 | 7599 | 2 | 2019-02-12 15:45:24 |
| 14621 | 7639 | 2 | 2019-02-12 15:56:14 |
| 14622 | 7638 | 2 | 2019-02-12 16:22:12 |
| 14623 | 7639 | 3 | 2019-02-12 16:38:03 |
| 14624 | 7638 | 3 | 2019-02-12 17:09:09 |
| 14625 | 7644 | 1 | 2019-02-13 11:36:52 |
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;