Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,201–13,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13201 | 6766 | 3 | 2018-09-26 12:43:36 |
| 13202 | 6751 | 1 | 2018-09-26 13:01:50 |
| 13203 | 6739 | 2 | 2018-09-26 13:01:58 |
| 13204 | 6770 | 1 | 2018-09-26 13:11:39 |
| 13205 | 6749 | 1 | 2018-09-26 13:22:46 |
| 13206 | 6770 | 3 | 2018-09-26 14:14:12 |
| 13207 | 6624 | 1 | 2018-09-27 10:59:48 |
| 13208 | 6622 | 1 | 2018-09-27 11:06:23 |
| 13209 | 6623 | 1 | 2018-09-27 11:09:08 |
| 13210 | 6621 | 1 | 2018-09-27 11:10:31 |
| 13211 | 6517 | 2 | 2018-09-28 14:17:20 |
| 13212 | 6775 | 3 | 2018-09-28 14:37:12 |
| 13213 | 6774 | 1 | 2018-09-28 14:42:03 |
| 13214 | 6517 | 3 | 2018-09-28 14:57:57 |
| 13215 | 6775 | 1 | 2018-09-28 15:23:59 |
| 13216 | 6774 | 2 | 2018-09-28 15:24:11 |
| 13217 | 6517 | 1 | 2018-09-28 16:13:44 |
| 13218 | 6774 | 3 | 2018-09-28 16:46:26 |
| 13219 | 6778 | 3 | 2018-09-29 11:39:41 |
| 13220 | 6777 | 3 | 2018-09-29 11:48:36 |
| 13221 | 6690 | 2 | 2018-09-29 12:22:12 |
| 13222 | 6691 | 2 | 2018-09-29 12:24:19 |
| 13223 | 6691 | 1 | 2018-09-29 13:46:19 |
| 13224 | 6783 | 1 | 2018-09-30 11:00:04 |
| 13225 | 6783 | 2 | 2018-09-30 12:00:28 |
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;