Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,726–3,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3726 | 1730 | 2 | 2016-03-18 14:24:29 |
| 3727 | 1722 | 2 | 2016-03-18 14:26:33 |
| 3728 | 1731 | 3 | 2016-03-18 14:28:04 |
| 3729 | 1704 | 3 | 2016-03-18 14:28:06 |
| 3730 | 1715 | 2 | 2016-03-18 14:28:43 |
| 3731 | 1709 | 3 | 2016-03-18 14:35:33 |
| 3732 | 1718 | 2 | 2016-03-18 14:36:53 |
| 3733 | 1694 | 3 | 2016-03-18 14:37:15 |
| 3734 | 1719 | 3 | 2016-03-18 14:41:37 |
| 3735 | 1729 | 2 | 2016-03-18 14:42:15 |
| 3736 | 1687 | 3 | 2016-03-18 14:42:37 |
| 3737 | 1688 | 3 | 2016-03-18 14:42:53 |
| 3738 | 1692 | 3 | 2016-03-18 14:46:10 |
| 3739 | 1728 | 2 | 2016-03-18 14:46:19 |
| 3740 | 1717 | 3 | 2016-03-18 14:50:49 |
| 3741 | 1699 | 3 | 2016-03-18 14:51:57 |
| 3742 | 1720 | 3 | 2016-03-18 14:52:55 |
| 3743 | 1716 | 3 | 2016-03-18 14:56:32 |
| 3744 | 1713 | 3 | 2016-03-18 14:59:18 |
| 3745 | 1722 | 3 | 2016-03-18 14:59:18 |
| 3746 | 1730 | 3 | 2016-03-18 15:01:03 |
| 3747 | 1686 | 3 | 2016-03-18 15:10:26 |
| 3748 | 1721 | 3 | 2016-03-18 15:10:52 |
| 3749 | 1702 | 3 | 2016-03-18 15:12:43 |
| 3750 | 1697 | 3 | 2016-03-18 15:16:56 |
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;