Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,201–7,225 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7201 | 3764 | 3 | 2017-04-14 11:57:58 |
| 7202 | 3749 | 3 | 2017-04-14 12:15:24 |
| 7203 | 3752 | 1 | 2017-04-14 12:38:33 |
| 7204 | 3765 | 1 | 2017-04-14 12:45:37 |
| 7205 | 3763 | 3 | 2017-04-14 12:46:48 |
| 7206 | 3751 | 3 | 2017-04-14 12:47:01 |
| 7207 | 3748 | 3 | 2017-04-14 12:59:26 |
| 7208 | 3750 | 3 | 2017-04-14 13:04:27 |
| 7209 | 3762 | 3 | 2017-04-14 13:08:06 |
| 7210 | 3753 | 2 | 2017-04-14 13:36:23 |
| 7211 | 3756 | 2 | 2017-04-14 13:37:54 |
| 7212 | 3754 | 2 | 2017-04-14 13:40:14 |
| 7213 | 3755 | 2 | 2017-04-14 13:41:11 |
| 7214 | 3753 | 1 | 2017-04-14 14:15:15 |
| 7215 | 3756 | 1 | 2017-04-14 14:48:01 |
| 7216 | 3754 | 1 | 2017-04-14 14:49:36 |
| 7217 | 3755 | 3 | 2017-04-14 15:06:17 |
| 7218 | 3771 | 2 | 2017-04-15 11:19:18 |
| 7219 | 3771 | 3 | 2017-04-15 11:48:27 |
| 7220 | 3720 | 2 | 2017-04-16 12:13:43 |
| 7221 | 3757 | 3 | 2017-04-18 09:35:38 |
| 7222 | 3757 | 1 | 2017-04-18 11:04:25 |
| 7223 | 3735 | 2 | 2017-04-18 12:53:33 |
| 7224 | 3736 | 2 | 2017-04-18 12:54:44 |
| 7225 | 3766 | 2 | 2017-04-19 10:04:43 |
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;