Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 3,076–3,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 3076 | 1579 | 3 | 2015-12-11 15:14:37 |
| 3077 | 1579 | 2 | 2015-12-11 15:51:01 |
| 3078 | 1578 | 2 | 2015-12-11 16:09:23 |
| 3079 | 1580 | 2 | 2015-12-12 09:48:53 |
| 3080 | 1581 | 2 | 2015-12-12 15:26:28 |
| 3081 | 1581 | 1 | 2015-12-12 16:56:41 |
| 3082 | 1582 | 2 | 2015-12-13 16:34:12 |
| 3083 | 1582 | 3 | 2015-12-13 17:36:47 |
| 3084 | 1589 | 1 | 2015-12-15 10:47:55 |
| 3085 | 1588 | 1 | 2015-12-15 10:50:14 |
| 3086 | 1587 | 3 | 2015-12-15 10:53:21 |
| 3087 | 1586 | 2 | 2015-12-15 10:59:41 |
| 3088 | 1586 | 3 | 2015-12-15 11:55:07 |
| 3089 | 1574 | 2 | 2015-12-15 12:53:06 |
| 3090 | 1574 | 3 | 2015-12-15 13:58:07 |
| 3091 | 1574 | 2 | 2015-12-15 14:53:01 |
| 3092 | 1540 | 2 | 2015-12-16 16:05:06 |
| 3093 | 1540 | 1 | 2015-12-16 17:04:36 |
| 3094 | 1540 | 3 | 2015-12-16 17:33:13 |
| 3095 | 1593 | 3 | 2015-12-17 09:12:37 |
| 3096 | 1592 | 3 | 2015-12-17 09:22:36 |
| 3097 | 1591 | 3 | 2015-12-17 09:23:20 |
| 3098 | 1592 | 2 | 2015-12-17 10:23:10 |
| 3099 | 1593 | 2 | 2015-12-17 10:29:22 |
| 3100 | 1591 | 2 | 2015-12-17 10:59:05 |
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;