Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,126–17,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17126 | 8661 | 3 | 2019-08-03 10:46:51 |
| 17127 | 8660 | 3 | 2019-08-03 10:57:20 |
| 17128 | 8662 | 3 | 2019-08-03 11:26:56 |
| 17129 | 8659 | 3 | 2019-08-03 11:45:13 |
| 17130 | 8673 | 2 | 2019-08-04 09:55:54 |
| 17131 | 8673 | 3 | 2019-08-04 10:58:38 |
| 17132 | 8704 | 3 | 2019-08-04 11:31:42 |
| 17133 | 8704 | 1 | 2019-08-04 12:09:28 |
| 17134 | 8666 | 2 | 2019-08-04 15:14:34 |
| 17135 | 8668 | 2 | 2019-08-04 15:18:35 |
| 17136 | 8667 | 2 | 2019-08-04 15:25:16 |
| 17137 | 8665 | 2 | 2019-08-04 15:27:14 |
| 17138 | 8666 | 1 | 2019-08-04 16:10:52 |
| 17139 | 8668 | 1 | 2019-08-04 16:11:19 |
| 17140 | 8667 | 1 | 2019-08-04 16:31:32 |
| 17141 | 8665 | 1 | 2019-08-04 16:36:27 |
| 17142 | 8668 | 2 | 2019-08-04 17:05:49 |
| 17143 | 8667 | 2 | 2019-08-04 17:09:43 |
| 17144 | 8666 | 2 | 2019-08-04 17:19:00 |
| 17145 | 8665 | 2 | 2019-08-04 17:30:56 |
| 17146 | 8709 | 3 | 2019-08-05 10:53:40 |
| 17147 | 8598 | 2 | 2019-08-05 11:33:51 |
| 17148 | 8709 | 1 | 2019-08-05 12:06:33 |
| 17149 | 8598 | 3 | 2019-08-05 12:24:31 |
| 17150 | 8598 | 1 | 2019-08-05 13:03:01 |
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;