Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,551–13,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13551 | 6160 | 1 | 2018-10-25 11:26:07 |
| 13552 | 6120 | 1 | 2018-10-25 11:26:09 |
| 13553 | 6157 | 1 | 2018-10-25 11:26:30 |
| 13554 | 6158 | 1 | 2018-10-25 11:28:46 |
| 13555 | 6135 | 1 | 2018-10-25 11:31:59 |
| 13556 | 6136 | 1 | 2018-10-25 11:33:15 |
| 13557 | 6129 | 1 | 2018-10-25 11:33:23 |
| 13558 | 6128 | 1 | 2018-10-25 11:35:48 |
| 13559 | 6133 | 1 | 2018-10-25 11:37:36 |
| 13560 | 6162 | 1 | 2018-10-25 11:38:40 |
| 13561 | 6165 | 1 | 2018-10-25 11:38:42 |
| 13562 | 6155 | 1 | 2018-10-25 11:40:26 |
| 13563 | 6126 | 1 | 2018-10-25 11:41:44 |
| 13564 | 6143 | 1 | 2018-10-25 11:42:03 |
| 13565 | 6132 | 1 | 2018-10-25 11:42:55 |
| 13566 | 6123 | 1 | 2018-10-25 11:44:50 |
| 13567 | 6149 | 1 | 2018-10-25 11:50:45 |
| 13568 | 6121 | 1 | 2018-10-25 11:51:27 |
| 13569 | 6147 | 1 | 2018-10-25 11:51:57 |
| 13570 | 6148 | 1 | 2018-10-25 11:52:25 |
| 13571 | 6163 | 1 | 2018-10-25 11:55:56 |
| 13572 | 6159 | 1 | 2018-10-25 11:58:07 |
| 13573 | 6144 | 1 | 2018-10-25 11:58:09 |
| 13574 | 6141 | 1 | 2018-10-25 12:02:16 |
| 13575 | 6699 | 2 | 2018-10-25 14:28:30 |
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;