Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,776–15,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15776 | 8118 | 2 | 2019-04-23 13:17:52 |
| 15777 | 8117 | 1 | 2019-04-23 13:52:59 |
| 15778 | 7887 | 2 | 2019-04-23 13:53:47 |
| 15779 | 8118 | 1 | 2019-04-23 14:03:12 |
| 15780 | 7886 | 2 | 2019-04-23 14:04:07 |
| 15781 | 7887 | 3 | 2019-04-23 14:39:39 |
| 15782 | 8118 | 2 | 2019-04-23 14:55:04 |
| 15783 | 8117 | 2 | 2019-04-23 14:56:53 |
| 15784 | 7886 | 3 | 2019-04-23 15:30:32 |
| 15785 | 7887 | 1 | 2019-04-23 15:53:08 |
| 15786 | 7886 | 1 | 2019-04-23 16:43:07 |
| 15787 | 8129 | 2 | 2019-04-24 09:50:21 |
| 15788 | 8130 | 2 | 2019-04-24 09:53:24 |
| 15789 | 8128 | 2 | 2019-04-24 09:54:41 |
| 15790 | 8130 | 1 | 2019-04-24 11:09:14 |
| 15791 | 8128 | 1 | 2019-04-24 11:19:44 |
| 15792 | 8129 | 1 | 2019-04-24 11:23:07 |
| 15793 | 8128 | 2 | 2019-04-24 11:59:16 |
| 15794 | 8130 | 2 | 2019-04-24 12:08:43 |
| 15795 | 8129 | 2 | 2019-04-24 12:10:33 |
| 15796 | 8128 | 3 | 2019-04-24 12:31:00 |
| 15797 | 8129 | 3 | 2019-04-24 12:38:10 |
| 15798 | 8130 | 3 | 2019-04-24 13:07:02 |
| 15799 | 8079 | 3 | 2019-04-24 13:28:53 |
| 15800 | 8078 | 3 | 2019-04-24 13:36: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;