Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,101–19,125 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19101 | 9619 | 2 | 2020-01-04 09:33:55 |
| 19102 | 9618 | 2 | 2020-01-04 09:39:49 |
| 19103 | 9601 | 2 | 2020-01-04 10:18:58 |
| 19104 | 9604 | 2 | 2020-01-04 10:23:41 |
| 19105 | 9602 | 2 | 2020-01-04 10:25:12 |
| 19106 | 9603 | 2 | 2020-01-04 10:31:07 |
| 19107 | 9601 | 3 | 2020-01-04 11:21:53 |
| 19108 | 9603 | 3 | 2020-01-04 11:25:15 |
| 19109 | 9602 | 3 | 2020-01-04 11:51:26 |
| 19110 | 9604 | 3 | 2020-01-04 11:54:25 |
| 19111 | 9603 | 1 | 2020-01-04 12:14:00 |
| 19112 | 9601 | 1 | 2020-01-04 12:35:48 |
| 19113 | 9604 | 1 | 2020-01-04 13:13:37 |
| 19114 | 9602 | 1 | 2020-01-04 13:17:34 |
| 19115 | 9642 | 2 | 2020-01-05 13:33:18 |
| 19116 | 9641 | 2 | 2020-01-05 13:47:46 |
| 19117 | 9642 | 1 | 2020-01-05 14:30:40 |
| 19118 | 9641 | 1 | 2020-01-05 14:51:12 |
| 19119 | 9640 | 2 | 2020-01-05 15:09:15 |
| 19120 | 9642 | 2 | 2020-01-05 15:17:02 |
| 19121 | 9641 | 3 | 2020-01-05 15:37:48 |
| 19122 | 9640 | 3 | 2020-01-05 16:13:03 |
| 19123 | 9643 | 2 | 2020-01-06 09:55:08 |
| 19124 | 9639 | 2 | 2020-01-06 12:05:25 |
| 19125 | 9638 | 3 | 2020-01-06 12:13:49 |
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;