Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 17,776–17,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 17776 | 9132 | 2 | 2019-10-05 14:03:28 |
| 17777 | 9132 | 3 | 2019-10-05 14:54:46 |
| 17778 | 9131 | 3 | 2019-10-05 15:20:20 |
| 17779 | 9132 | 1 | 2019-10-05 15:25:37 |
| 17780 | 9131 | 1 | 2019-10-05 16:17:46 |
| 17781 | 9143 | 2 | 2019-10-06 13:09:25 |
| 17782 | 9142 | 2 | 2019-10-06 13:15:48 |
| 17783 | 9143 | 1 | 2019-10-06 13:42:34 |
| 17784 | 9142 | 1 | 2019-10-06 14:48:03 |
| 17785 | 9140 | 3 | 2019-10-07 09:24:36 |
| 17786 | 9141 | 3 | 2019-10-07 09:40:19 |
| 17787 | 8850 | 2 | 2019-10-07 10:27:36 |
| 17788 | 8851 | 2 | 2019-10-07 10:30:25 |
| 17789 | 8849 | 2 | 2019-10-07 10:34:37 |
| 17790 | 8848 | 2 | 2019-10-07 10:35:00 |
| 17791 | 9141 | 2 | 2019-10-07 10:51:53 |
| 17792 | 9140 | 2 | 2019-10-07 10:53:08 |
| 17793 | 9140 | 3 | 2019-10-07 11:28:06 |
| 17794 | 9141 | 3 | 2019-10-07 12:11:30 |
| 17795 | 9147 | 1 | 2019-10-08 11:14:22 |
| 17796 | 9150 | 1 | 2019-10-08 11:15:45 |
| 17797 | 9151 | 1 | 2019-10-08 11:18:37 |
| 17798 | 9148 | 3 | 2019-10-08 11:18:54 |
| 17799 | 9149 | 2 | 2019-10-08 11:28:01 |
| 17800 | 9149 | 1 | 2019-10-08 12:20:56 |
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;