Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,576–9,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9576 | 4882 | 2 | 2017-11-23 12:35:02 |
| 9577 | 4883 | 1 | 2017-11-23 12:38:53 |
| 9578 | 4884 | 2 | 2017-11-23 12:39:08 |
| 9579 | 4881 | 3 | 2017-11-23 12:41:30 |
| 9580 | 4884 | 3 | 2017-11-23 14:01:26 |
| 9581 | 4881 | 2 | 2017-11-23 14:07:02 |
| 9582 | 4866 | 1 | 2017-11-23 14:25:52 |
| 9583 | 4886 | 1 | 2017-11-23 14:56:20 |
| 9584 | 4885 | 1 | 2017-11-23 14:59:46 |
| 9585 | 4866 | 3 | 2017-11-23 15:18:59 |
| 9586 | 4887 | 1 | 2017-11-23 16:41:31 |
| 9587 | 4890 | 2 | 2017-11-25 13:03:56 |
| 9588 | 4891 | 2 | 2017-11-25 13:09:21 |
| 9589 | 4890 | 3 | 2017-11-25 13:34:30 |
| 9590 | 4891 | 3 | 2017-11-25 13:49:13 |
| 9591 | 4891 | 2 | 2017-11-25 14:23:52 |
| 9592 | 4879 | 2 | 2017-11-25 16:51:34 |
| 9593 | 4880 | 2 | 2017-11-25 16:56:35 |
| 9594 | 4893 | 2 | 2017-11-26 10:53:20 |
| 9595 | 4894 | 2 | 2017-11-26 10:56:01 |
| 9596 | 4896 | 1 | 2017-11-26 14:35:21 |
| 9597 | 4895 | 1 | 2017-11-26 14:37:04 |
| 9598 | 4897 | 2 | 2017-11-26 15:57:23 |
| 9599 | 4897 | 3 | 2017-11-26 17:00:18 |
| 9600 | 4898 | 1 | 2017-11-28 12:27:52 |
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;