Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 19,076–19,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 19076 | 9612 | 1 | 2020-01-01 10:21:24 |
| 19077 | 9610 | 3 | 2020-01-01 10:36:28 |
| 19078 | 9611 | 2 | 2020-01-01 10:53:55 |
| 19079 | 9612 | 3 | 2020-01-01 11:07:37 |
| 19080 | 9611 | 3 | 2020-01-01 11:19:35 |
| 19081 | 9613 | 3 | 2020-01-01 11:25:57 |
| 19082 | 9629 | 2 | 2020-01-01 11:26:50 |
| 19083 | 9609 | 3 | 2020-01-01 11:29:56 |
| 19084 | 9628 | 1 | 2020-01-01 11:36:06 |
| 19085 | 9611 | 2 | 2020-01-01 11:45:45 |
| 19086 | 9629 | 1 | 2020-01-01 12:38:53 |
| 19087 | 9628 | 3 | 2020-01-01 12:50:04 |
| 19088 | 9629 | 3 | 2020-01-01 13:46:33 |
| 19089 | 9591 | 2 | 2020-01-01 13:57:13 |
| 19090 | 9628 | 1 | 2020-01-01 13:58:22 |
| 19091 | 9592 | 2 | 2020-01-01 14:09:51 |
| 19092 | 9591 | 1 | 2020-01-01 14:41:46 |
| 19093 | 9628 | 2 | 2020-01-01 14:55:25 |
| 19094 | 9592 | 3 | 2020-01-01 15:08:38 |
| 19095 | 9591 | 3 | 2020-01-01 15:18:14 |
| 19096 | 9628 | 1 | 2020-01-01 16:10:52 |
| 19097 | 9631 | 2 | 2020-01-02 14:40:22 |
| 19098 | 9630 | 2 | 2020-01-02 14:43:17 |
| 19099 | 9631 | 3 | 2020-01-02 15:39:31 |
| 19100 | 9630 | 3 | 2020-01-02 15:56: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;