Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,826–7,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7826 | 4047 | 2 | 2017-06-14 12:05:32 |
| 7827 | 3979 | 1 | 2017-06-14 12:17:11 |
| 7828 | 3806 | 1 | 2017-06-14 12:27:36 |
| 7829 | 3798 | 1 | 2017-06-14 12:27:47 |
| 7830 | 3801 | 1 | 2017-06-14 12:27:51 |
| 7831 | 3808 | 1 | 2017-06-14 12:30:12 |
| 7832 | 3795 | 1 | 2017-06-14 12:31:13 |
| 7833 | 3810 | 1 | 2017-06-14 12:33:36 |
| 7834 | 3796 | 1 | 2017-06-14 12:34:27 |
| 7835 | 3807 | 1 | 2017-06-14 12:35:10 |
| 7836 | 3783 | 1 | 2017-06-14 12:37:05 |
| 7837 | 3803 | 1 | 2017-06-14 12:37:41 |
| 7838 | 3784 | 1 | 2017-06-14 12:37:47 |
| 7839 | 3790 | 1 | 2017-06-14 12:37:51 |
| 7840 | 3791 | 1 | 2017-06-14 12:38:21 |
| 7841 | 3793 | 1 | 2017-06-14 12:38:30 |
| 7842 | 3811 | 1 | 2017-06-14 12:39:38 |
| 7843 | 3788 | 1 | 2017-06-14 12:39:57 |
| 7844 | 3804 | 1 | 2017-06-14 12:40:02 |
| 7845 | 3785 | 1 | 2017-06-14 12:40:33 |
| 7846 | 3799 | 1 | 2017-06-14 12:42:07 |
| 7847 | 3978 | 3 | 2017-06-14 12:55:16 |
| 7848 | 3801 | 3 | 2017-06-14 12:59:44 |
| 7849 | 3796 | 3 | 2017-06-14 13:00:16 |
| 7850 | 3806 | 3 | 2017-06-14 13:04:54 |
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;