Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,576–14,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14576 | 7600 | 3 | 2019-02-07 14:46:20 |
| 14577 | 7600 | 1 | 2019-02-07 15:45:51 |
| 14578 | 7611 | 1 | 2019-02-09 14:39:03 |
| 14579 | 7612 | 1 | 2019-02-09 14:42:01 |
| 14580 | 7610 | 2 | 2019-02-09 14:51:28 |
| 14581 | 7610 | 3 | 2019-02-09 15:58:16 |
| 14582 | 7610 | 2 | 2019-02-09 17:16:39 |
| 14583 | 7605 | 1 | 2019-02-10 10:31:18 |
| 14584 | 7621 | 2 | 2019-02-10 15:28:28 |
| 14585 | 7617 | 2 | 2019-02-10 15:28:32 |
| 14586 | 7619 | 2 | 2019-02-10 15:32:12 |
| 14587 | 7618 | 2 | 2019-02-10 15:32:45 |
| 14588 | 7620 | 2 | 2019-02-10 15:33:07 |
| 14589 | 7621 | 3 | 2019-02-10 16:05:08 |
| 14590 | 7617 | 3 | 2019-02-10 16:12:57 |
| 14591 | 7618 | 3 | 2019-02-10 16:41:09 |
| 14592 | 7620 | 3 | 2019-02-10 16:48:25 |
| 14593 | 7619 | 3 | 2019-02-10 16:51:00 |
| 14594 | 7631 | 2 | 2019-02-11 10:23:05 |
| 14595 | 7630 | 2 | 2019-02-11 10:27:02 |
| 14596 | 7631 | 1 | 2019-02-11 10:52:55 |
| 14597 | 7630 | 1 | 2019-02-11 11:41:17 |
| 14598 | 7388 | 3 | 2019-02-11 16:56:13 |
| 14599 | 7388 | 2 | 2019-02-11 17:31:12 |
| 14600 | 7624 | 3 | 2019-02-12 10:54:02 |
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;