Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,001–15,025 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15001 | 7759 | 3 | 2019-03-07 10:14:14 |
| 15002 | 7757 | 3 | 2019-03-07 10:14:15 |
| 15003 | 7758 | 3 | 2019-03-07 10:19:03 |
| 15004 | 7774 | 2 | 2019-03-07 10:50:30 |
| 15005 | 7760 | 3 | 2019-03-07 11:07:35 |
| 15006 | 7733 | 2 | 2019-03-08 09:14:59 |
| 15007 | 7734 | 2 | 2019-03-08 09:16:21 |
| 15008 | 7735 | 2 | 2019-03-08 09:20:12 |
| 15009 | 7732 | 2 | 2019-03-08 09:25:32 |
| 15010 | 7731 | 2 | 2019-03-08 09:26:20 |
| 15011 | 7783 | 1 | 2019-03-08 09:42:17 |
| 15012 | 7782 | 1 | 2019-03-08 09:46:01 |
| 15013 | 7781 | 3 | 2019-03-08 10:14:44 |
| 15014 | 7734 | 3 | 2019-03-08 10:16:13 |
| 15015 | 7780 | 1 | 2019-03-08 10:24:21 |
| 15016 | 7733 | 3 | 2019-03-08 10:41:55 |
| 15017 | 7732 | 3 | 2019-03-08 10:50:10 |
| 15018 | 7783 | 3 | 2019-03-08 10:51:33 |
| 15019 | 7734 | 1 | 2019-03-08 10:54:14 |
| 15020 | 7735 | 3 | 2019-03-08 10:55:16 |
| 15021 | 7731 | 3 | 2019-03-08 11:02:05 |
| 15022 | 7782 | 3 | 2019-03-08 11:09:17 |
| 15023 | 7780 | 3 | 2019-03-08 11:20:01 |
| 15024 | 7735 | 1 | 2019-03-08 11:26:45 |
| 15025 | 7733 | 1 | 2019-03-08 11:34:09 |
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;