Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,826–6,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6826 | 3361 | 2 | 2017-03-14 11:18:31 |
| 6827 | 3380 | 2 | 2017-03-14 11:20:04 |
| 6828 | 3352 | 2 | 2017-03-14 11:20:36 |
| 6829 | 3344 | 2 | 2017-03-14 11:20:47 |
| 6830 | 3375 | 2 | 2017-03-14 11:21:04 |
| 6831 | 3369 | 2 | 2017-03-14 11:21:33 |
| 6832 | 3356 | 2 | 2017-03-14 11:21:59 |
| 6833 | 3367 | 2 | 2017-03-14 11:22:18 |
| 6834 | 3360 | 2 | 2017-03-14 11:23:06 |
| 6835 | 3379 | 2 | 2017-03-14 11:23:35 |
| 6836 | 3373 | 2 | 2017-03-14 11:24:23 |
| 6837 | 3381 | 2 | 2017-03-14 11:24:47 |
| 6838 | 3618 | 1 | 2017-03-14 11:25:26 |
| 6839 | 3349 | 2 | 2017-03-14 11:26:00 |
| 6840 | 3354 | 2 | 2017-03-14 11:26:27 |
| 6841 | 3351 | 2 | 2017-03-14 11:27:52 |
| 6842 | 3370 | 2 | 2017-03-14 11:27:58 |
| 6843 | 3359 | 2 | 2017-03-14 11:28:17 |
| 6844 | 3374 | 2 | 2017-03-14 11:28:20 |
| 6845 | 3362 | 2 | 2017-03-14 11:28:47 |
| 6846 | 3342 | 2 | 2017-03-14 11:29:01 |
| 6847 | 3365 | 2 | 2017-03-14 11:29:07 |
| 6848 | 3376 | 2 | 2017-03-14 11:29:42 |
| 6849 | 3378 | 2 | 2017-03-14 11:29:51 |
| 6850 | 3366 | 2 | 2017-03-14 11:29: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;