Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 101–125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 101 | 160 | 3 | 2015-03-21 14:31:14 |
| 102 | 163 | 3 | 2015-03-22 10:45:44 |
| 103 | 164 | 2 | 2015-03-22 10:52:05 |
| 104 | 163 | 1 | 2015-03-22 11:49:30 |
| 105 | 164 | 3 | 2015-03-22 12:24:53 |
| 106 | 107 | 3 | 2015-03-23 09:39:24 |
| 107 | 107 | 1 | 2015-03-23 10:17:44 |
| 108 | 107 | 3 | 2015-03-23 10:56:44 |
| 109 | 165 | 3 | 2015-03-23 10:57:22 |
| 110 | 165 | 1 | 2015-03-23 12:19:31 |
| 111 | 166 | 3 | 2015-03-24 11:15:33 |
| 112 | 168 | 3 | 2015-03-24 11:18:30 |
| 113 | 167 | 3 | 2015-03-24 11:24:30 |
| 114 | 169 | 3 | 2015-03-24 11:25:15 |
| 115 | 168 | 1 | 2015-03-24 12:28:14 |
| 116 | 169 | 1 | 2015-03-24 12:32:07 |
| 117 | 167 | 1 | 2015-03-24 12:36:27 |
| 118 | 166 | 1 | 2015-03-24 12:50:10 |
| 119 | 111 | 2 | 2015-03-25 16:18:12 |
| 120 | 110 | 2 | 2015-03-25 16:20:25 |
| 121 | 204 | 2 | 2015-03-26 09:22:13 |
| 122 | 203 | 2 | 2015-03-26 09:35:10 |
| 123 | 204 | 3 | 2015-03-26 09:54:44 |
| 124 | 203 | 3 | 2015-03-26 10:34:10 |
| 125 | 205 | 2 | 2015-03-27 10:47: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;