Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,776–16,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16776 | 7957 | 2 | 2019-07-14 11:17:05 |
| 16777 | 7948 | 2 | 2019-07-14 11:17:07 |
| 16778 | 7960 | 2 | 2019-07-14 11:17:22 |
| 16779 | 7971 | 2 | 2019-07-14 11:17:36 |
| 16780 | 7946 | 2 | 2019-07-14 11:17:53 |
| 16781 | 7941 | 2 | 2019-07-14 11:18:00 |
| 16782 | 7958 | 2 | 2019-07-14 11:18:05 |
| 16783 | 7966 | 2 | 2019-07-14 11:18:27 |
| 16784 | 7972 | 2 | 2019-07-14 11:18:44 |
| 16785 | 7937 | 2 | 2019-07-14 11:18:50 |
| 16786 | 7947 | 2 | 2019-07-14 11:19:47 |
| 16787 | 7950 | 2 | 2019-07-14 11:20:15 |
| 16788 | 7933 | 2 | 2019-07-14 11:20:27 |
| 16789 | 7967 | 2 | 2019-07-14 11:20:34 |
| 16790 | 7952 | 2 | 2019-07-14 11:21:03 |
| 16791 | 7965 | 2 | 2019-07-14 11:21:08 |
| 16792 | 7949 | 2 | 2019-07-14 11:21:28 |
| 16793 | 7936 | 2 | 2019-07-14 11:23:20 |
| 16794 | 7945 | 2 | 2019-07-14 11:23:24 |
| 16795 | 7969 | 2 | 2019-07-14 11:24:55 |
| 16796 | 7935 | 2 | 2019-07-14 11:24:56 |
| 16797 | 7968 | 2 | 2019-07-14 11:25:48 |
| 16798 | 7951 | 2 | 2019-07-14 11:26:34 |
| 16799 | 7955 | 2 | 2019-07-14 11:26:40 |
| 16800 | 7953 | 2 | 2019-07-14 11:27: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;