Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 6,976–7,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 6976 | 3630 | 2 | 2017-03-17 14:53:24 |
| 6977 | 3630 | 1 | 2017-03-17 16:10:44 |
| 6978 | 3515 | 1 | 2017-03-18 11:15:42 |
| 6979 | 3517 | 1 | 2017-03-18 11:20:46 |
| 6980 | 3516 | 2 | 2017-03-18 11:24:59 |
| 6981 | 3514 | 2 | 2017-03-18 11:26:44 |
| 6982 | 3515 | 3 | 2017-03-18 11:52:52 |
| 6983 | 3631 | 2 | 2017-03-18 12:02:50 |
| 6984 | 3517 | 3 | 2017-03-18 12:10:54 |
| 6985 | 3515 | 2 | 2017-03-18 12:22:34 |
| 6986 | 3514 | 1 | 2017-03-18 12:31:02 |
| 6987 | 3557 | 1 | 2017-03-18 12:34:54 |
| 6988 | 3631 | 1 | 2017-03-18 12:51:04 |
| 6989 | 3517 | 2 | 2017-03-18 13:19:12 |
| 6990 | 3629 | 2 | 2017-03-20 11:23:06 |
| 6991 | 3628 | 2 | 2017-03-20 11:27:21 |
| 6992 | 3627 | 2 | 2017-03-20 11:28:39 |
| 6993 | 3626 | 2 | 2017-03-20 11:31:19 |
| 6994 | 3627 | 3 | 2017-03-20 12:12:08 |
| 6995 | 3628 | 3 | 2017-03-20 12:20:48 |
| 6996 | 3626 | 3 | 2017-03-20 12:48:45 |
| 6997 | 3629 | 3 | 2017-03-20 12:54:28 |
| 6998 | 3629 | 1 | 2017-03-20 13:30:35 |
| 6999 | 3594 | 2 | 2017-03-20 16:14:59 |
| 7000 | 3594 | 3 | 2017-03-20 17:40:01 |
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;