Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,876–10,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10876 | 5661 | 2 | 2018-04-27 12:26:37 |
| 10877 | 5657 | 1 | 2018-04-27 14:03:24 |
| 10878 | 5658 | 3 | 2018-04-27 14:09:16 |
| 10879 | 5663 | 2 | 2018-04-28 09:26:49 |
| 10880 | 5664 | 2 | 2018-04-28 10:38:56 |
| 10881 | 5667 | 2 | 2018-04-28 10:40:56 |
| 10882 | 5666 | 2 | 2018-04-28 10:42:35 |
| 10883 | 5665 | 2 | 2018-04-28 10:42:55 |
| 10884 | 5668 | 2 | 2018-04-28 10:48:11 |
| 10885 | 5663 | 1 | 2018-04-28 10:52:11 |
| 10886 | 5666 | 1 | 2018-04-28 11:17:30 |
| 10887 | 5665 | 1 | 2018-04-28 11:20:09 |
| 10888 | 5663 | 3 | 2018-04-28 11:26:45 |
| 10889 | 5667 | 1 | 2018-04-28 11:26:58 |
| 10890 | 5664 | 1 | 2018-04-28 12:11:54 |
| 10891 | 5668 | 3 | 2018-04-28 12:12:58 |
| 10892 | 5670 | 2 | 2018-04-28 12:47:48 |
| 10893 | 5668 | 2 | 2018-04-28 13:42:57 |
| 10894 | 5671 | 1 | 2018-04-29 11:41:47 |
| 10895 | 5672 | 1 | 2018-04-29 11:50:54 |
| 10896 | 5671 | 3 | 2018-04-29 12:12:33 |
| 10897 | 5672 | 3 | 2018-04-29 13:19:10 |
| 10898 | 5671 | 1 | 2018-04-29 13:35:31 |
| 10899 | 5672 | 1 | 2018-04-29 14:54:34 |
| 10900 | 5660 | 2 | 2018-04-30 11:18:25 |
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;