Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,026–12,050 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12026 | 6089 | 3 | 2018-07-19 12:01:30 |
| 12027 | 6267 | 2 | 2018-07-19 12:09:37 |
| 12028 | 6088 | 2 | 2018-07-19 13:26:40 |
| 12029 | 6270 | 3 | 2018-07-20 11:01:48 |
| 12030 | 6270 | 2 | 2018-07-20 11:57:23 |
| 12031 | 6272 | 2 | 2018-07-21 09:40:30 |
| 12032 | 6274 | 2 | 2018-07-21 09:49:36 |
| 12033 | 6271 | 2 | 2018-07-21 09:51:34 |
| 12034 | 6273 | 2 | 2018-07-21 09:58:45 |
| 12035 | 6276 | 3 | 2018-07-21 10:43:25 |
| 12036 | 6275 | 3 | 2018-07-21 10:46:58 |
| 12037 | 6274 | 3 | 2018-07-21 11:12:14 |
| 12038 | 6275 | 1 | 2018-07-21 11:19:43 |
| 12039 | 6276 | 1 | 2018-07-21 11:22:47 |
| 12040 | 6273 | 3 | 2018-07-21 11:31:33 |
| 12041 | 6176 | 1 | 2018-07-21 12:03:00 |
| 12042 | 6276 | 3 | 2018-07-21 12:20:02 |
| 12043 | 6273 | 1 | 2018-07-21 12:28:13 |
| 12044 | 6274 | 1 | 2018-07-21 12:32:28 |
| 12045 | 6176 | 3 | 2018-07-21 12:37:02 |
| 12046 | 6275 | 3 | 2018-07-21 12:47:53 |
| 12047 | 6277 | 3 | 2018-07-21 15:46:38 |
| 12048 | 6264 | 2 | 2018-07-21 15:53:48 |
| 12049 | 6263 | 2 | 2018-07-21 15:54:49 |
| 12050 | 6265 | 2 | 2018-07-21 15:56:01 |
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;