Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,301–17,325 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17301 | 8769 | 2 | 2019-08-15 13:29:46 |
| 17302 | 8756 | 2 | 2019-08-15 14:25:25 |
| 17303 | 8755 | 2 | 2019-08-15 14:28:40 |
| 17304 | 8754 | 2 | 2019-08-15 14:35:07 |
| 17305 | 8755 | 1 | 2019-08-15 14:59:51 |
| 17306 | 8754 | 1 | 2019-08-15 15:16:59 |
| 17307 | 8755 | 2 | 2019-08-15 15:38:52 |
| 17308 | 8756 | 3 | 2019-08-15 15:48:54 |
| 17309 | 8754 | 2 | 2019-08-15 15:53:18 |
| 17310 | 8756 | 1 | 2019-08-15 16:42:59 |
| 17311 | 8754 | 1 | 2019-08-15 16:52:15 |
| 17312 | 8755 | 1 | 2019-08-15 17:12:19 |
| 17313 | 8699 | 1 | 2019-08-16 11:35:08 |
| 17314 | 8701 | 2 | 2019-08-16 11:35:32 |
| 17315 | 8700 | 1 | 2019-08-16 11:36:21 |
| 17316 | 8698 | 1 | 2019-08-16 11:46:03 |
| 17317 | 8699 | 3 | 2019-08-16 12:13:12 |
| 17318 | 8698 | 3 | 2019-08-16 12:55:26 |
| 17319 | 8700 | 3 | 2019-08-16 12:55:36 |
| 17320 | 8699 | 1 | 2019-08-16 13:03:07 |
| 17321 | 8700 | 1 | 2019-08-16 14:02:40 |
| 17322 | 8699 | 2 | 2019-08-16 14:16:49 |
| 17323 | 8698 | 1 | 2019-08-16 14:20:32 |
| 17324 | 8689 | 2 | 2019-08-16 14:24:44 |
| 17325 | 8688 | 2 | 2019-08-16 14:24:52 |
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;