Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,576–13,600 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13576 | 6698 | 3 | 2018-10-25 14:31:26 |
| 13577 | 6697 | 2 | 2018-10-25 14:41:07 |
| 13578 | 6697 | 1 | 2018-10-25 15:10:42 |
| 13579 | 6699 | 1 | 2018-10-25 15:54:31 |
| 13580 | 6698 | 1 | 2018-10-25 15:57:47 |
| 13581 | 6697 | 2 | 2018-10-25 16:16:41 |
| 13582 | 6699 | 2 | 2018-10-25 16:55:17 |
| 13583 | 6697 | 3 | 2018-10-25 17:19:25 |
| 13584 | 6914 | 2 | 2018-10-26 10:04:38 |
| 13585 | 6912 | 2 | 2018-10-26 10:06:09 |
| 13586 | 6915 | 2 | 2018-10-26 10:06:16 |
| 13587 | 6913 | 2 | 2018-10-26 10:12:00 |
| 13588 | 6915 | 1 | 2018-10-26 10:53:24 |
| 13589 | 6914 | 3 | 2018-10-26 10:58:12 |
| 13590 | 6913 | 1 | 2018-10-26 11:00:41 |
| 13591 | 6912 | 1 | 2018-10-26 11:24:15 |
| 13592 | 6916 | 1 | 2018-10-26 14:38:20 |
| 13593 | 6918 | 3 | 2018-10-26 15:20:58 |
| 13594 | 6919 | 3 | 2018-10-26 15:22:04 |
| 13595 | 6920 | 2 | 2018-10-26 15:24:30 |
| 13596 | 6917 | 3 | 2018-10-26 15:25:14 |
| 13597 | 6920 | 3 | 2018-10-26 16:01:51 |
| 13598 | 6919 | 2 | 2018-10-26 16:23:23 |
| 13599 | 6918 | 2 | 2018-10-26 16:53:03 |
| 13600 | 6917 | 2 | 2018-10-26 16:54:09 |
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;