Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 701–725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 701 | 352 | 3 | 2015-05-12 12:23:57 |
| 702 | 349 | 3 | 2015-05-12 12:28:23 |
| 703 | 507 | 3 | 2015-05-12 13:03:14 |
| 704 | 351 | 2 | 2015-05-12 13:04:23 |
| 705 | 350 | 2 | 2015-05-12 13:19:45 |
| 706 | 352 | 2 | 2015-05-12 13:23:02 |
| 707 | 353 | 2 | 2015-05-12 13:29:54 |
| 708 | 349 | 2 | 2015-05-12 13:33:05 |
| 709 | 353 | 3 | 2015-05-12 14:14:02 |
| 710 | 351 | 3 | 2015-05-12 14:20:48 |
| 711 | 350 | 3 | 2015-05-12 14:38:47 |
| 712 | 349 | 3 | 2015-05-12 14:46:32 |
| 713 | 352 | 3 | 2015-05-12 14:48:33 |
| 714 | 330 | 2 | 2015-05-13 09:30:25 |
| 715 | 328 | 2 | 2015-05-13 09:30:36 |
| 716 | 329 | 2 | 2015-05-13 09:35:36 |
| 717 | 508 | 2 | 2015-05-13 12:31:08 |
| 718 | 509 | 2 | 2015-05-13 12:38:15 |
| 719 | 510 | 1 | 2015-05-13 13:17:55 |
| 720 | 508 | 3 | 2015-05-13 13:27:21 |
| 721 | 509 | 1 | 2015-05-13 13:31:34 |
| 722 | 512 | 3 | 2015-05-13 15:00:18 |
| 723 | 513 | 3 | 2015-05-13 15:00:40 |
| 724 | 511 | 3 | 2015-05-13 15:02:36 |
| 725 | 511 | 2 | 2015-05-13 15:43:06 |
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;