Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,151–13,175 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13151 | 6692 | 2 | 2018-09-23 16:41:28 |
| 13152 | 6752 | 2 | 2018-09-24 14:00:08 |
| 13153 | 6752 | 1 | 2018-09-24 15:09:12 |
| 13154 | 6752 | 3 | 2018-09-24 16:30:13 |
| 13155 | 6757 | 1 | 2018-09-25 10:47:41 |
| 13156 | 6755 | 3 | 2018-09-25 10:50:35 |
| 13157 | 6756 | 1 | 2018-09-25 10:51:24 |
| 13158 | 6758 | 1 | 2018-09-25 10:58:28 |
| 13159 | 6759 | 1 | 2018-09-25 11:00:22 |
| 13160 | 6742 | 2 | 2018-09-25 11:04:04 |
| 13161 | 6743 | 2 | 2018-09-25 11:14:14 |
| 13162 | 6756 | 3 | 2018-09-25 11:22:51 |
| 13163 | 6757 | 3 | 2018-09-25 11:32:30 |
| 13164 | 6758 | 3 | 2018-09-25 11:36:16 |
| 13165 | 6755 | 2 | 2018-09-25 11:46:52 |
| 13166 | 6743 | 3 | 2018-09-25 12:05:08 |
| 13167 | 6759 | 3 | 2018-09-25 12:05:11 |
| 13168 | 6742 | 3 | 2018-09-25 12:14:12 |
| 13169 | 6760 | 3 | 2018-09-25 13:02:19 |
| 13170 | 6760 | 1 | 2018-09-25 14:27:48 |
| 13171 | 6762 | 1 | 2018-09-25 15:04:52 |
| 13172 | 6761 | 2 | 2018-09-25 15:05:22 |
| 13173 | 6760 | 2 | 2018-09-25 15:06:43 |
| 13174 | 6761 | 1 | 2018-09-25 16:24:44 |
| 13175 | 6768 | 2 | 2018-09-26 09:06:19 |
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;