Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,576–12,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12576 | 5929 | 3 | 2018-08-27 10:22:46 |
| 12577 | 5910 | 3 | 2018-08-27 10:22:49 |
| 12578 | 5908 | 3 | 2018-08-27 10:22:58 |
| 12579 | 5896 | 3 | 2018-08-27 10:23:23 |
| 12580 | 5915 | 3 | 2018-08-27 10:23:57 |
| 12581 | 5925 | 3 | 2018-08-27 10:24:02 |
| 12582 | 5936 | 3 | 2018-08-27 10:24:30 |
| 12583 | 5913 | 3 | 2018-08-27 10:25:00 |
| 12584 | 5918 | 3 | 2018-08-27 10:25:05 |
| 12585 | 5923 | 3 | 2018-08-27 10:26:13 |
| 12586 | 5920 | 3 | 2018-08-27 10:26:18 |
| 12587 | 5911 | 3 | 2018-08-27 10:26:27 |
| 12588 | 5924 | 3 | 2018-08-27 10:28:05 |
| 12589 | 5912 | 3 | 2018-08-27 10:28:15 |
| 12590 | 5919 | 3 | 2018-08-27 10:28:38 |
| 12591 | 5932 | 3 | 2018-08-27 10:29:14 |
| 12592 | 5922 | 3 | 2018-08-27 10:29:17 |
| 12593 | 5906 | 3 | 2018-08-27 10:31:22 |
| 12594 | 5907 | 3 | 2018-08-27 10:31:54 |
| 12595 | 5899 | 3 | 2018-08-27 10:32:05 |
| 12596 | 5917 | 3 | 2018-08-27 10:32:30 |
| 12597 | 5897 | 3 | 2018-08-27 10:32:32 |
| 12598 | 5933 | 3 | 2018-08-27 10:32:36 |
| 12599 | 5931 | 3 | 2018-08-27 10:33:20 |
| 12600 | 5914 | 3 | 2018-08-27 10:33:29 |
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;