Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 76–100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 76 | 97 | 3 | 2015-03-15 10:40:33 |
| 77 | 97 | 2 | 2015-03-15 11:59:31 |
| 78 | 2 | 3 | 2015-03-15 13:47:16 |
| 79 | 1 | 2 | 2015-03-15 13:55:31 |
| 80 | 1 | 3 | 2015-03-15 15:15:56 |
| 81 | 161 | 2 | 2015-03-21 10:55:09 |
| 82 | 157 | 2 | 2015-03-21 10:57:48 |
| 83 | 159 | 2 | 2015-03-21 10:58:39 |
| 84 | 160 | 2 | 2015-03-21 10:59:03 |
| 85 | 158 | 2 | 2015-03-21 11:09:02 |
| 86 | 157 | 3 | 2015-03-21 11:28:36 |
| 87 | 160 | 3 | 2015-03-21 11:56:15 |
| 88 | 162 | 2 | 2015-03-21 12:09:05 |
| 89 | 159 | 3 | 2015-03-21 12:13:21 |
| 90 | 161 | 3 | 2015-03-21 12:15:12 |
| 91 | 158 | 3 | 2015-03-21 12:30:05 |
| 92 | 157 | 1 | 2015-03-21 12:35:15 |
| 93 | 159 | 1 | 2015-03-21 13:03:54 |
| 94 | 160 | 1 | 2015-03-21 13:14:22 |
| 95 | 157 | 3 | 2015-03-21 13:33:04 |
| 96 | 161 | 1 | 2015-03-21 13:39:54 |
| 97 | 158 | 1 | 2015-03-21 13:53:43 |
| 98 | 158 | 3 | 2015-03-21 14:22:18 |
| 99 | 159 | 3 | 2015-03-21 14:23:02 |
| 100 | 161 | 3 | 2015-03-21 14:23:08 |
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;