Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 13,826–13,850 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 13826 | 7071 | 1 | 2018-11-19 14:45:05 |
| 13827 | 6905 | 2 | 2018-11-19 14:47:03 |
| 13828 | 7076 | 2 | 2018-11-19 14:58:13 |
| 13829 | 6902 | 2 | 2018-11-19 14:58:52 |
| 13830 | 7078 | 2 | 2018-11-19 14:59:28 |
| 13831 | 7077 | 2 | 2018-11-19 15:04:06 |
| 13832 | 7079 | 2 | 2018-11-19 15:06:58 |
| 13833 | 7076 | 3 | 2018-11-19 15:34:16 |
| 13834 | 7078 | 3 | 2018-11-19 15:46:01 |
| 13835 | 7079 | 3 | 2018-11-19 15:57:51 |
| 13836 | 7076 | 2 | 2018-11-19 16:26:38 |
| 13837 | 7077 | 3 | 2018-11-19 16:27:10 |
| 13838 | 7078 | 2 | 2018-11-19 16:38:13 |
| 13839 | 7076 | 1 | 2018-11-19 16:53:37 |
| 13840 | 7078 | 1 | 2018-11-19 17:14:05 |
| 13841 | 7079 | 2 | 2018-11-19 17:25:37 |
| 13842 | 7082 | 2 | 2018-11-21 13:18:32 |
| 13843 | 7081 | 2 | 2018-11-21 13:20:02 |
| 13844 | 7012 | 2 | 2018-11-21 14:20:51 |
| 13845 | 7011 | 2 | 2018-11-21 14:25:14 |
| 13846 | 7013 | 2 | 2018-11-21 14:26:13 |
| 13847 | 7084 | 3 | 2018-11-21 14:59:37 |
| 13848 | 7013 | 1 | 2018-11-21 15:01:16 |
| 13849 | 7011 | 1 | 2018-11-21 15:05:32 |
| 13850 | 7012 | 1 | 2018-11-21 15:39:38 |
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;