Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,826–5,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5826 | 2941 | 2 | 2016-10-28 15:24:54 |
| 5827 | 2941 | 1 | 2016-10-28 16:10:26 |
| 5828 | 2941 | 2 | 2016-10-28 17:01:12 |
| 5829 | 2921 | 2 | 2016-10-29 09:49:50 |
| 5830 | 2920 | 2 | 2016-10-29 09:53:38 |
| 5831 | 2920 | 3 | 2016-10-29 10:31:21 |
| 5832 | 2921 | 3 | 2016-10-29 11:05:45 |
| 5833 | 2920 | 1 | 2016-10-29 11:08:18 |
| 5834 | 2859 | 2 | 2016-10-29 11:30:57 |
| 5835 | 2861 | 2 | 2016-10-29 11:33:09 |
| 5836 | 2858 | 2 | 2016-10-29 11:35:28 |
| 5837 | 2860 | 2 | 2016-10-29 11:37:57 |
| 5838 | 2921 | 1 | 2016-10-29 12:21:07 |
| 5839 | 2861 | 3 | 2016-10-29 12:41:37 |
| 5840 | 2861 | 2 | 2016-10-29 13:11:13 |
| 5841 | 2915 | 2 | 2016-10-30 12:15:12 |
| 5842 | 2916 | 2 | 2016-10-30 12:26:23 |
| 5843 | 2915 | 3 | 2016-10-30 12:54:30 |
| 5844 | 2916 | 3 | 2016-10-30 13:32:55 |
| 5845 | 2915 | 1 | 2016-10-30 13:40:43 |
| 5846 | 2916 | 1 | 2016-10-30 14:02:49 |
| 5847 | 2942 | 1 | 2016-10-30 15:44:31 |
| 5848 | 2943 | 2 | 2016-10-30 15:46:36 |
| 5849 | 2865 | 1 | 2016-10-30 16:17:49 |
| 5850 | 2942 | 3 | 2016-10-30 16:36: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;