Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,526–6,550 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6526 | 3521 | 2 | 2017-02-11 15:14:25 |
| 6527 | 3524 | 2 | 2017-02-11 15:15:45 |
| 6528 | 3502 | 2 | 2017-02-12 09:25:08 |
| 6529 | 3501 | 2 | 2017-02-12 09:30:35 |
| 6530 | 3500 | 2 | 2017-02-12 09:37:32 |
| 6531 | 3531 | 1 | 2017-02-12 12:16:18 |
| 6532 | 3531 | 2 | 2017-02-12 13:23:14 |
| 6533 | 3492 | 2 | 2017-02-14 12:56:54 |
| 6534 | 3510 | 2 | 2017-02-14 14:43:53 |
| 6535 | 3509 | 2 | 2017-02-14 14:44:12 |
| 6536 | 3508 | 2 | 2017-02-14 14:46:08 |
| 6537 | 3508 | 3 | 2017-02-14 15:16:04 |
| 6538 | 3510 | 3 | 2017-02-14 15:40:35 |
| 6539 | 3509 | 3 | 2017-02-14 16:06:47 |
| 6540 | 3532 | 2 | 2017-02-15 17:11:03 |
| 6541 | 3494 | 1 | 2017-02-18 11:45:04 |
| 6542 | 3494 | 3 | 2017-02-18 12:46:17 |
| 6543 | 3529 | 1 | 2017-02-19 09:06:59 |
| 6544 | 3530 | 1 | 2017-02-19 09:15:44 |
| 6545 | 3529 | 2 | 2017-02-19 09:44:49 |
| 6546 | 3530 | 2 | 2017-02-19 10:13:12 |
| 6547 | 3530 | 3 | 2017-02-19 11:05:48 |
| 6548 | 3529 | 3 | 2017-02-19 11:20:01 |
| 6549 | 3530 | 2 | 2017-02-19 12:09:27 |
| 6550 | 3529 | 2 | 2017-02-19 12:16:50 |
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;