Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 12,751–12,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 12751 | 5928 | 2 | 2018-08-27 13:18:37 |
| 12752 | 5925 | 3 | 2018-08-27 13:20:17 |
| 12753 | 5931 | 3 | 2018-08-27 13:21:48 |
| 12754 | 5919 | 3 | 2018-08-27 13:21:53 |
| 12755 | 5901 | 3 | 2018-08-27 13:22:12 |
| 12756 | 5897 | 3 | 2018-08-27 13:23:37 |
| 12757 | 5903 | 3 | 2018-08-27 13:28:51 |
| 12758 | 5912 | 3 | 2018-08-27 13:29:15 |
| 12759 | 5918 | 3 | 2018-08-27 13:29:27 |
| 12760 | 5930 | 2 | 2018-08-27 13:34:48 |
| 12761 | 5915 | 3 | 2018-08-27 13:36:20 |
| 12762 | 5920 | 3 | 2018-08-27 13:38:13 |
| 12763 | 5916 | 3 | 2018-08-27 13:39:02 |
| 12764 | 5933 | 3 | 2018-08-27 13:39:19 |
| 12765 | 5911 | 3 | 2018-08-27 13:40:27 |
| 12766 | 5929 | 3 | 2018-08-27 13:41:46 |
| 12767 | 5905 | 3 | 2018-08-27 13:44:34 |
| 12768 | 5906 | 3 | 2018-08-27 13:45:12 |
| 12769 | 5934 | 3 | 2018-08-27 13:49:01 |
| 12770 | 5908 | 3 | 2018-08-27 13:51:19 |
| 12771 | 5900 | 3 | 2018-08-27 14:07:36 |
| 12772 | 5909 | 3 | 2018-08-27 14:10:46 |
| 12773 | 5935 | 3 | 2018-08-27 14:14:03 |
| 12774 | 5930 | 3 | 2018-08-27 14:15:39 |
| 12775 | 5899 | 3 | 2018-08-27 14:21:15 |
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;