Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,551–7,575 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7551 | 3929 | 2 | 2017-05-12 13:13:31 |
| 7552 | 3935 | 2 | 2017-05-12 14:25:38 |
| 7553 | 3935 | 3 | 2017-05-12 15:25:57 |
| 7554 | 3908 | 2 | 2017-05-12 16:51:58 |
| 7555 | 3910 | 1 | 2017-05-12 16:53:45 |
| 7556 | 3909 | 1 | 2017-05-12 16:54:03 |
| 7557 | 3911 | 1 | 2017-05-12 17:00:33 |
| 7558 | 3908 | 3 | 2017-05-12 17:37:23 |
| 7559 | 3932 | 3 | 2017-05-13 09:51:23 |
| 7560 | 3934 | 3 | 2017-05-13 09:52:41 |
| 7561 | 3933 | 3 | 2017-05-13 09:56:03 |
| 7562 | 3931 | 3 | 2017-05-13 09:57:51 |
| 7563 | 3934 | 2 | 2017-05-13 10:24:58 |
| 7564 | 3932 | 2 | 2017-05-13 10:59:13 |
| 7565 | 3931 | 2 | 2017-05-13 11:12:09 |
| 7566 | 3933 | 2 | 2017-05-13 11:28:56 |
| 7567 | 3932 | 3 | 2017-05-13 11:38:08 |
| 7568 | 3934 | 3 | 2017-05-13 11:46:17 |
| 7569 | 3931 | 3 | 2017-05-13 12:40:18 |
| 7570 | 3933 | 3 | 2017-05-13 12:42:26 |
| 7571 | 3936 | 1 | 2017-05-13 12:46:13 |
| 7572 | 3939 | 2 | 2017-05-13 15:50:10 |
| 7573 | 3938 | 2 | 2017-05-13 15:53:13 |
| 7574 | 3937 | 2 | 2017-05-13 16:01:04 |
| 7575 | 3939 | 3 | 2017-05-13 16:21:36 |
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;