Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,776–13,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13776 | 7064 | 2 | 2018-11-15 11:58:59 |
| 13777 | 7059 | 3 | 2018-11-15 12:11:53 |
| 13778 | 7058 | 3 | 2018-11-15 12:21:01 |
| 13779 | 7064 | 1 | 2018-11-15 12:34:53 |
| 13780 | 7066 | 3 | 2018-11-15 13:04:48 |
| 13781 | 7059 | 2 | 2018-11-15 13:06:28 |
| 13782 | 7065 | 1 | 2018-11-15 13:09:57 |
| 13783 | 7066 | 2 | 2018-11-15 14:10:22 |
| 13784 | 7059 | 3 | 2018-11-15 14:19:04 |
| 13785 | 7059 | 2 | 2018-11-15 14:46:10 |
| 13786 | 7047 | 2 | 2018-11-15 16:16:11 |
| 13787 | 7047 | 3 | 2018-11-15 17:27:38 |
| 13788 | 7070 | 2 | 2018-11-16 11:08:55 |
| 13789 | 7069 | 1 | 2018-11-16 11:15:19 |
| 13790 | 7068 | 2 | 2018-11-16 11:19:52 |
| 13791 | 7068 | 3 | 2018-11-16 11:54:50 |
| 13792 | 7070 | 3 | 2018-11-16 12:15:28 |
| 13793 | 7069 | 3 | 2018-11-16 12:46:17 |
| 13794 | 7069 | 1 | 2018-11-16 14:14:07 |
| 13795 | 7044 | 2 | 2018-11-16 15:46:50 |
| 13796 | 7045 | 2 | 2018-11-16 15:52:34 |
| 13797 | 7046 | 2 | 2018-11-16 15:52:49 |
| 13798 | 7043 | 2 | 2018-11-16 16:00:43 |
| 13799 | 7046 | 3 | 2018-11-16 16:51:25 |
| 13800 | 7045 | 3 | 2018-11-16 17:04:36 |
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;