Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,151–9,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9151 | 4804 | 3 | 2017-10-21 15:49:36 |
| 9152 | 4806 | 3 | 2017-10-21 16:10:17 |
| 9153 | 4794 | 2 | 2017-10-22 11:49:33 |
| 9154 | 4794 | 3 | 2017-10-22 12:29:54 |
| 9155 | 4794 | 2 | 2017-10-22 13:59:54 |
| 9156 | 4801 | 1 | 2017-10-23 11:37:34 |
| 9157 | 4802 | 1 | 2017-10-23 11:37:38 |
| 9158 | 4803 | 1 | 2017-10-23 11:48:42 |
| 9159 | 4802 | 2 | 2017-10-23 12:19:31 |
| 9160 | 4801 | 2 | 2017-10-23 13:05:50 |
| 9161 | 4803 | 2 | 2017-10-23 13:15:21 |
| 9162 | 4751 | 3 | 2017-10-23 13:23:48 |
| 9163 | 4809 | 2 | 2017-10-23 14:18:52 |
| 9164 | 4751 | 2 | 2017-10-23 14:27:10 |
| 9165 | 4751 | 1 | 2017-10-23 14:58:10 |
| 9166 | 4809 | 3 | 2017-10-23 15:54:18 |
| 9167 | 4809 | 2 | 2017-10-23 16:34:22 |
| 9168 | 4767 | 3 | 2017-10-25 10:10:24 |
| 9169 | 4768 | 3 | 2017-10-25 10:15:25 |
| 9170 | 4768 | 1 | 2017-10-25 11:03:38 |
| 9171 | 4767 | 1 | 2017-10-25 11:09:03 |
| 9172 | 4814 | 2 | 2017-10-26 10:22:42 |
| 9173 | 4106 | 2 | 2017-10-26 12:37:32 |
| 9174 | 4117 | 2 | 2017-10-26 12:37:39 |
| 9175 | 4113 | 2 | 2017-10-26 12:40:59 |
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;