Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,201–15,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15201 | 7482 | 2 | 2019-03-15 14:55:56 |
| 15202 | 7520 | 2 | 2019-03-15 14:57:59 |
| 15203 | 7478 | 2 | 2019-03-15 14:58:08 |
| 15204 | 7509 | 3 | 2019-03-15 14:58:23 |
| 15205 | 7487 | 3 | 2019-03-15 14:59:38 |
| 15206 | 7501 | 3 | 2019-03-15 15:01:37 |
| 15207 | 7483 | 3 | 2019-03-15 15:05:28 |
| 15208 | 7512 | 2 | 2019-03-15 15:05:35 |
| 15209 | 7496 | 3 | 2019-03-15 15:08:37 |
| 15210 | 7515 | 3 | 2019-03-15 15:09:34 |
| 15211 | 7481 | 3 | 2019-03-15 15:11:54 |
| 15212 | 7506 | 3 | 2019-03-15 15:14:45 |
| 15213 | 7493 | 3 | 2019-03-15 15:17:20 |
| 15214 | 7508 | 3 | 2019-03-15 15:17:22 |
| 15215 | 7514 | 3 | 2019-03-15 15:19:30 |
| 15216 | 7503 | 3 | 2019-03-15 15:25:00 |
| 15217 | 7517 | 3 | 2019-03-15 15:27:55 |
| 15218 | 7511 | 3 | 2019-03-15 15:28:06 |
| 15219 | 7510 | 3 | 2019-03-15 15:30:14 |
| 15220 | 7522 | 3 | 2019-03-15 15:32:16 |
| 15221 | 7492 | 3 | 2019-03-15 15:34:50 |
| 15222 | 7525 | 3 | 2019-03-15 15:38:27 |
| 15223 | 7480 | 3 | 2019-03-15 15:38:30 |
| 15224 | 7507 | 3 | 2019-03-15 15:41:57 |
| 15225 | 7512 | 3 | 2019-03-15 15:44:31 |
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;