Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,126–1,150 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1126 | 692 | 2 | 2015-06-19 10:54:59 |
| 1127 | 693 | 1 | 2015-06-19 11:06:52 |
| 1128 | 694 | 1 | 2015-06-19 11:10:43 |
| 1129 | 692 | 1 | 2015-06-19 12:15:35 |
| 1130 | 693 | 2 | 2015-06-19 12:34:51 |
| 1131 | 694 | 2 | 2015-06-19 12:39:05 |
| 1132 | 693 | 3 | 2015-06-19 13:10:08 |
| 1133 | 694 | 3 | 2015-06-19 13:30:41 |
| 1134 | 695 | 2 | 2015-06-20 10:29:26 |
| 1135 | 696 | 2 | 2015-06-20 10:30:00 |
| 1136 | 702 | 2 | 2015-06-21 12:47:20 |
| 1137 | 703 | 2 | 2015-06-21 12:52:07 |
| 1138 | 704 | 2 | 2015-06-21 12:56:43 |
| 1139 | 705 | 3 | 2015-06-22 10:42:26 |
| 1140 | 712 | 2 | 2015-06-23 09:57:35 |
| 1141 | 713 | 2 | 2015-06-23 10:05:02 |
| 1142 | 681 | 2 | 2015-06-23 10:19:07 |
| 1143 | 683 | 2 | 2015-06-23 10:20:33 |
| 1144 | 682 | 2 | 2015-06-23 10:31:39 |
| 1145 | 714 | 2 | 2015-06-23 11:21:04 |
| 1146 | 681 | 3 | 2015-06-23 11:36:09 |
| 1147 | 683 | 3 | 2015-06-23 11:47:57 |
| 1148 | 682 | 3 | 2015-06-23 11:51:39 |
| 1149 | 681 | 1 | 2015-06-23 12:06:30 |
| 1150 | 682 | 1 | 2015-06-23 13:08:48 |
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;