Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,826–16,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16826 | 7970 | 1 | 2019-07-14 12:16:35 |
| 16827 | 8546 | 2 | 2019-07-14 12:16:40 |
| 16828 | 7964 | 1 | 2019-07-14 12:17:30 |
| 16829 | 7971 | 1 | 2019-07-14 12:20:11 |
| 16830 | 7934 | 1 | 2019-07-14 12:20:32 |
| 16831 | 7956 | 1 | 2019-07-14 12:21:25 |
| 16832 | 7946 | 1 | 2019-07-14 12:21:56 |
| 16833 | 7957 | 1 | 2019-07-14 12:23:22 |
| 16834 | 7936 | 1 | 2019-07-14 12:23:41 |
| 16835 | 7948 | 1 | 2019-07-14 12:26:08 |
| 16836 | 7965 | 1 | 2019-07-14 12:26:17 |
| 16837 | 7944 | 1 | 2019-07-14 12:27:02 |
| 16838 | 7939 | 1 | 2019-07-14 12:28:07 |
| 16839 | 8517 | 2 | 2019-07-14 12:28:10 |
| 16840 | 7963 | 1 | 2019-07-14 12:28:20 |
| 16841 | 7955 | 1 | 2019-07-14 12:32:35 |
| 16842 | 7932 | 1 | 2019-07-14 12:34:04 |
| 16843 | 7941 | 3 | 2019-07-14 12:34:26 |
| 16844 | 7962 | 3 | 2019-07-14 12:35:56 |
| 16845 | 7943 | 3 | 2019-07-14 12:39:01 |
| 16846 | 7945 | 1 | 2019-07-14 12:40:40 |
| 16847 | 7968 | 3 | 2019-07-14 12:41:49 |
| 16848 | 7940 | 3 | 2019-07-14 12:43:48 |
| 16849 | 7952 | 1 | 2019-07-14 12:44:06 |
| 16850 | 7954 | 1 | 2019-07-14 12:46:32 |
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;