Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,701–7,725 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7701 | 3992 | 2 | 2017-06-05 11:11:48 |
| 7702 | 3946 | 1 | 2017-06-05 11:26:30 |
| 7703 | 3992 | 3 | 2017-06-05 11:54:20 |
| 7704 | 3946 | 3 | 2017-06-05 11:55:38 |
| 7705 | 3993 | 3 | 2017-06-05 12:15:20 |
| 7706 | 3946 | 1 | 2017-06-05 12:29:04 |
| 7707 | 3776 | 1 | 2017-06-06 09:25:37 |
| 7708 | 3999 | 2 | 2017-06-06 09:26:15 |
| 7709 | 4001 | 2 | 2017-06-06 10:27:34 |
| 7710 | 4000 | 2 | 2017-06-06 10:29:32 |
| 7711 | 4001 | 3 | 2017-06-06 11:00:10 |
| 7712 | 3776 | 2 | 2017-06-06 11:00:52 |
| 7713 | 4002 | 2 | 2017-06-06 11:09:31 |
| 7714 | 3776 | 3 | 2017-06-06 11:50:57 |
| 7715 | 4003 | 2 | 2017-06-06 12:19:47 |
| 7716 | 4001 | 1 | 2017-06-06 12:32:28 |
| 7717 | 3983 | 2 | 2017-06-06 13:01:15 |
| 7718 | 3984 | 2 | 2017-06-06 13:04:38 |
| 7719 | 3985 | 2 | 2017-06-06 13:12:00 |
| 7720 | 3983 | 1 | 2017-06-06 13:48:35 |
| 7721 | 3984 | 1 | 2017-06-06 13:53:13 |
| 7722 | 3983 | 3 | 2017-06-06 14:39:02 |
| 7723 | 3984 | 3 | 2017-06-06 14:49:27 |
| 7724 | 4006 | 1 | 2017-06-07 09:41:25 |
| 7725 | 4005 | 1 | 2017-06-07 09:44:05 |
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;