Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,926–9,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9926 | 5013 | 3 | 2018-01-19 13:25:41 |
| 9927 | 5028 | 3 | 2018-01-19 13:26:09 |
| 9928 | 4994 | 3 | 2018-01-19 13:26:13 |
| 9929 | 5015 | 3 | 2018-01-19 13:26:18 |
| 9930 | 5012 | 3 | 2018-01-19 13:26:56 |
| 9931 | 5009 | 3 | 2018-01-19 13:27:32 |
| 9932 | 5007 | 3 | 2018-01-19 13:27:36 |
| 9933 | 5011 | 3 | 2018-01-19 13:27:51 |
| 9934 | 5026 | 3 | 2018-01-19 13:28:06 |
| 9935 | 5027 | 3 | 2018-01-19 13:28:21 |
| 9936 | 5018 | 3 | 2018-01-19 13:28:41 |
| 9937 | 5030 | 3 | 2018-01-19 13:28:52 |
| 9938 | 4995 | 3 | 2018-01-19 13:28:58 |
| 9939 | 5008 | 3 | 2018-01-19 13:29:22 |
| 9940 | 4993 | 3 | 2018-01-19 13:29:46 |
| 9941 | 4999 | 3 | 2018-01-19 13:30:04 |
| 9942 | 4996 | 3 | 2018-01-19 13:30:36 |
| 9943 | 5024 | 3 | 2018-01-19 13:31:38 |
| 9944 | 4998 | 3 | 2018-01-19 13:31:47 |
| 9945 | 5019 | 3 | 2018-01-19 13:32:35 |
| 9946 | 5031 | 3 | 2018-01-19 13:36:24 |
| 9947 | 5002 | 2 | 2018-01-19 13:55:45 |
| 9948 | 5029 | 2 | 2018-01-19 13:57:10 |
| 9949 | 5010 | 2 | 2018-01-19 13:59:32 |
| 9950 | 4994 | 2 | 2018-01-19 14:00:20 |
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;