Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,426–12,450 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12426 | 6471 | 1 | 2018-08-16 14:51:52 |
| 12427 | 6474 | 1 | 2018-08-16 14:55:40 |
| 12428 | 6472 | 2 | 2018-08-16 15:21:41 |
| 12429 | 6474 | 2 | 2018-08-16 15:21:51 |
| 12430 | 6471 | 2 | 2018-08-16 15:32:44 |
| 12431 | 6473 | 2 | 2018-08-16 15:33:22 |
| 12432 | 6401 | 2 | 2018-08-16 16:36:42 |
| 12433 | 6476 | 3 | 2018-08-17 09:56:36 |
| 12434 | 6477 | 2 | 2018-08-17 10:09:18 |
| 12435 | 6478 | 2 | 2018-08-17 10:11:44 |
| 12436 | 6477 | 1 | 2018-08-17 10:40:06 |
| 12437 | 6476 | 1 | 2018-08-17 11:16:03 |
| 12438 | 6478 | 1 | 2018-08-17 11:22:51 |
| 12439 | 6481 | 3 | 2018-08-17 11:32:59 |
| 12440 | 6480 | 3 | 2018-08-17 11:34:52 |
| 12441 | 6479 | 3 | 2018-08-17 11:35:01 |
| 12442 | 6482 | 3 | 2018-08-17 11:38:08 |
| 12443 | 6483 | 3 | 2018-08-17 11:41:22 |
| 12444 | 6459 | 2 | 2018-08-17 11:42:53 |
| 12445 | 6458 | 3 | 2018-08-17 11:45:47 |
| 12446 | 6457 | 2 | 2018-08-17 11:45:49 |
| 12447 | 6456 | 2 | 2018-08-17 11:47:02 |
| 12448 | 6455 | 2 | 2018-08-17 11:59:05 |
| 12449 | 6457 | 3 | 2018-08-17 12:19:05 |
| 12450 | 6481 | 1 | 2018-08-17 12:25:31 |
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;