Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,076–9,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9076 | 4627 | 2 | 2017-10-10 09:58:19 |
| 9077 | 4621 | 2 | 2017-10-10 09:58:28 |
| 9078 | 4631 | 2 | 2017-10-10 09:59:07 |
| 9079 | 4619 | 2 | 2017-10-10 09:59:54 |
| 9080 | 4617 | 2 | 2017-10-10 10:00:33 |
| 9081 | 4624 | 2 | 2017-10-10 10:02:45 |
| 9082 | 4629 | 2 | 2017-10-10 10:04:40 |
| 9083 | 4635 | 2 | 2017-10-10 10:05:28 |
| 9084 | 4630 | 2 | 2017-10-10 10:07:20 |
| 9085 | 4762 | 1 | 2017-10-10 10:12:55 |
| 9086 | 4763 | 1 | 2017-10-10 10:20:34 |
| 9087 | 4764 | 2 | 2017-10-10 10:58:51 |
| 9088 | 4748 | 2 | 2017-10-10 11:59:21 |
| 9089 | 4748 | 3 | 2017-10-10 13:05:30 |
| 9090 | 4761 | 2 | 2017-10-10 15:43:09 |
| 9091 | 4758 | 2 | 2017-10-10 15:43:47 |
| 9092 | 4759 | 2 | 2017-10-10 15:56:49 |
| 9093 | 4760 | 1 | 2017-10-10 15:57:38 |
| 9094 | 4758 | 3 | 2017-10-10 16:33:13 |
| 9095 | 4761 | 3 | 2017-10-10 16:38:30 |
| 9096 | 4760 | 3 | 2017-10-10 16:47:56 |
| 9097 | 4759 | 3 | 2017-10-10 16:49:26 |
| 9098 | 4758 | 1 | 2017-10-10 17:17:57 |
| 9099 | 4754 | 3 | 2017-10-11 11:11:30 |
| 9100 | 4753 | 2 | 2017-10-11 11:15: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;