Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,101–3,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3101 | 1593 | 3 | 2015-12-17 11:06:39 |
| 3102 | 1592 | 3 | 2015-12-17 11:45:04 |
| 3103 | 1591 | 3 | 2015-12-17 12:03:31 |
| 3104 | 1597 | 2 | 2015-12-18 09:58:24 |
| 3105 | 1594 | 2 | 2015-12-18 10:02:48 |
| 3106 | 1596 | 2 | 2015-12-18 10:12:24 |
| 3107 | 1595 | 2 | 2015-12-18 10:12:28 |
| 3108 | 1596 | 1 | 2015-12-18 10:47:13 |
| 3109 | 1594 | 3 | 2015-12-18 10:58:07 |
| 3110 | 1595 | 3 | 2015-12-18 11:22:56 |
| 3111 | 1597 | 3 | 2015-12-18 11:28:46 |
| 3112 | 1598 | 2 | 2015-12-18 13:43:26 |
| 3113 | 1546 | 3 | 2015-12-18 16:31:45 |
| 3114 | 1548 | 3 | 2015-12-18 16:34:53 |
| 3115 | 1547 | 3 | 2015-12-18 16:35:03 |
| 3116 | 1546 | 1 | 2015-12-18 17:06:40 |
| 3117 | 1548 | 1 | 2015-12-18 17:43:43 |
| 3118 | 1599 | 2 | 2015-12-19 09:23:22 |
| 3119 | 1600 | 2 | 2015-12-19 09:38:39 |
| 3120 | 1601 | 2 | 2015-12-19 10:05:53 |
| 3121 | 1600 | 1 | 2015-12-19 10:23:10 |
| 3122 | 1603 | 2 | 2015-12-19 15:05:48 |
| 3123 | 1602 | 3 | 2015-12-19 15:10:16 |
| 3124 | 1604 | 3 | 2015-12-19 15:46:12 |
| 3125 | 1605 | 3 | 2015-12-19 15:47:25 |
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;