Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,851–7,875 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7851 | 3798 | 3 | 2017-06-14 13:05:13 |
| 7852 | 3811 | 3 | 2017-06-14 13:10:37 |
| 7853 | 4047 | 3 | 2017-06-14 13:10:45 |
| 7854 | 3808 | 3 | 2017-06-14 13:13:19 |
| 7855 | 3960 | 1 | 2017-06-14 13:14:49 |
| 7856 | 3804 | 3 | 2017-06-14 13:20:12 |
| 7857 | 3790 | 3 | 2017-06-14 13:22:07 |
| 7858 | 3810 | 3 | 2017-06-14 13:24:14 |
| 7859 | 3979 | 3 | 2017-06-14 13:27:50 |
| 7860 | 3803 | 3 | 2017-06-14 13:30:00 |
| 7861 | 3807 | 3 | 2017-06-14 13:31:18 |
| 7862 | 3798 | 2 | 2017-06-14 13:34:39 |
| 7863 | 3796 | 2 | 2017-06-14 13:38:22 |
| 7864 | 3960 | 3 | 2017-06-14 13:41:55 |
| 7865 | 3784 | 3 | 2017-06-14 13:48:07 |
| 7866 | 3791 | 3 | 2017-06-14 13:48:59 |
| 7867 | 3799 | 3 | 2017-06-14 13:49:12 |
| 7868 | 3795 | 3 | 2017-06-14 13:53:32 |
| 7869 | 3978 | 2 | 2017-06-14 13:56:00 |
| 7870 | 3785 | 3 | 2017-06-14 14:01:18 |
| 7871 | 3783 | 3 | 2017-06-14 14:03:17 |
| 7872 | 3808 | 2 | 2017-06-14 14:04:28 |
| 7873 | 3788 | 3 | 2017-06-14 14:04:48 |
| 7874 | 3793 | 3 | 2017-06-14 14:05:28 |
| 7875 | 3810 | 2 | 2017-06-14 14:07:41 |
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;