Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,751–15,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15751 | 7684 | 1 | 2019-04-19 13:35:34 |
| 15752 | 7688 | 1 | 2019-04-19 13:35:39 |
| 15753 | 7707 | 1 | 2019-04-19 13:35:43 |
| 15754 | 7690 | 1 | 2019-04-19 13:36:11 |
| 15755 | 7695 | 1 | 2019-04-19 13:38:18 |
| 15756 | 7702 | 1 | 2019-04-19 13:39:00 |
| 15757 | 7703 | 1 | 2019-04-19 13:39:13 |
| 15758 | 8100 | 2 | 2019-04-20 11:59:03 |
| 15759 | 8099 | 2 | 2019-04-20 12:05:51 |
| 15760 | 8099 | 3 | 2019-04-20 13:06:26 |
| 15761 | 8100 | 3 | 2019-04-20 13:13:35 |
| 15762 | 8056 | 2 | 2019-04-21 13:15:09 |
| 15763 | 8104 | 3 | 2019-04-21 16:23:51 |
| 15764 | 8108 | 2 | 2019-04-22 10:12:52 |
| 15765 | 8107 | 2 | 2019-04-22 10:13:04 |
| 15766 | 8108 | 3 | 2019-04-22 11:06:03 |
| 15767 | 8107 | 3 | 2019-04-22 11:18:50 |
| 15768 | 8120 | 2 | 2019-04-23 09:17:13 |
| 15769 | 8121 | 2 | 2019-04-23 09:18:57 |
| 15770 | 8119 | 2 | 2019-04-23 09:20:53 |
| 15771 | 8120 | 3 | 2019-04-23 10:12:04 |
| 15772 | 8121 | 3 | 2019-04-23 10:41:05 |
| 15773 | 8117 | 3 | 2019-04-23 11:53:23 |
| 15774 | 8118 | 3 | 2019-04-23 11:53:34 |
| 15775 | 8117 | 2 | 2019-04-23 12:40:03 |
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;