Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 5,976–6,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 5976 | 3038 | 1 | 2016-11-20 14:51:14 |
| 5977 | 3037 | 3 | 2016-11-20 15:26:47 |
| 5978 | 3039 | 3 | 2016-11-20 15:49:28 |
| 5979 | 3037 | 2 | 2016-11-20 16:30:06 |
| 5980 | 3041 | 2 | 2016-11-21 14:51:33 |
| 5981 | 3040 | 2 | 2016-11-21 14:53:49 |
| 5982 | 3042 | 1 | 2016-11-21 15:08:15 |
| 5983 | 3042 | 3 | 2016-11-21 15:52:26 |
| 5984 | 3041 | 3 | 2016-11-21 16:01:14 |
| 5985 | 3040 | 3 | 2016-11-21 16:19:19 |
| 5986 | 3045 | 3 | 2016-11-22 14:27:03 |
| 5987 | 3046 | 3 | 2016-11-22 14:33:37 |
| 5988 | 3043 | 3 | 2016-11-22 14:34:35 |
| 5989 | 3044 | 1 | 2016-11-22 14:39:30 |
| 5990 | 3046 | 2 | 2016-11-22 15:04:52 |
| 5991 | 3044 | 2 | 2016-11-22 15:06:04 |
| 5992 | 3045 | 2 | 2016-11-22 15:08:05 |
| 5993 | 3043 | 2 | 2016-11-22 15:43:26 |
| 5994 | 3046 | 3 | 2016-11-22 16:29:07 |
| 5995 | 3045 | 3 | 2016-11-22 16:34:45 |
| 5996 | 3043 | 3 | 2016-11-22 16:53:58 |
| 5997 | 3030 | 2 | 2016-11-23 10:12:54 |
| 5998 | 3028 | 2 | 2016-11-23 10:14:59 |
| 5999 | 3029 | 2 | 2016-11-23 10:26:09 |
| 6000 | 3047 | 2 | 2016-11-23 10:29: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;