Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 8,951–8,975 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 8951 | 4660 | 2 | 2017-09-22 16:40:58 |
| 8952 | 4661 | 3 | 2017-09-22 16:53:00 |
| 8953 | 4647 | 2 | 2017-09-23 14:01:37 |
| 8954 | 4647 | 1 | 2017-09-23 15:32:15 |
| 8955 | 4647 | 2 | 2017-09-23 16:38:22 |
| 8956 | 4647 | 3 | 2017-09-23 17:18:42 |
| 8957 | 4662 | 2 | 2017-09-24 09:55:18 |
| 8958 | 4591 | 3 | 2017-09-24 10:14:30 |
| 8959 | 4590 | 3 | 2017-09-24 10:19:27 |
| 8960 | 4593 | 3 | 2017-09-24 10:21:12 |
| 8961 | 4592 | 3 | 2017-09-24 10:23:11 |
| 8962 | 4662 | 1 | 2017-09-24 11:26:25 |
| 8963 | 4576 | 2 | 2017-09-24 11:54:41 |
| 8964 | 4574 | 2 | 2017-09-24 11:55:20 |
| 8965 | 4573 | 2 | 2017-09-24 12:06:15 |
| 8966 | 4575 | 2 | 2017-09-24 12:07:37 |
| 8967 | 4662 | 3 | 2017-09-24 12:51:19 |
| 8968 | 4571 | 1 | 2017-09-26 10:55:42 |
| 8969 | 4572 | 1 | 2017-09-26 11:03:35 |
| 8970 | 4571 | 3 | 2017-09-26 11:28:20 |
| 8971 | 4664 | 1 | 2017-09-26 12:03:39 |
| 8972 | 4572 | 3 | 2017-09-26 12:03:43 |
| 8973 | 4663 | 1 | 2017-09-26 12:08:51 |
| 8974 | 4666 | 1 | 2017-09-26 12:09:51 |
| 8975 | 4665 | 1 | 2017-09-26 12:16:55 |
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;