Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 14,901–14,925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 14901 | 7104 | 2 | 2019-02-27 13:12:20 |
| 14902 | 7140 | 2 | 2019-02-27 13:13:54 |
| 14903 | 7127 | 2 | 2019-02-27 13:14:01 |
| 14904 | 7101 | 2 | 2019-02-27 13:14:10 |
| 14905 | 7124 | 2 | 2019-02-27 13:14:11 |
| 14906 | 7108 | 2 | 2019-02-27 13:14:17 |
| 14907 | 7116 | 2 | 2019-02-27 13:14:21 |
| 14908 | 7099 | 2 | 2019-02-27 13:15:22 |
| 14909 | 7136 | 2 | 2019-02-27 13:16:06 |
| 14910 | 7133 | 2 | 2019-02-27 13:16:27 |
| 14911 | 7132 | 2 | 2019-02-27 13:17:16 |
| 14912 | 7141 | 2 | 2019-02-27 13:17:59 |
| 14913 | 7134 | 2 | 2019-02-27 13:18:24 |
| 14914 | 7137 | 2 | 2019-02-27 13:18:31 |
| 14915 | 7131 | 2 | 2019-02-27 13:18:52 |
| 14916 | 7138 | 2 | 2019-02-27 13:19:55 |
| 14917 | 7129 | 2 | 2019-02-27 13:21:18 |
| 14918 | 7125 | 2 | 2019-02-27 13:22:00 |
| 14919 | 7126 | 2 | 2019-02-27 13:22:02 |
| 14920 | 7142 | 2 | 2019-02-27 13:22:14 |
| 14921 | 7623 | 2 | 2019-02-28 11:44:53 |
| 14922 | 7622 | 2 | 2019-02-28 11:47:53 |
| 14923 | 7623 | 3 | 2019-02-28 12:16:56 |
| 14924 | 7622 | 3 | 2019-02-28 12:36:52 |
| 14925 | 7623 | 1 | 2019-02-28 13:08:22 |
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;