Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,626–1,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1626 | 802 | 2 | 2015-08-06 16:58:00 |
| 1627 | 803 | 2 | 2015-08-06 17:02:59 |
| 1628 | 801 | 3 | 2015-08-06 17:21:39 |
| 1629 | 802 | 3 | 2015-08-06 17:35:56 |
| 1630 | 926 | 2 | 2015-08-07 11:13:43 |
| 1631 | 926 | 1 | 2015-08-07 11:41:02 |
| 1632 | 926 | 2 | 2015-08-07 12:23:49 |
| 1633 | 915 | 1 | 2015-08-07 12:36:30 |
| 1634 | 916 | 1 | 2015-08-07 12:37:15 |
| 1635 | 917 | 1 | 2015-08-07 12:37:35 |
| 1636 | 932 | 2 | 2015-08-09 14:43:51 |
| 1637 | 933 | 2 | 2015-08-09 14:45:08 |
| 1638 | 938 | 2 | 2015-08-10 09:46:46 |
| 1639 | 939 | 2 | 2015-08-10 09:56:30 |
| 1640 | 940 | 2 | 2015-08-10 13:01:33 |
| 1641 | 940 | 3 | 2015-08-10 14:27:39 |
| 1642 | 940 | 2 | 2015-08-10 15:09:02 |
| 1643 | 890 | 2 | 2015-08-10 15:48:33 |
| 1644 | 889 | 2 | 2015-08-10 15:56:04 |
| 1645 | 940 | 3 | 2015-08-10 16:24:04 |
| 1646 | 940 | 1 | 2015-08-10 17:15:42 |
| 1647 | 927 | 2 | 2015-08-11 09:43:51 |
| 1648 | 927 | 1 | 2015-08-11 10:53:52 |
| 1649 | 944 | 1 | 2015-08-11 14:10:13 |
| 1650 | 937 | 2 | 2015-08-11 14:25:14 |
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;