Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,976–14,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13976 | 7154 | 3 | 2018-12-02 15:17:58 |
| 13977 | 7223 | 2 | 2018-12-02 16:42:31 |
| 13978 | 7163 | 3 | 2018-12-03 10:47:24 |
| 13979 | 7164 | 2 | 2018-12-03 10:50:10 |
| 13980 | 7166 | 2 | 2018-12-03 10:53:32 |
| 13981 | 7165 | 2 | 2018-12-03 10:54:33 |
| 13982 | 7163 | 2 | 2018-12-03 11:17:39 |
| 13983 | 7164 | 3 | 2018-12-03 11:51:51 |
| 13984 | 7166 | 3 | 2018-12-03 12:02:30 |
| 13985 | 7165 | 3 | 2018-12-03 12:18:33 |
| 13986 | 7163 | 1 | 2018-12-03 12:48:00 |
| 13987 | 7163 | 3 | 2018-12-03 13:36:44 |
| 13988 | 6954 | 2 | 2018-12-04 14:08:38 |
| 13989 | 6955 | 2 | 2018-12-04 14:10:01 |
| 13990 | 6976 | 2 | 2018-12-04 14:10:12 |
| 13991 | 6959 | 2 | 2018-12-04 14:10:29 |
| 13992 | 6966 | 2 | 2018-12-04 14:10:42 |
| 13993 | 6956 | 2 | 2018-12-04 14:11:02 |
| 13994 | 6950 | 2 | 2018-12-04 14:11:05 |
| 13995 | 6972 | 2 | 2018-12-04 14:11:30 |
| 13996 | 6969 | 2 | 2018-12-04 14:11:52 |
| 13997 | 6957 | 2 | 2018-12-04 14:12:46 |
| 13998 | 6978 | 2 | 2018-12-04 14:13:30 |
| 13999 | 6971 | 2 | 2018-12-04 14:13:57 |
| 14000 | 6996 | 2 | 2018-12-04 14:14:38 |
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;