Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,101–9,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9101 | 4756 | 2 | 2017-10-11 11:17:54 |
| 9102 | 4755 | 2 | 2017-10-11 11:22:12 |
| 9103 | 4765 | 2 | 2017-10-11 11:34:38 |
| 9104 | 4753 | 1 | 2017-10-11 12:18:58 |
| 9105 | 4756 | 1 | 2017-10-11 12:20:37 |
| 9106 | 4754 | 2 | 2017-10-11 12:23:03 |
| 9107 | 4765 | 1 | 2017-10-11 12:23:51 |
| 9108 | 4755 | 1 | 2017-10-11 12:51:52 |
| 9109 | 4765 | 3 | 2017-10-11 13:21:15 |
| 9110 | 4766 | 2 | 2017-10-12 10:27:51 |
| 9111 | 4766 | 3 | 2017-10-12 11:13:09 |
| 9112 | 4769 | 3 | 2017-10-14 15:10:24 |
| 9113 | 4771 | 1 | 2017-10-15 13:05:24 |
| 9114 | 4770 | 3 | 2017-10-15 13:05:58 |
| 9115 | 4772 | 2 | 2017-10-15 13:15:00 |
| 9116 | 4772 | 3 | 2017-10-15 13:58:14 |
| 9117 | 4770 | 1 | 2017-10-15 14:07:14 |
| 9118 | 4771 | 2 | 2017-10-15 14:16:45 |
| 9119 | 4773 | 2 | 2017-10-15 14:20:46 |
| 9120 | 4773 | 3 | 2017-10-15 15:06:37 |
| 9121 | 4771 | 3 | 2017-10-15 15:18:15 |
| 9122 | 4773 | 1 | 2017-10-15 16:01:28 |
| 9123 | 4776 | 3 | 2017-10-17 16:30:37 |
| 9124 | 4778 | 3 | 2017-10-17 16:32:03 |
| 9125 | 4779 | 3 | 2017-10-17 16:36:20 |
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;