Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,826–17,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17826 | 9137 | 1 | 2019-10-13 15:06:34 |
| 17827 | 9136 | 2 | 2019-10-13 15:08:34 |
| 17828 | 9135 | 2 | 2019-10-13 15:09:36 |
| 17829 | 9136 | 3 | 2019-10-13 16:10:25 |
| 17830 | 9135 | 3 | 2019-10-13 16:24:46 |
| 17831 | 9135 | 1 | 2019-10-13 16:52:13 |
| 17832 | 9136 | 1 | 2019-10-13 17:08:16 |
| 17833 | 9114 | 2 | 2019-10-14 10:53:22 |
| 17834 | 9113 | 3 | 2019-10-14 10:56:24 |
| 17835 | 9171 | 2 | 2019-10-14 11:40:36 |
| 17836 | 9171 | 3 | 2019-10-14 12:33:12 |
| 17837 | 9145 | 2 | 2019-10-14 13:49:19 |
| 17838 | 9146 | 2 | 2019-10-14 13:50:17 |
| 17839 | 9171 | 1 | 2019-10-14 13:58:43 |
| 17840 | 9145 | 1 | 2019-10-14 14:25:50 |
| 17841 | 9174 | 2 | 2019-10-14 14:26:28 |
| 17842 | 9146 | 1 | 2019-10-14 14:52:35 |
| 17843 | 9088 | 2 | 2019-10-15 11:34:37 |
| 17844 | 9176 | 1 | 2019-10-15 12:19:30 |
| 17845 | 9172 | 3 | 2019-10-15 12:27:00 |
| 17846 | 9176 | 3 | 2019-10-15 12:48:19 |
| 17847 | 9172 | 1 | 2019-10-15 13:48:01 |
| 17848 | 8601 | 2 | 2019-10-15 13:53:45 |
| 17849 | 8627 | 2 | 2019-10-15 13:54:21 |
| 17850 | 8612 | 2 | 2019-10-15 13:54:35 |
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;