Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 801–825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 801 | 546 | 2 | 2015-05-21 15:50:18 |
| 802 | 601 | 3 | 2015-05-21 15:51:06 |
| 803 | 602 | 2 | 2015-05-22 10:14:08 |
| 804 | 321 | 2 | 2015-05-22 10:45:01 |
| 805 | 320 | 2 | 2015-05-22 10:57:43 |
| 806 | 602 | 3 | 2015-05-22 11:07:46 |
| 807 | 321 | 1 | 2015-05-22 11:24:26 |
| 808 | 604 | 2 | 2015-05-22 11:39:08 |
| 809 | 603 | 2 | 2015-05-22 11:47:24 |
| 810 | 320 | 1 | 2015-05-22 12:03:05 |
| 811 | 604 | 1 | 2015-05-22 12:27:08 |
| 812 | 603 | 1 | 2015-05-22 13:20:58 |
| 813 | 604 | 3 | 2015-05-22 14:01:33 |
| 814 | 445 | 1 | 2015-05-22 14:13:18 |
| 815 | 446 | 2 | 2015-05-22 14:13:47 |
| 816 | 444 | 2 | 2015-05-22 14:15:51 |
| 817 | 603 | 3 | 2015-05-22 14:55:50 |
| 818 | 444 | 1 | 2015-05-22 14:57:02 |
| 819 | 445 | 3 | 2015-05-22 15:22:00 |
| 820 | 446 | 1 | 2015-05-22 15:44:09 |
| 821 | 605 | 2 | 2015-05-22 15:52:26 |
| 822 | 605 | 3 | 2015-05-22 17:09:42 |
| 823 | 606 | 1 | 2015-05-23 10:59:24 |
| 824 | 606 | 2 | 2015-05-23 12:33:10 |
| 825 | 606 | 3 | 2015-05-23 13:45:02 |
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;