Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,626–13,650 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13626 | 6923 | 3 | 2018-10-28 16:21:19 |
| 13627 | 6936 | 2 | 2018-10-28 16:34:16 |
| 13628 | 6927 | 1 | 2018-10-28 16:39:54 |
| 13629 | 6924 | 1 | 2018-10-28 16:45:35 |
| 13630 | 6927 | 3 | 2018-10-28 17:11:45 |
| 13631 | 6898 | 1 | 2018-10-28 17:24:37 |
| 13632 | 6924 | 3 | 2018-10-28 17:31:19 |
| 13633 | 6939 | 1 | 2018-10-29 09:44:08 |
| 13634 | 6940 | 1 | 2018-10-29 09:48:30 |
| 13635 | 6938 | 1 | 2018-10-29 09:49:38 |
| 13636 | 6937 | 1 | 2018-10-29 09:51:52 |
| 13637 | 6901 | 2 | 2018-10-29 11:00:59 |
| 13638 | 6910 | 2 | 2018-10-29 11:12:21 |
| 13639 | 6909 | 2 | 2018-10-29 11:14:37 |
| 13640 | 6909 | 3 | 2018-10-29 11:43:32 |
| 13641 | 6910 | 3 | 2018-10-29 11:50:13 |
| 13642 | 6910 | 2 | 2018-10-29 12:28:07 |
| 13643 | 6909 | 2 | 2018-10-29 12:29:36 |
| 13644 | 6911 | 2 | 2018-10-29 12:46:21 |
| 13645 | 6911 | 3 | 2018-10-29 13:21:22 |
| 13646 | 6942 | 3 | 2018-10-29 13:34:06 |
| 13647 | 6906 | 1 | 2018-10-29 13:34:33 |
| 13648 | 6943 | 3 | 2018-10-29 13:39:52 |
| 13649 | 6941 | 3 | 2018-10-29 13:40:58 |
| 13650 | 6908 | 1 | 2018-10-29 13:43:20 |
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;