Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 4,801–4,825 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 4801 | 1945 | 3 | 2016-07-01 16:42:43 |
| 4802 | 1929 | 3 | 2016-07-01 16:44:02 |
| 4803 | 1916 | 3 | 2016-07-01 16:46:32 |
| 4804 | 1947 | 3 | 2016-07-01 16:46:37 |
| 4805 | 2440 | 3 | 2016-07-01 16:52:14 |
| 4806 | 1935 | 3 | 2016-07-01 16:52:32 |
| 4807 | 1936 | 3 | 2016-07-01 16:54:41 |
| 4808 | 2397 | 3 | 2016-07-01 16:59:15 |
| 4809 | 1907 | 3 | 2016-07-01 17:05:51 |
| 4810 | 1917 | 3 | 2016-07-01 17:09:04 |
| 4811 | 2440 | 1 | 2016-07-01 17:33:17 |
| 4812 | 2401 | 2 | 2016-07-02 10:13:53 |
| 4813 | 2403 | 2 | 2016-07-02 10:17:35 |
| 4814 | 2402 | 2 | 2016-07-02 10:18:00 |
| 4815 | 2404 | 2 | 2016-07-02 10:21:23 |
| 4816 | 2441 | 1 | 2016-07-02 10:39:53 |
| 4817 | 2442 | 1 | 2016-07-02 10:45:50 |
| 4818 | 2444 | 3 | 2016-07-02 10:50:22 |
| 4819 | 2443 | 3 | 2016-07-02 11:00:11 |
| 4820 | 2402 | 1 | 2016-07-02 11:17:11 |
| 4821 | 2441 | 3 | 2016-07-02 11:27:11 |
| 4822 | 2443 | 1 | 2016-07-02 11:38:07 |
| 4823 | 2442 | 3 | 2016-07-02 11:53:57 |
| 4824 | 2443 | 2 | 2016-07-02 12:09:20 |
| 4825 | 2444 | 1 | 2016-07-02 12:22:45 |
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;