Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,076–15,100 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15076 | 7772 | 2 | 2019-03-12 16:33:29 |
| 15077 | 7771 | 2 | 2019-03-12 17:32:59 |
| 15078 | 7640 | 3 | 2019-03-13 09:32:37 |
| 15079 | 7642 | 2 | 2019-03-13 09:39:33 |
| 15080 | 7641 | 2 | 2019-03-13 09:43:14 |
| 15081 | 7643 | 2 | 2019-03-13 09:44:31 |
| 15082 | 7805 | 2 | 2019-03-14 12:05:30 |
| 15083 | 7806 | 2 | 2019-03-14 12:12:02 |
| 15084 | 7805 | 3 | 2019-03-14 13:20:51 |
| 15085 | 7806 | 3 | 2019-03-14 13:44:18 |
| 15086 | 7805 | 1 | 2019-03-14 13:47:09 |
| 15087 | 7806 | 1 | 2019-03-14 15:00:39 |
| 15088 | 7713 | 3 | 2019-03-15 09:21:07 |
| 15089 | 7714 | 2 | 2019-03-15 09:23:50 |
| 15090 | 7715 | 2 | 2019-03-15 09:24:12 |
| 15091 | 7714 | 3 | 2019-03-15 09:52:34 |
| 15092 | 7715 | 3 | 2019-03-15 10:01:15 |
| 15093 | 7714 | 1 | 2019-03-15 10:35:49 |
| 15094 | 7715 | 1 | 2019-03-15 11:02:59 |
| 15095 | 7487 | 3 | 2019-03-15 13:11:29 |
| 15096 | 7488 | 3 | 2019-03-15 13:13:58 |
| 15097 | 7477 | 3 | 2019-03-15 13:13:59 |
| 15098 | 7507 | 3 | 2019-03-15 13:14:40 |
| 15099 | 7483 | 3 | 2019-03-15 13:14:52 |
| 15100 | 7496 | 3 | 2019-03-15 13:15:28 |
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;