Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 10,901–10,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 10901 | 5659 | 2 | 2018-04-30 11:25:27 |
| 10902 | 5644 | 2 | 2018-04-30 12:29:44 |
| 10903 | 5643 | 2 | 2018-04-30 12:30:30 |
| 10904 | 5660 | 3 | 2018-04-30 12:36:39 |
| 10905 | 5642 | 2 | 2018-04-30 12:46:46 |
| 10906 | 5659 | 3 | 2018-04-30 12:52:21 |
| 10907 | 5644 | 1 | 2018-04-30 13:06:01 |
| 10908 | 5643 | 1 | 2018-04-30 13:27:17 |
| 10909 | 5642 | 1 | 2018-04-30 13:39:49 |
| 10910 | 5673 | 2 | 2018-05-01 11:27:44 |
| 10911 | 5676 | 2 | 2018-05-02 10:37:04 |
| 10912 | 5676 | 3 | 2018-05-02 11:39:13 |
| 10913 | 5531 | 2 | 2018-05-02 11:45:43 |
| 10914 | 5569 | 2 | 2018-05-02 11:47:01 |
| 10915 | 5529 | 1 | 2018-05-02 11:49:48 |
| 10916 | 5530 | 2 | 2018-05-02 11:53:29 |
| 10917 | 5527 | 1 | 2018-05-02 11:57:35 |
| 10918 | 5528 | 1 | 2018-05-02 11:58:56 |
| 10919 | 5676 | 2 | 2018-05-02 12:16:52 |
| 10920 | 5531 | 3 | 2018-05-02 12:33:40 |
| 10921 | 5527 | 3 | 2018-05-02 12:39:31 |
| 10922 | 5529 | 2 | 2018-05-02 12:51:44 |
| 10923 | 5530 | 1 | 2018-05-02 12:52:57 |
| 10924 | 5528 | 3 | 2018-05-02 13:08:18 |
| 10925 | 5527 | 1 | 2018-05-02 13:47:53 |
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;