Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,976–8,000 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7976 | 4061 | 1 | 2017-06-24 12:31:19 |
| 7977 | 4061 | 3 | 2017-06-24 13:12:44 |
| 7978 | 4085 | 3 | 2017-06-24 13:19:41 |
| 7979 | 4086 | 3 | 2017-06-24 13:25:01 |
| 7980 | 4085 | 2 | 2017-06-24 14:01:46 |
| 7981 | 4086 | 2 | 2017-06-24 14:59:45 |
| 7982 | 4085 | 3 | 2017-06-24 15:18:05 |
| 7983 | 4085 | 2 | 2017-06-24 15:45:54 |
| 7984 | 4086 | 3 | 2017-06-24 16:13:11 |
| 7985 | 4086 | 2 | 2017-06-24 17:27:06 |
| 7986 | 4089 | 1 | 2017-06-25 11:47:12 |
| 7987 | 4090 | 1 | 2017-06-25 12:00:38 |
| 7988 | 4092 | 3 | 2017-06-25 13:43:20 |
| 7989 | 4091 | 3 | 2017-06-25 13:56:24 |
| 7990 | 4091 | 1 | 2017-06-25 14:22:43 |
| 7991 | 4081 | 3 | 2017-06-25 14:38:45 |
| 7992 | 4082 | 2 | 2017-06-25 14:43:10 |
| 7993 | 4092 | 1 | 2017-06-25 14:45:38 |
| 7994 | 4091 | 3 | 2017-06-25 14:53:48 |
| 7995 | 4094 | 2 | 2017-06-25 14:55:30 |
| 7996 | 4093 | 2 | 2017-06-25 14:58:11 |
| 7997 | 4095 | 2 | 2017-06-25 15:01:18 |
| 7998 | 4082 | 3 | 2017-06-25 15:22:17 |
| 7999 | 4081 | 1 | 2017-06-25 16:07:47 |
| 8000 | 4092 | 3 | 2017-06-25 16:08:24 |
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;