Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,801–7,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7801 | 4040 | 1 | 2017-06-11 17:21:32 |
| 7802 | 4038 | 1 | 2017-06-11 17:24:55 |
| 7803 | 4041 | 2 | 2017-06-12 12:32:00 |
| 7804 | 4023 | 1 | 2017-06-12 12:43:51 |
| 7805 | 4024 | 1 | 2017-06-12 12:56:55 |
| 7806 | 4023 | 3 | 2017-06-12 13:26:00 |
| 7807 | 4041 | 1 | 2017-06-12 13:38:47 |
| 7808 | 4023 | 2 | 2017-06-12 13:58:32 |
| 7809 | 4024 | 3 | 2017-06-12 14:01:22 |
| 7810 | 4041 | 2 | 2017-06-12 14:23:45 |
| 7811 | 4024 | 2 | 2017-06-12 15:07:48 |
| 7812 | 3969 | 2 | 2017-06-12 15:48:01 |
| 7813 | 3970 | 2 | 2017-06-12 15:48:02 |
| 7814 | 3971 | 2 | 2017-06-12 15:51:18 |
| 7815 | 3969 | 3 | 2017-06-12 16:18:03 |
| 7816 | 3971 | 3 | 2017-06-12 16:45:30 |
| 7817 | 3970 | 3 | 2017-06-12 17:14:55 |
| 7818 | 4043 | 1 | 2017-06-13 15:58:52 |
| 7819 | 4042 | 1 | 2017-06-13 16:13:05 |
| 7820 | 3978 | 2 | 2017-06-14 10:43:51 |
| 7821 | 3979 | 2 | 2017-06-14 10:54:48 |
| 7822 | 3978 | 1 | 2017-06-14 11:22:31 |
| 7823 | 3961 | 2 | 2017-06-14 11:34:27 |
| 7824 | 3960 | 2 | 2017-06-14 11:41:43 |
| 7825 | 3961 | 1 | 2017-06-14 12:00:38 |
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;