Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,901–15,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15901 | 8175 | 3 | 2019-05-04 12:14:53 |
| 15902 | 8173 | 1 | 2019-05-04 12:25:10 |
| 15903 | 8174 | 1 | 2019-05-04 12:27:15 |
| 15904 | 8175 | 2 | 2019-05-04 12:53:14 |
| 15905 | 8176 | 1 | 2019-05-04 14:08:43 |
| 15906 | 8176 | 3 | 2019-05-04 15:23:37 |
| 15907 | 8089 | 2 | 2019-05-04 15:44:56 |
| 15908 | 8088 | 2 | 2019-05-04 15:45:54 |
| 15909 | 8089 | 1 | 2019-05-04 16:37:30 |
| 15910 | 8088 | 1 | 2019-05-04 17:10:57 |
| 15911 | 8089 | 3 | 2019-05-04 17:32:46 |
| 15912 | 8088 | 3 | 2019-05-04 17:43:01 |
| 15913 | 8143 | 2 | 2019-05-05 14:01:45 |
| 15914 | 8143 | 1 | 2019-05-05 14:52:12 |
| 15915 | 8166 | 1 | 2019-05-05 16:04:23 |
| 15916 | 8164 | 1 | 2019-05-05 16:08:39 |
| 15917 | 8165 | 1 | 2019-05-05 16:09:20 |
| 15918 | 8167 | 1 | 2019-05-05 16:18:23 |
| 15919 | 8166 | 3 | 2019-05-05 16:40:20 |
| 15920 | 8165 | 3 | 2019-05-05 17:09:36 |
| 15921 | 8164 | 3 | 2019-05-05 17:24:21 |
| 15922 | 8167 | 3 | 2019-05-05 17:34:31 |
| 15923 | 8165 | 1 | 2019-05-05 17:47:36 |
| 15924 | 8134 | 3 | 2019-05-06 12:57:25 |
| 15925 | 8135 | 3 | 2019-05-06 13:08:24 |
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;