Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 9,776–9,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 9776 | 4987 | 1 | 2017-12-24 14:13:30 |
| 9777 | 4986 | 1 | 2017-12-24 14:31:28 |
| 9778 | 4975 | 3 | 2017-12-24 14:41:20 |
| 9779 | 4971 | 1 | 2017-12-24 14:56:37 |
| 9780 | 4974 | 3 | 2017-12-24 15:08:54 |
| 9781 | 4975 | 1 | 2017-12-24 15:10:41 |
| 9782 | 4978 | 3 | 2017-12-24 15:15:02 |
| 9783 | 4976 | 3 | 2017-12-24 15:20:29 |
| 9784 | 4971 | 3 | 2017-12-24 15:25:38 |
| 9785 | 4977 | 3 | 2017-12-24 15:27:29 |
| 9786 | 4978 | 1 | 2017-12-24 16:12:45 |
| 9787 | 4974 | 1 | 2017-12-24 16:27:51 |
| 9788 | 4976 | 1 | 2017-12-24 16:31:29 |
| 9789 | 4977 | 1 | 2017-12-24 16:32:19 |
| 9790 | 4991 | 2 | 2017-12-25 16:02:58 |
| 9791 | 4990 | 2 | 2017-12-25 16:08:36 |
| 9792 | 4990 | 3 | 2017-12-25 16:48:20 |
| 9793 | 4991 | 3 | 2017-12-25 17:18:09 |
| 9794 | 4990 | 1 | 2017-12-25 17:47:47 |
| 9795 | 5033 | 1 | 2017-12-27 10:30:47 |
| 9796 | 5032 | 1 | 2017-12-27 10:31:20 |
| 9797 | 5032 | 2 | 2017-12-27 11:11:53 |
| 9798 | 5033 | 2 | 2017-12-27 11:16:22 |
| 9799 | 5034 | 1 | 2017-12-28 14:06:14 |
| 9800 | 5034 | 2 | 2017-12-28 14:43:46 |
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;