Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,901–13,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13901 | 7158 | 3 | 2018-11-27 15:33:54 |
| 13902 | 7147 | 2 | 2018-11-28 09:12:31 |
| 13903 | 7148 | 2 | 2018-11-28 09:14:26 |
| 13904 | 7149 | 2 | 2018-11-28 09:19:23 |
| 13905 | 7145 | 2 | 2018-11-28 09:25:58 |
| 13906 | 7146 | 2 | 2018-11-28 09:26:43 |
| 13907 | 7147 | 1 | 2018-11-28 09:55:54 |
| 13908 | 7145 | 1 | 2018-11-28 10:08:26 |
| 13909 | 7149 | 1 | 2018-11-28 10:37:35 |
| 13910 | 7148 | 1 | 2018-11-28 10:40:47 |
| 13911 | 7146 | 1 | 2018-11-28 10:57:25 |
| 13912 | 7203 | 2 | 2018-11-28 11:08:22 |
| 13913 | 7203 | 3 | 2018-11-28 12:23:04 |
| 13914 | 7203 | 1 | 2018-11-28 13:46:21 |
| 13915 | 7168 | 2 | 2018-11-28 14:11:45 |
| 13916 | 7167 | 2 | 2018-11-28 14:17:18 |
| 13917 | 7167 | 3 | 2018-11-28 15:00:49 |
| 13918 | 7168 | 3 | 2018-11-28 15:13:24 |
| 13919 | 7167 | 1 | 2018-11-28 15:29:37 |
| 13920 | 7168 | 1 | 2018-11-28 16:05:54 |
| 13921 | 7200 | 3 | 2018-11-29 10:17:34 |
| 13922 | 7199 | 3 | 2018-11-29 10:29:15 |
| 13923 | 7201 | 3 | 2018-11-29 10:30:02 |
| 13924 | 7199 | 2 | 2018-11-29 10:59:52 |
| 13925 | 7201 | 1 | 2018-11-29 11:01:00 |
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;