Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,726–15,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15726 | 7661 | 1 | 2019-04-19 13:25:02 |
| 15727 | 7667 | 1 | 2019-04-19 13:25:05 |
| 15728 | 7670 | 1 | 2019-04-19 13:25:48 |
| 15729 | 7663 | 1 | 2019-04-19 13:26:05 |
| 15730 | 7681 | 1 | 2019-04-19 13:26:05 |
| 15731 | 7683 | 1 | 2019-04-19 13:26:07 |
| 15732 | 7682 | 1 | 2019-04-19 13:26:24 |
| 15733 | 7668 | 1 | 2019-04-19 13:27:34 |
| 15734 | 7689 | 1 | 2019-04-19 13:27:34 |
| 15735 | 7709 | 1 | 2019-04-19 13:27:49 |
| 15736 | 7708 | 1 | 2019-04-19 13:28:04 |
| 15737 | 7680 | 1 | 2019-04-19 13:28:05 |
| 15738 | 7706 | 1 | 2019-04-19 13:28:36 |
| 15739 | 7675 | 1 | 2019-04-19 13:28:37 |
| 15740 | 7676 | 1 | 2019-04-19 13:29:17 |
| 15741 | 7692 | 1 | 2019-04-19 13:29:59 |
| 15742 | 7704 | 1 | 2019-04-19 13:30:39 |
| 15743 | 7686 | 1 | 2019-04-19 13:31:00 |
| 15744 | 7677 | 1 | 2019-04-19 13:32:51 |
| 15745 | 7693 | 1 | 2019-04-19 13:32:57 |
| 15746 | 8096 | 1 | 2019-04-19 13:33:00 |
| 15747 | 7711 | 1 | 2019-04-19 13:33:15 |
| 15748 | 7696 | 1 | 2019-04-19 13:34:59 |
| 15749 | 7699 | 1 | 2019-04-19 13:35:03 |
| 15750 | 7705 | 1 | 2019-04-19 13:35:07 |
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;