Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 51–75 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 51 | 100 | 2 | 2015-03-12 12:29:59 |
| 52 | 84 | 1 | 2015-03-12 12:32:10 |
| 53 | 85 | 1 | 2015-03-12 12:38:23 |
| 54 | 83 | 1 | 2015-03-12 12:39:18 |
| 55 | 101 | 1 | 2015-03-12 13:36:42 |
| 56 | 100 | 1 | 2015-03-12 13:44:19 |
| 57 | 100 | 3 | 2015-03-12 14:17:47 |
| 58 | 101 | 3 | 2015-03-12 14:40:00 |
| 59 | 102 | 1 | 2015-03-13 10:53:25 |
| 60 | 102 | 3 | 2015-03-13 11:19:27 |
| 61 | 96 | 3 | 2015-03-13 11:53:50 |
| 62 | 94 | 3 | 2015-03-13 11:56:05 |
| 63 | 93 | 3 | 2015-03-13 12:00:40 |
| 64 | 93 | 2 | 2015-03-13 13:00:08 |
| 65 | 96 | 2 | 2015-03-13 13:18:20 |
| 66 | 103 | 3 | 2015-03-14 11:52:05 |
| 67 | 103 | 2 | 2015-03-14 12:40:00 |
| 68 | 75 | 2 | 2015-03-14 13:23:25 |
| 69 | 104 | 2 | 2015-03-14 13:41:05 |
| 70 | 105 | 2 | 2015-03-14 13:50:03 |
| 71 | 104 | 1 | 2015-03-14 14:08:28 |
| 72 | 105 | 1 | 2015-03-14 14:34:39 |
| 73 | 75 | 3 | 2015-03-14 14:49:46 |
| 74 | 75 | 2 | 2015-03-14 15:59:50 |
| 75 | 97 | 2 | 2015-03-15 09:29:32 |
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;