Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 876–900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 876 | 135 | 2 | 2015-05-28 10:25:50 |
| 877 | 156 | 2 | 2015-05-28 10:26:00 |
| 878 | 145 | 2 | 2015-05-28 10:26:53 |
| 879 | 142 | 2 | 2015-05-28 10:27:27 |
| 880 | 147 | 2 | 2015-05-28 10:27:36 |
| 881 | 141 | 2 | 2015-05-28 10:27:50 |
| 882 | 155 | 2 | 2015-05-28 10:29:44 |
| 883 | 149 | 2 | 2015-05-28 10:31:00 |
| 884 | 146 | 2 | 2015-05-28 10:32:22 |
| 885 | 151 | 2 | 2015-05-28 10:33:23 |
| 886 | 610 | 3 | 2015-05-28 10:39:37 |
| 887 | 503 | 2 | 2015-05-28 10:39:42 |
| 888 | 118 | 3 | 2015-05-28 10:51:40 |
| 889 | 502 | 1 | 2015-05-28 10:51:49 |
| 890 | 140 | 3 | 2015-05-28 10:55:43 |
| 891 | 119 | 3 | 2015-05-28 10:57:01 |
| 892 | 150 | 3 | 2015-05-28 10:59:40 |
| 893 | 134 | 3 | 2015-05-28 11:02:14 |
| 894 | 149 | 3 | 2015-05-28 11:02:21 |
| 895 | 114 | 3 | 2015-05-28 11:02:43 |
| 896 | 116 | 3 | 2015-05-28 11:07:04 |
| 897 | 139 | 3 | 2015-05-28 11:09:29 |
| 898 | 142 | 3 | 2015-05-28 11:10:50 |
| 899 | 115 | 3 | 2015-05-28 11:12:55 |
| 900 | 138 | 3 | 2015-05-28 11:13:20 |
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;