Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,676–1,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1676 | 954 | 3 | 2015-08-12 17:12:11 |
| 1677 | 947 | 3 | 2015-08-12 17:20:35 |
| 1678 | 955 | 3 | 2015-08-13 13:40:00 |
| 1679 | 957 | 2 | 2015-08-13 13:44:09 |
| 1680 | 956 | 3 | 2015-08-13 13:53:46 |
| 1681 | 955 | 2 | 2015-08-13 14:51:18 |
| 1682 | 956 | 2 | 2015-08-13 14:54:29 |
| 1683 | 962 | 2 | 2015-08-13 14:55:23 |
| 1684 | 962 | 1 | 2015-08-13 16:17:00 |
| 1685 | 967 | 2 | 2015-08-14 15:34:23 |
| 1686 | 966 | 2 | 2015-08-14 15:41:17 |
| 1687 | 965 | 2 | 2015-08-14 15:42:10 |
| 1688 | 967 | 3 | 2015-08-14 16:15:16 |
| 1689 | 966 | 3 | 2015-08-14 16:17:17 |
| 1690 | 967 | 2 | 2015-08-14 16:42:05 |
| 1691 | 965 | 3 | 2015-08-14 17:02:31 |
| 1692 | 966 | 2 | 2015-08-14 17:18:48 |
| 1693 | 969 | 2 | 2015-08-15 11:05:00 |
| 1694 | 970 | 2 | 2015-08-15 11:07:22 |
| 1695 | 968 | 3 | 2015-08-15 11:13:01 |
| 1696 | 969 | 1 | 2015-08-15 11:51:50 |
| 1697 | 971 | 2 | 2015-08-15 12:12:01 |
| 1698 | 875 | 2 | 2015-08-15 12:27:24 |
| 1699 | 876 | 2 | 2015-08-15 12:27:35 |
| 1700 | 874 | 3 | 2015-08-15 12:30:22 |
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;