Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,901–7,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7901 | 3995 | 3 | 2017-06-15 13:39:10 |
| 7902 | 3996 | 3 | 2017-06-15 13:45:06 |
| 7903 | 3998 | 3 | 2017-06-15 13:54:13 |
| 7904 | 3997 | 3 | 2017-06-15 14:09:05 |
| 7905 | 3994 | 2 | 2017-06-15 14:36:40 |
| 7906 | 3998 | 2 | 2017-06-15 14:55:33 |
| 7907 | 3995 | 2 | 2017-06-15 15:01:06 |
| 7908 | 3994 | 3 | 2017-06-15 15:09:49 |
| 7909 | 3996 | 2 | 2017-06-15 15:20:05 |
| 7910 | 3997 | 2 | 2017-06-15 15:23:49 |
| 7911 | 3998 | 3 | 2017-06-15 16:17:54 |
| 7912 | 3996 | 3 | 2017-06-15 16:20:44 |
| 7913 | 3995 | 3 | 2017-06-15 16:33:27 |
| 7914 | 3997 | 3 | 2017-06-15 16:50:10 |
| 7915 | 3926 | 2 | 2017-06-16 09:31:53 |
| 7916 | 3927 | 1 | 2017-06-16 09:31:56 |
| 7917 | 3928 | 2 | 2017-06-16 09:32:11 |
| 7918 | 3927 | 3 | 2017-06-16 10:08:37 |
| 7919 | 3928 | 3 | 2017-06-16 10:37:17 |
| 7920 | 3926 | 3 | 2017-06-16 11:00:12 |
| 7921 | 3927 | 1 | 2017-06-16 11:00:30 |
| 7922 | 3928 | 2 | 2017-06-16 11:13:22 |
| 7923 | 3926 | 2 | 2017-06-16 11:35:41 |
| 7924 | 4050 | 2 | 2017-06-16 11:40:32 |
| 7925 | 4049 | 2 | 2017-06-16 11:43:25 |
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;