Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,101–1,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1101 | 684 | 2 | 2015-06-16 15:35:53 |
| 1102 | 684 | 3 | 2015-06-16 16:29:32 |
| 1103 | 685 | 3 | 2015-06-16 16:31:18 |
| 1104 | 598 | 2 | 2015-06-16 17:06:37 |
| 1105 | 686 | 2 | 2015-06-17 13:53:32 |
| 1106 | 687 | 2 | 2015-06-17 13:56:55 |
| 1107 | 686 | 3 | 2015-06-17 14:25:48 |
| 1108 | 687 | 3 | 2015-06-17 14:47:45 |
| 1109 | 686 | 1 | 2015-06-17 15:25:48 |
| 1110 | 687 | 1 | 2015-06-17 15:47:48 |
| 1111 | 690 | 2 | 2015-06-18 13:13:04 |
| 1112 | 688 | 2 | 2015-06-18 13:24:42 |
| 1113 | 691 | 2 | 2015-06-18 13:26:51 |
| 1114 | 689 | 2 | 2015-06-18 13:27:46 |
| 1115 | 690 | 1 | 2015-06-18 14:10:37 |
| 1116 | 689 | 3 | 2015-06-18 14:37:45 |
| 1117 | 691 | 1 | 2015-06-18 14:38:52 |
| 1118 | 688 | 1 | 2015-06-18 14:42:26 |
| 1119 | 691 | 3 | 2015-06-18 15:19:47 |
| 1120 | 690 | 3 | 2015-06-18 15:25:50 |
| 1121 | 688 | 3 | 2015-06-18 15:43:26 |
| 1122 | 690 | 2 | 2015-06-18 15:51:21 |
| 1123 | 689 | 1 | 2015-06-18 15:58:45 |
| 1124 | 688 | 2 | 2015-06-18 16:43:37 |
| 1125 | 691 | 2 | 2015-06-18 16:53:28 |
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;