Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,976–19,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18976 | 9595 | 3 | 2019-12-24 15:36:23 |
| 18977 | 9560 | 1 | 2019-12-24 15:51:46 |
| 18978 | 9563 | 2 | 2019-12-24 15:55:07 |
| 18979 | 9561 | 2 | 2019-12-24 15:56:11 |
| 18980 | 9562 | 2 | 2019-12-24 15:58:43 |
| 18981 | 9596 | 3 | 2019-12-24 16:10:05 |
| 18982 | 9577 | 3 | 2019-12-24 16:12:42 |
| 18983 | 9576 | 1 | 2019-12-24 16:26:14 |
| 18984 | 9597 | 3 | 2019-12-24 16:28:46 |
| 18985 | 9577 | 2 | 2019-12-24 16:41:19 |
| 18986 | 9561 | 3 | 2019-12-24 16:50:51 |
| 18987 | 9595 | 2 | 2019-12-24 16:52:18 |
| 18988 | 9596 | 2 | 2019-12-24 16:55:10 |
| 18989 | 9560 | 3 | 2019-12-24 17:03:33 |
| 18990 | 9563 | 3 | 2019-12-24 17:16:28 |
| 18991 | 9562 | 3 | 2019-12-24 17:17:09 |
| 18992 | 9597 | 2 | 2019-12-24 17:38:17 |
| 18993 | 9440 | 2 | 2019-12-25 11:51:55 |
| 18994 | 9441 | 1 | 2019-12-25 11:51:58 |
| 18995 | 9439 | 1 | 2019-12-25 11:54:46 |
| 18996 | 9442 | 1 | 2019-12-25 11:56:46 |
| 18997 | 9440 | 3 | 2019-12-25 13:11:53 |
| 18998 | 9586 | 1 | 2019-12-25 15:33:17 |
| 18999 | 9585 | 1 | 2019-12-25 15:34:35 |
| 19000 | 9584 | 1 | 2019-12-25 15:41:21 |
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;