Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,776–7,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7776 | 4035 | 1 | 2017-06-11 13:49:23 |
| 7777 | 4029 | 1 | 2017-06-11 13:50:26 |
| 7778 | 4039 | 1 | 2017-06-11 13:51:38 |
| 7779 | 4038 | 1 | 2017-06-11 13:53:17 |
| 7780 | 4037 | 2 | 2017-06-11 14:08:14 |
| 7781 | 4030 | 1 | 2017-06-11 14:10:16 |
| 7782 | 4017 | 1 | 2017-06-11 14:34:24 |
| 7783 | 4034 | 3 | 2017-06-11 14:38:40 |
| 7784 | 4033 | 3 | 2017-06-11 14:38:59 |
| 7785 | 4036 | 2 | 2017-06-11 14:55:23 |
| 7786 | 4035 | 2 | 2017-06-11 15:03:18 |
| 7787 | 4008 | 2 | 2017-06-11 15:05:58 |
| 7788 | 4007 | 2 | 2017-06-11 15:12:22 |
| 7789 | 4038 | 2 | 2017-06-11 15:15:16 |
| 7790 | 4039 | 2 | 2017-06-11 15:19:57 |
| 7791 | 4007 | 1 | 2017-06-11 15:43:11 |
| 7792 | 4040 | 2 | 2017-06-11 15:49:06 |
| 7793 | 4036 | 3 | 2017-06-11 15:55:44 |
| 7794 | 4038 | 3 | 2017-06-11 16:00:15 |
| 7795 | 4035 | 3 | 2017-06-11 16:11:30 |
| 7796 | 4039 | 3 | 2017-06-11 16:20:35 |
| 7797 | 4007 | 3 | 2017-06-11 16:44:28 |
| 7798 | 4035 | 1 | 2017-06-11 16:51:38 |
| 7799 | 4036 | 1 | 2017-06-11 16:53:04 |
| 7800 | 4039 | 1 | 2017-06-11 17:02:05 |
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;