Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,226–7,250 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7226 | 3761 | 2 | 2017-04-19 10:39:05 |
| 7227 | 3766 | 1 | 2017-04-19 10:43:11 |
| 7228 | 3766 | 3 | 2017-04-19 11:14:41 |
| 7229 | 3759 | 3 | 2017-04-19 12:48:26 |
| 7230 | 3760 | 2 | 2017-04-19 12:53:14 |
| 7231 | 3759 | 1 | 2017-04-19 13:20:36 |
| 7232 | 3760 | 3 | 2017-04-19 14:06:03 |
| 7233 | 3739 | 2 | 2017-04-19 14:33:43 |
| 7234 | 3738 | 2 | 2017-04-19 14:35:13 |
| 7235 | 3740 | 2 | 2017-04-19 14:44:05 |
| 7236 | 3740 | 1 | 2017-04-19 15:49:39 |
| 7237 | 3739 | 1 | 2017-04-19 16:03:01 |
| 7238 | 3738 | 1 | 2017-04-19 16:07:41 |
| 7239 | 3738 | 2 | 2017-04-19 16:36:09 |
| 7240 | 3813 | 3 | 2017-04-19 16:49:42 |
| 7241 | 3740 | 2 | 2017-04-19 17:23:53 |
| 7242 | 3739 | 2 | 2017-04-19 17:33:17 |
| 7243 | 3779 | 3 | 2017-04-20 10:38:37 |
| 7244 | 3782 | 3 | 2017-04-20 10:40:05 |
| 7245 | 3780 | 3 | 2017-04-20 10:47:07 |
| 7246 | 3781 | 2 | 2017-04-20 10:47:31 |
| 7247 | 3782 | 2 | 2017-04-20 11:43:37 |
| 7248 | 3779 | 2 | 2017-04-20 11:59:05 |
| 7249 | 3780 | 2 | 2017-04-20 12:15:29 |
| 7250 | 3773 | 2 | 2017-04-20 12:43:07 |
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;