Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,701–11,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11701 | 6051 | 1 | 2018-07-08 12:28:08 |
| 11702 | 6191 | 3 | 2018-07-08 12:31:33 |
| 11703 | 6050 | 1 | 2018-07-08 12:36:13 |
| 11704 | 6190 | 3 | 2018-07-08 13:11:52 |
| 11705 | 6195 | 1 | 2018-07-09 14:11:35 |
| 11706 | 6194 | 1 | 2018-07-09 14:19:47 |
| 11707 | 6090 | 3 | 2018-07-09 16:08:31 |
| 11708 | 6092 | 3 | 2018-07-09 16:13:17 |
| 11709 | 6091 | 3 | 2018-07-09 16:15:16 |
| 11710 | 6100 | 1 | 2018-07-10 09:57:37 |
| 11711 | 6100 | 2 | 2018-07-10 10:39:55 |
| 11712 | 6196 | 2 | 2018-07-10 10:51:29 |
| 11713 | 6174 | 2 | 2018-07-10 11:19:44 |
| 11714 | 6175 | 2 | 2018-07-10 11:21:57 |
| 11715 | 6100 | 1 | 2018-07-10 11:26:15 |
| 11716 | 6196 | 3 | 2018-07-10 12:18:18 |
| 11717 | 6174 | 3 | 2018-07-10 12:23:07 |
| 11718 | 6197 | 3 | 2018-07-10 12:25:15 |
| 11719 | 6198 | 3 | 2018-07-10 12:25:28 |
| 11720 | 6175 | 3 | 2018-07-10 12:29:52 |
| 11721 | 6175 | 2 | 2018-07-10 13:07:12 |
| 11722 | 6174 | 2 | 2018-07-10 13:29:34 |
| 11723 | 6196 | 2 | 2018-07-10 13:33:31 |
| 11724 | 6174 | 3 | 2018-07-10 14:14:00 |
| 11725 | 6175 | 3 | 2018-07-10 14:16:27 |
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;