Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 901–925 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 901 | 147 | 3 | 2015-05-28 11:14:12 |
| 902 | 132 | 3 | 2015-05-28 11:14:24 |
| 903 | 125 | 3 | 2015-05-28 11:15:48 |
| 904 | 151 | 3 | 2015-05-28 11:18:12 |
| 905 | 136 | 3 | 2015-05-28 11:19:25 |
| 906 | 143 | 3 | 2015-05-28 11:19:46 |
| 907 | 148 | 3 | 2015-05-28 11:22:56 |
| 908 | 133 | 3 | 2015-05-28 11:25:58 |
| 909 | 124 | 3 | 2015-05-28 11:26:02 |
| 910 | 502 | 2 | 2015-05-28 11:26:37 |
| 911 | 123 | 3 | 2015-05-28 11:27:37 |
| 912 | 113 | 3 | 2015-05-28 11:28:09 |
| 913 | 140 | 2 | 2015-05-28 11:28:25 |
| 914 | 127 | 3 | 2015-05-28 11:30:34 |
| 915 | 141 | 3 | 2015-05-28 11:34:32 |
| 916 | 131 | 3 | 2015-05-28 11:34:36 |
| 917 | 130 | 3 | 2015-05-28 11:35:15 |
| 918 | 145 | 3 | 2015-05-28 11:36:28 |
| 919 | 156 | 3 | 2015-05-28 11:41:45 |
| 920 | 138 | 2 | 2015-05-28 11:42:54 |
| 921 | 115 | 2 | 2015-05-28 11:45:41 |
| 922 | 143 | 2 | 2015-05-28 11:47:31 |
| 923 | 154 | 3 | 2015-05-28 11:49:11 |
| 924 | 135 | 3 | 2015-05-28 11:51:32 |
| 925 | 129 | 3 | 2015-05-28 11:52:46 |
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;