Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 11,876–11,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 11876 | 5987 | 1 | 2018-07-17 11:13:41 |
| 11877 | 5971 | 1 | 2018-07-17 11:13:52 |
| 11878 | 5989 | 1 | 2018-07-17 11:14:37 |
| 11879 | 5991 | 1 | 2018-07-17 11:14:52 |
| 11880 | 5988 | 3 | 2018-07-17 11:15:06 |
| 11881 | 6010 | 1 | 2018-07-17 11:15:55 |
| 11882 | 6000 | 1 | 2018-07-17 11:17:51 |
| 11883 | 6005 | 1 | 2018-07-17 11:18:21 |
| 11884 | 5993 | 1 | 2018-07-17 11:19:29 |
| 11885 | 5973 | 3 | 2018-07-17 11:23:47 |
| 11886 | 5998 | 1 | 2018-07-17 11:25:13 |
| 11887 | 6009 | 3 | 2018-07-17 11:25:22 |
| 11888 | 6003 | 1 | 2018-07-17 11:27:15 |
| 11889 | 6011 | 3 | 2018-07-17 11:27:33 |
| 11890 | 5997 | 1 | 2018-07-17 11:27:46 |
| 11891 | 6001 | 1 | 2018-07-17 11:29:38 |
| 11892 | 6004 | 1 | 2018-07-17 11:30:17 |
| 11893 | 6002 | 1 | 2018-07-17 11:31:12 |
| 11894 | 5986 | 1 | 2018-07-17 11:32:24 |
| 11895 | 5960 | 1 | 2018-07-17 11:32:46 |
| 11896 | 5977 | 1 | 2018-07-17 11:33:11 |
| 11897 | 5967 | 3 | 2018-07-17 11:33:33 |
| 11898 | 6013 | 1 | 2018-07-17 11:33:33 |
| 11899 | 5976 | 1 | 2018-07-17 11:33:51 |
| 11900 | 5994 | 1 | 2018-07-17 11:34:36 |
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;