Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,876–9,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9876 | 5147 | 2 | 2018-01-15 11:13:10 |
| 9877 | 5146 | 2 | 2018-01-15 11:14:25 |
| 9878 | 5143 | 2 | 2018-01-15 11:24:27 |
| 9879 | 5145 | 2 | 2018-01-15 11:34:22 |
| 9880 | 5144 | 2 | 2018-01-15 11:44:20 |
| 9881 | 5146 | 3 | 2018-01-15 11:48:05 |
| 9882 | 5147 | 3 | 2018-01-15 11:58:11 |
| 9883 | 5146 | 2 | 2018-01-15 13:10:35 |
| 9884 | 5147 | 2 | 2018-01-15 13:24:53 |
| 9885 | 5123 | 2 | 2018-01-16 11:37:08 |
| 9886 | 5123 | 1 | 2018-01-16 12:47:04 |
| 9887 | 5044 | 3 | 2018-01-16 13:23:17 |
| 9888 | 5044 | 2 | 2018-01-16 13:49:00 |
| 9889 | 5123 | 2 | 2018-01-16 14:05:43 |
| 9890 | 5044 | 1 | 2018-01-16 14:56:16 |
| 9891 | 5044 | 2 | 2018-01-16 16:00:30 |
| 9892 | 5200 | 2 | 2018-01-17 12:56:18 |
| 9893 | 5200 | 1 | 2018-01-17 13:45:39 |
| 9894 | 5200 | 3 | 2018-01-17 15:19:39 |
| 9895 | 5046 | 2 | 2018-01-17 15:57:32 |
| 9896 | 5046 | 1 | 2018-01-17 16:27:37 |
| 9897 | 5202 | 1 | 2018-01-18 10:31:23 |
| 9898 | 5203 | 2 | 2018-01-18 10:37:25 |
| 9899 | 5201 | 1 | 2018-01-18 10:40:30 |
| 9900 | 5203 | 3 | 2018-01-18 11:42:52 |
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;