Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,626–12,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12626 | 5711 | 1 | 2018-08-27 10:53:14 |
| 12627 | 5712 | 1 | 2018-08-27 10:53:14 |
| 12628 | 5737 | 1 | 2018-08-27 10:53:32 |
| 12629 | 5901 | 1 | 2018-08-27 10:54:04 |
| 12630 | 5713 | 1 | 2018-08-27 10:54:13 |
| 12631 | 5719 | 1 | 2018-08-27 10:54:44 |
| 12632 | 5722 | 1 | 2018-08-27 10:55:15 |
| 12633 | 5918 | 1 | 2018-08-27 10:57:34 |
| 12634 | 5898 | 1 | 2018-08-27 11:01:23 |
| 12635 | 5907 | 1 | 2018-08-27 11:01:38 |
| 12636 | 5904 | 1 | 2018-08-27 11:02:06 |
| 12637 | 5924 | 1 | 2018-08-27 11:02:58 |
| 12638 | 5931 | 1 | 2018-08-27 11:03:26 |
| 12639 | 5923 | 1 | 2018-08-27 11:06:43 |
| 12640 | 5921 | 1 | 2018-08-27 11:07:33 |
| 12641 | 5911 | 1 | 2018-08-27 11:07:52 |
| 12642 | 5936 | 1 | 2018-08-27 11:12:23 |
| 12643 | 5715 | 3 | 2018-08-27 11:13:37 |
| 12644 | 5710 | 3 | 2018-08-27 11:13:39 |
| 12645 | 5896 | 1 | 2018-08-27 11:13:47 |
| 12646 | 5903 | 1 | 2018-08-27 11:14:17 |
| 12647 | 5735 | 3 | 2018-08-27 11:16:31 |
| 12648 | 5916 | 1 | 2018-08-27 11:17:08 |
| 12649 | 5910 | 1 | 2018-08-27 11:17:16 |
| 12650 | 5914 | 1 | 2018-08-27 11:17:30 |
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;