Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,751–3,775 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3751 | 1727 | 3 | 2016-03-18 15:21:13 |
| 3752 | 1707 | 3 | 2016-03-18 15:21:52 |
| 3753 | 1729 | 3 | 2016-03-18 15:23:21 |
| 3754 | 1700 | 3 | 2016-03-18 15:24:15 |
| 3755 | 1712 | 3 | 2016-03-18 15:28:33 |
| 3756 | 1715 | 3 | 2016-03-18 15:29:15 |
| 3757 | 1714 | 3 | 2016-03-18 15:29:31 |
| 3758 | 1695 | 3 | 2016-03-18 15:31:52 |
| 3759 | 1723 | 3 | 2016-03-18 15:36:36 |
| 3760 | 1710 | 3 | 2016-03-18 15:40:42 |
| 3761 | 1724 | 3 | 2016-03-18 15:52:49 |
| 3762 | 1718 | 3 | 2016-03-18 16:01:10 |
| 3763 | 1728 | 3 | 2016-03-18 16:18:16 |
| 3764 | 1955 | 2 | 2016-03-19 11:25:04 |
| 3765 | 1960 | 2 | 2016-03-19 15:27:27 |
| 3766 | 1961 | 2 | 2016-03-19 15:27:39 |
| 3767 | 1962 | 2 | 2016-03-19 15:33:18 |
| 3768 | 1963 | 2 | 2016-03-19 15:40:42 |
| 3769 | 1962 | 3 | 2016-03-19 15:59:19 |
| 3770 | 1963 | 3 | 2016-03-19 16:29:06 |
| 3771 | 1961 | 3 | 2016-03-19 16:56:36 |
| 3772 | 1960 | 3 | 2016-03-19 16:57:22 |
| 3773 | 1967 | 3 | 2016-03-20 09:36:20 |
| 3774 | 1968 | 3 | 2016-03-20 09:37:43 |
| 3775 | 1974 | 2 | 2016-03-20 09:46:16 |
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;