Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 976–1,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 976 | 433 | 3 | 2015-05-30 11:58:42 |
| 977 | 600 | 2 | 2015-05-31 16:10:03 |
| 978 | 599 | 2 | 2015-05-31 16:11:11 |
| 979 | 540 | 1 | 2015-05-31 16:57:36 |
| 980 | 622 | 2 | 2015-06-01 13:31:07 |
| 981 | 623 | 2 | 2015-06-01 13:40:01 |
| 982 | 623 | 3 | 2015-06-01 14:14:29 |
| 983 | 622 | 3 | 2015-06-01 14:46:11 |
| 984 | 623 | 1 | 2015-06-01 14:54:58 |
| 985 | 622 | 1 | 2015-06-01 15:38:52 |
| 986 | 623 | 3 | 2015-06-01 15:43:04 |
| 987 | 622 | 3 | 2015-06-01 16:55:03 |
| 988 | 631 | 1 | 2015-06-03 11:31:53 |
| 989 | 630 | 1 | 2015-06-03 11:40:41 |
| 990 | 631 | 3 | 2015-06-03 12:11:25 |
| 991 | 630 | 3 | 2015-06-03 12:29:14 |
| 992 | 634 | 3 | 2015-06-06 10:34:06 |
| 993 | 633 | 3 | 2015-06-06 10:41:24 |
| 994 | 633 | 1 | 2015-06-06 11:16:50 |
| 995 | 634 | 1 | 2015-06-06 11:19:42 |
| 996 | 637 | 2 | 2015-06-06 11:21:35 |
| 997 | 634 | 3 | 2015-06-06 12:29:45 |
| 998 | 637 | 3 | 2015-06-06 12:36:34 |
| 999 | 633 | 3 | 2015-06-06 12:36:35 |
| 1000 | 638 | 1 | 2015-06-06 13:41:35 |
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;