Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,076–12,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12076 | 6204 | 1 | 2018-07-22 15:45:33 |
| 12077 | 6205 | 3 | 2018-07-22 15:56:19 |
| 12078 | 6203 | 3 | 2018-07-22 16:05:37 |
| 12079 | 6204 | 3 | 2018-07-22 17:01:26 |
| 12080 | 6282 | 2 | 2018-07-25 10:46:01 |
| 12081 | 6283 | 2 | 2018-07-25 10:49:59 |
| 12082 | 6214 | 2 | 2018-07-25 10:56:26 |
| 12083 | 6282 | 3 | 2018-07-25 11:23:08 |
| 12084 | 6283 | 3 | 2018-07-25 11:42:21 |
| 12085 | 6284 | 2 | 2018-07-25 12:10:17 |
| 12086 | 6285 | 2 | 2018-07-25 12:12:01 |
| 12087 | 6214 | 3 | 2018-07-25 12:22:48 |
| 12088 | 6214 | 2 | 2018-07-25 13:44:04 |
| 12089 | 6214 | 1 | 2018-07-25 15:06:26 |
| 12090 | 6214 | 3 | 2018-07-25 15:56:25 |
| 12091 | 6281 | 2 | 2018-07-26 09:22:38 |
| 12092 | 6280 | 2 | 2018-07-26 09:28:14 |
| 12093 | 6281 | 3 | 2018-07-26 09:51:42 |
| 12094 | 5959 | 1 | 2018-07-26 09:58:26 |
| 12095 | 6280 | 3 | 2018-07-26 10:58:29 |
| 12096 | 5959 | 2 | 2018-07-26 11:30:38 |
| 12097 | 6296 | 3 | 2018-07-27 10:20:34 |
| 12098 | 6297 | 2 | 2018-07-27 10:29:05 |
| 12099 | 6297 | 3 | 2018-07-27 11:49:53 |
| 12100 | 6296 | 1 | 2018-07-27 11:54:03 |
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;