Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 7,876–7,900 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 7876 | 3979 | 2 | 2017-06-14 14:09:48 |
| 7877 | 3803 | 2 | 2017-06-14 14:22:23 |
| 7878 | 3811 | 2 | 2017-06-14 14:23:58 |
| 7879 | 3807 | 2 | 2017-06-14 14:24:44 |
| 7880 | 3806 | 2 | 2017-06-14 14:27:45 |
| 7881 | 3784 | 2 | 2017-06-14 14:29:06 |
| 7882 | 3790 | 2 | 2017-06-14 14:29:42 |
| 7883 | 3801 | 2 | 2017-06-14 14:35:25 |
| 7884 | 3793 | 2 | 2017-06-14 14:36:11 |
| 7885 | 3788 | 2 | 2017-06-14 14:37:40 |
| 7886 | 4047 | 2 | 2017-06-14 14:42:31 |
| 7887 | 3783 | 2 | 2017-06-14 14:45:51 |
| 7888 | 3804 | 2 | 2017-06-14 14:48:58 |
| 7889 | 3795 | 2 | 2017-06-14 14:53:41 |
| 7890 | 3791 | 2 | 2017-06-14 14:55:19 |
| 7891 | 3799 | 2 | 2017-06-14 14:56:20 |
| 7892 | 3785 | 2 | 2017-06-14 15:26:02 |
| 7893 | 4047 | 3 | 2017-06-14 15:43:25 |
| 7894 | 4047 | 2 | 2017-06-14 16:37:10 |
| 7895 | 3996 | 1 | 2017-06-15 12:33:26 |
| 7896 | 3997 | 1 | 2017-06-15 12:34:07 |
| 7897 | 3995 | 1 | 2017-06-15 12:36:23 |
| 7898 | 3994 | 1 | 2017-06-15 12:41:25 |
| 7899 | 3998 | 1 | 2017-06-15 12:44:32 |
| 7900 | 3994 | 3 | 2017-06-15 13:10:13 |
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;