Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,926–10,950 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10926 | 5528 | 1 | 2018-05-02 14:11:34 |
| 10927 | 5677 | 3 | 2018-05-02 14:44:54 |
| 10928 | 5527 | 3 | 2018-05-02 14:48:41 |
| 10929 | 5528 | 3 | 2018-05-02 15:32:42 |
| 10930 | 5685 | 2 | 2018-05-04 09:47:32 |
| 10931 | 5092 | 2 | 2018-05-04 12:30:06 |
| 10932 | 5077 | 2 | 2018-05-04 12:31:04 |
| 10933 | 5067 | 2 | 2018-05-04 12:31:10 |
| 10934 | 5075 | 2 | 2018-05-04 12:31:49 |
| 10935 | 5119 | 2 | 2018-05-04 12:33:06 |
| 10936 | 5102 | 2 | 2018-05-04 12:33:31 |
| 10937 | 5069 | 2 | 2018-05-04 12:34:16 |
| 10938 | 5070 | 2 | 2018-05-04 12:35:01 |
| 10939 | 5084 | 2 | 2018-05-04 12:35:05 |
| 10940 | 5121 | 2 | 2018-05-04 12:35:22 |
| 10941 | 5080 | 2 | 2018-05-04 12:35:54 |
| 10942 | 5088 | 2 | 2018-05-04 12:35:56 |
| 10943 | 5079 | 2 | 2018-05-04 12:36:10 |
| 10944 | 5114 | 2 | 2018-05-04 12:36:26 |
| 10945 | 5087 | 2 | 2018-05-04 12:36:34 |
| 10946 | 5089 | 2 | 2018-05-04 12:36:46 |
| 10947 | 5096 | 2 | 2018-05-04 12:36:47 |
| 10948 | 5073 | 2 | 2018-05-04 12:37:14 |
| 10949 | 5101 | 2 | 2018-05-04 12:37:20 |
| 10950 | 5086 | 2 | 2018-05-04 12:37:40 |
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;