Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,101–13,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13101 | 6709 | 2 | 2018-09-18 11:58:46 |
| 13102 | 6687 | 3 | 2018-09-18 12:25:51 |
| 13103 | 6708 | 2 | 2018-09-18 12:34:08 |
| 13104 | 6686 | 1 | 2018-09-18 12:35:48 |
| 13105 | 6709 | 3 | 2018-09-18 13:10:51 |
| 13106 | 6709 | 1 | 2018-09-18 14:44:52 |
| 13107 | 6733 | 1 | 2018-09-18 15:56:00 |
| 13108 | 6732 | 1 | 2018-09-18 15:57:59 |
| 13109 | 6730 | 1 | 2018-09-18 15:59:11 |
| 13110 | 6731 | 1 | 2018-09-18 16:04:28 |
| 13111 | 6709 | 2 | 2018-09-18 16:10:03 |
| 13112 | 6610 | 3 | 2018-09-18 16:52:41 |
| 13113 | 6609 | 3 | 2018-09-18 17:04:32 |
| 13114 | 6729 | 3 | 2018-09-19 10:33:00 |
| 13115 | 6729 | 2 | 2018-09-19 11:26:55 |
| 13116 | 6734 | 2 | 2018-09-19 11:59:05 |
| 13117 | 6735 | 2 | 2018-09-19 12:01:22 |
| 13118 | 6736 | 2 | 2018-09-19 12:02:06 |
| 13119 | 6701 | 1 | 2018-09-19 12:07:02 |
| 13120 | 6729 | 3 | 2018-09-19 12:11:15 |
| 13121 | 6700 | 1 | 2018-09-19 12:16:24 |
| 13122 | 6734 | 3 | 2018-09-19 13:10:11 |
| 13123 | 6735 | 3 | 2018-09-19 13:26:27 |
| 13124 | 6736 | 3 | 2018-09-19 13:34:52 |
| 13125 | 6729 | 2 | 2018-09-19 13:42:37 |
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;