Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,601–18,625 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18601 | 9541 | 2 | 2019-12-15 10:50:30 |
| 18602 | 8967 | 3 | 2019-12-15 11:17:16 |
| 18603 | 8962 | 3 | 2019-12-15 11:18:06 |
| 18604 | 8983 | 3 | 2019-12-15 11:18:36 |
| 18605 | 8968 | 3 | 2019-12-15 11:20:30 |
| 18606 | 8976 | 3 | 2019-12-15 11:20:31 |
| 18607 | 8966 | 3 | 2019-12-15 11:20:33 |
| 18608 | 8973 | 3 | 2019-12-15 11:22:00 |
| 18609 | 8960 | 3 | 2019-12-15 11:22:22 |
| 18610 | 8981 | 3 | 2019-12-15 11:22:57 |
| 18611 | 8984 | 3 | 2019-12-15 11:23:07 |
| 18612 | 8999 | 3 | 2019-12-15 11:23:29 |
| 18613 | 8982 | 3 | 2019-12-15 11:23:50 |
| 18614 | 8969 | 3 | 2019-12-15 11:23:51 |
| 18615 | 8996 | 3 | 2019-12-15 11:24:45 |
| 18616 | 8990 | 3 | 2019-12-15 11:24:51 |
| 18617 | 9006 | 3 | 2019-12-15 11:24:55 |
| 18618 | 8994 | 3 | 2019-12-15 11:25:00 |
| 18619 | 9003 | 3 | 2019-12-15 11:25:15 |
| 18620 | 8987 | 3 | 2019-12-15 11:25:47 |
| 18621 | 8974 | 3 | 2019-12-15 11:26:01 |
| 18622 | 8979 | 3 | 2019-12-15 11:26:33 |
| 18623 | 8963 | 3 | 2019-12-15 11:26:41 |
| 18624 | 8959 | 3 | 2019-12-15 11:26:58 |
| 18625 | 9002 | 3 | 2019-12-15 11:26:59 |
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;