Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,201–17,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17201 | 8723 | 3 | 2019-08-07 12:29:55 |
| 17202 | 8725 | 3 | 2019-08-07 12:34:23 |
| 17203 | 8642 | 2 | 2019-08-07 14:48:27 |
| 17204 | 8643 | 2 | 2019-08-07 15:00:19 |
| 17205 | 8644 | 2 | 2019-08-07 15:00:48 |
| 17206 | 8641 | 2 | 2019-08-07 15:01:14 |
| 17207 | 8642 | 1 | 2019-08-07 16:02:37 |
| 17208 | 8644 | 1 | 2019-08-07 16:05:20 |
| 17209 | 8643 | 1 | 2019-08-07 16:21:27 |
| 17210 | 8641 | 1 | 2019-08-07 16:27:44 |
| 17211 | 8642 | 3 | 2019-08-07 16:51:39 |
| 17212 | 8644 | 3 | 2019-08-07 17:06:18 |
| 17213 | 8641 | 3 | 2019-08-07 17:17:57 |
| 17214 | 8643 | 3 | 2019-08-07 17:33:20 |
| 17215 | 8733 | 2 | 2019-08-09 09:15:49 |
| 17216 | 8734 | 2 | 2019-08-09 09:16:21 |
| 17217 | 8735 | 2 | 2019-08-09 09:26:21 |
| 17218 | 8734 | 1 | 2019-08-09 10:11:52 |
| 17219 | 8736 | 2 | 2019-08-09 10:12:19 |
| 17220 | 8738 | 1 | 2019-08-09 10:56:22 |
| 17221 | 8737 | 1 | 2019-08-09 11:08:34 |
| 17222 | 8710 | 1 | 2019-08-09 11:30:48 |
| 17223 | 8734 | 3 | 2019-08-09 11:34:22 |
| 17224 | 8736 | 3 | 2019-08-09 11:40:32 |
| 17225 | 8737 | 2 | 2019-08-09 12:06:47 |
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;