Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,976–2,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1976 | 556 | 3 | 2015-09-03 12:14:39 |
| 1977 | 586 | 3 | 2015-09-03 12:15:11 |
| 1978 | 590 | 3 | 2015-09-03 12:15:12 |
| 1979 | 572 | 3 | 2015-09-03 12:15:15 |
| 1980 | 569 | 3 | 2015-09-03 12:15:58 |
| 1981 | 579 | 3 | 2015-09-03 12:16:19 |
| 1982 | 577 | 3 | 2015-09-03 12:16:32 |
| 1983 | 574 | 3 | 2015-09-03 12:17:42 |
| 1984 | 583 | 3 | 2015-09-03 12:17:42 |
| 1985 | 596 | 3 | 2015-09-03 12:18:05 |
| 1986 | 568 | 3 | 2015-09-03 12:18:36 |
| 1987 | 571 | 3 | 2015-09-03 12:18:39 |
| 1988 | 589 | 3 | 2015-09-03 12:18:48 |
| 1989 | 573 | 3 | 2015-09-03 12:18:54 |
| 1990 | 582 | 3 | 2015-09-03 12:19:35 |
| 1991 | 580 | 3 | 2015-09-03 12:20:18 |
| 1992 | 578 | 3 | 2015-09-03 12:21:03 |
| 1993 | 564 | 3 | 2015-09-03 12:21:08 |
| 1994 | 566 | 3 | 2015-09-03 12:21:52 |
| 1995 | 584 | 3 | 2015-09-03 12:22:14 |
| 1996 | 570 | 3 | 2015-09-03 12:22:16 |
| 1997 | 591 | 3 | 2015-09-03 12:22:28 |
| 1998 | 581 | 3 | 2015-09-03 12:23:28 |
| 1999 | 587 | 3 | 2015-09-03 12:24:24 |
| 2000 | 594 | 3 | 2015-09-03 12:24:44 |
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;