Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,151–15,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15151 | 7506 | 2 | 2019-03-15 13:56:33 |
| 15152 | 7504 | 2 | 2019-03-15 14:01:47 |
| 15153 | 7500 | 2 | 2019-03-15 14:01:59 |
| 15154 | 7491 | 2 | 2019-03-15 14:08:05 |
| 15155 | 7502 | 2 | 2019-03-15 14:09:25 |
| 15156 | 7509 | 2 | 2019-03-15 14:11:13 |
| 15157 | 7494 | 2 | 2019-03-15 14:12:14 |
| 15158 | 7495 | 2 | 2019-03-15 14:14:18 |
| 15159 | 7488 | 2 | 2019-03-15 14:14:38 |
| 15160 | 7496 | 2 | 2019-03-15 14:17:36 |
| 15161 | 7499 | 2 | 2019-03-15 14:17:48 |
| 15162 | 7514 | 2 | 2019-03-15 14:21:45 |
| 15163 | 7524 | 2 | 2019-03-15 14:24:09 |
| 15164 | 7501 | 2 | 2019-03-15 14:26:30 |
| 15165 | 7480 | 2 | 2019-03-15 14:26:51 |
| 15166 | 7492 | 2 | 2019-03-15 14:27:49 |
| 15167 | 7517 | 2 | 2019-03-15 14:28:59 |
| 15168 | 7507 | 2 | 2019-03-15 14:29:28 |
| 15169 | 7521 | 2 | 2019-03-15 14:33:39 |
| 15170 | 7505 | 3 | 2019-03-15 14:34:37 |
| 15171 | 7484 | 2 | 2019-03-15 14:35:01 |
| 15172 | 7477 | 2 | 2019-03-15 14:35:41 |
| 15173 | 7515 | 2 | 2019-03-15 14:38:58 |
| 15174 | 7513 | 2 | 2019-03-15 14:39:26 |
| 15175 | 7481 | 2 | 2019-03-15 14:39:35 |
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;