Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,051–1,075 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1051 | 665 | 2 | 2015-06-12 13:11:58 |
| 1052 | 666 | 2 | 2015-06-12 13:15:37 |
| 1053 | 663 | 2 | 2015-06-12 13:19:34 |
| 1054 | 663 | 1 | 2015-06-12 14:01:09 |
| 1055 | 665 | 1 | 2015-06-12 14:19:03 |
| 1056 | 664 | 1 | 2015-06-12 14:28:56 |
| 1057 | 663 | 2 | 2015-06-12 14:40:08 |
| 1058 | 666 | 1 | 2015-06-12 14:48:03 |
| 1059 | 664 | 2 | 2015-06-12 15:01:53 |
| 1060 | 665 | 2 | 2015-06-12 15:12:22 |
| 1061 | 664 | 1 | 2015-06-12 15:42:24 |
| 1062 | 663 | 1 | 2015-06-12 15:56:04 |
| 1063 | 665 | 1 | 2015-06-12 15:56:25 |
| 1064 | 666 | 2 | 2015-06-12 16:01:25 |
| 1065 | 626 | 2 | 2015-06-13 13:11:05 |
| 1066 | 628 | 2 | 2015-06-13 13:18:03 |
| 1067 | 629 | 2 | 2015-06-13 13:18:24 |
| 1068 | 627 | 2 | 2015-06-13 13:22:27 |
| 1069 | 673 | 3 | 2015-06-13 14:46:31 |
| 1070 | 672 | 2 | 2015-06-13 14:52:59 |
| 1071 | 674 | 2 | 2015-06-13 14:53:06 |
| 1072 | 675 | 2 | 2015-06-13 14:53:34 |
| 1073 | 674 | 3 | 2015-06-13 15:46:52 |
| 1074 | 675 | 3 | 2015-06-13 15:52:12 |
| 1075 | 672 | 3 | 2015-06-13 16:25:35 |
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;