Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 16,976–17,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 16976 | 8550 | 3 | 2019-07-24 13:23:38 |
| 16977 | 8585 | 2 | 2019-07-24 13:38:15 |
| 16978 | 8551 | 2 | 2019-07-24 13:50:58 |
| 16979 | 8631 | 3 | 2019-07-24 13:55:13 |
| 16980 | 8631 | 1 | 2019-07-24 14:31:50 |
| 16981 | 8635 | 2 | 2019-07-24 15:02:32 |
| 16982 | 8551 | 3 | 2019-07-24 15:23:53 |
| 16983 | 8597 | 3 | 2019-07-24 15:47:03 |
| 16984 | 8597 | 2 | 2019-07-24 16:42:30 |
| 16985 | 8636 | 3 | 2019-07-25 10:17:41 |
| 16986 | 8463 | 2 | 2019-07-25 12:30:00 |
| 16987 | 8470 | 2 | 2019-07-25 12:31:24 |
| 16988 | 8488 | 2 | 2019-07-25 12:31:26 |
| 16989 | 8484 | 2 | 2019-07-25 12:33:24 |
| 16990 | 8480 | 2 | 2019-07-25 12:33:38 |
| 16991 | 8491 | 2 | 2019-07-25 12:34:42 |
| 16992 | 8489 | 2 | 2019-07-25 12:35:25 |
| 16993 | 8464 | 2 | 2019-07-25 12:35:37 |
| 16994 | 8476 | 2 | 2019-07-25 12:36:54 |
| 16995 | 8475 | 2 | 2019-07-25 12:36:57 |
| 16996 | 8474 | 2 | 2019-07-25 12:37:35 |
| 16997 | 8492 | 2 | 2019-07-25 12:37:40 |
| 16998 | 8472 | 2 | 2019-07-25 12:38:43 |
| 16999 | 8477 | 2 | 2019-07-25 12:39:17 |
| 17000 | 8478 | 2 | 2019-07-25 12:40:08 |
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;