Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,501–12,525 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12501 | 6462 | 2 | 2018-08-19 15:50:29 |
| 12502 | 6462 | 1 | 2018-08-19 16:24:30 |
| 12503 | 6336 | 3 | 2018-08-19 16:35:49 |
| 12504 | 6463 | 1 | 2018-08-19 16:58:40 |
| 12505 | 6407 | 3 | 2018-08-20 10:47:02 |
| 12506 | 6504 | 1 | 2018-08-20 13:01:12 |
| 12507 | 6503 | 1 | 2018-08-20 13:15:23 |
| 12508 | 6503 | 3 | 2018-08-20 14:06:22 |
| 12509 | 6504 | 3 | 2018-08-20 14:34:33 |
| 12510 | 6506 | 2 | 2018-08-21 09:42:19 |
| 12511 | 6299 | 1 | 2018-08-21 09:54:17 |
| 12512 | 6505 | 2 | 2018-08-21 09:54:50 |
| 12513 | 6299 | 3 | 2018-08-21 10:53:55 |
| 12514 | 6466 | 2 | 2018-08-22 09:58:06 |
| 12515 | 6510 | 3 | 2018-08-22 10:03:48 |
| 12516 | 6511 | 3 | 2018-08-22 10:06:33 |
| 12517 | 6512 | 3 | 2018-08-22 10:10:06 |
| 12518 | 6509 | 3 | 2018-08-22 10:11:45 |
| 12519 | 6510 | 2 | 2018-08-22 11:05:04 |
| 12520 | 6511 | 2 | 2018-08-22 11:19:42 |
| 12521 | 6512 | 2 | 2018-08-22 11:21:44 |
| 12522 | 6509 | 2 | 2018-08-22 11:23:35 |
| 12523 | 6515 | 1 | 2018-08-23 09:47:32 |
| 12524 | 6516 | 2 | 2018-08-23 09:48:44 |
| 12525 | 6514 | 1 | 2018-08-23 09:51:59 |
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;