Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,776–10,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10776 | 5583 | 2 | 2018-04-18 12:10:06 |
| 10777 | 5583 | 1 | 2018-04-18 13:09:22 |
| 10778 | 5292 | 2 | 2018-04-18 14:36:42 |
| 10779 | 5293 | 1 | 2018-04-18 14:42:49 |
| 10780 | 5532 | 2 | 2018-04-18 15:08:00 |
| 10781 | 5293 | 3 | 2018-04-18 15:15:28 |
| 10782 | 5546 | 3 | 2018-04-18 16:45:47 |
| 10783 | 5293 | 1 | 2018-04-18 16:50:41 |
| 10784 | 5548 | 3 | 2018-04-18 16:56:39 |
| 10785 | 5545 | 3 | 2018-04-18 16:56:43 |
| 10786 | 5547 | 3 | 2018-04-18 16:59:54 |
| 10787 | 5546 | 2 | 2018-04-18 17:26:41 |
| 10788 | 5547 | 2 | 2018-04-18 17:30:18 |
| 10789 | 5457 | 2 | 2018-04-19 10:10:03 |
| 10790 | 5459 | 1 | 2018-04-19 10:14:15 |
| 10791 | 5458 | 2 | 2018-04-19 10:16:10 |
| 10792 | 5460 | 2 | 2018-04-19 10:17:02 |
| 10793 | 5460 | 3 | 2018-04-19 11:05:22 |
| 10794 | 5458 | 3 | 2018-04-19 11:14:17 |
| 10795 | 5459 | 3 | 2018-04-19 11:27:28 |
| 10796 | 5457 | 1 | 2018-04-19 11:38:42 |
| 10797 | 5460 | 1 | 2018-04-19 12:03:52 |
| 10798 | 5458 | 1 | 2018-04-19 12:18:11 |
| 10799 | 5573 | 3 | 2018-04-19 13:14:40 |
| 10800 | 5588 | 2 | 2018-04-20 09:40:35 |
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;