Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 15,676–15,700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 15676 | 7842 | 2 | 2019-04-15 13:47:06 |
| 15677 | 7862 | 2 | 2019-04-15 13:48:49 |
| 15678 | 7851 | 2 | 2019-04-15 13:49:20 |
| 15679 | 7830 | 2 | 2019-04-15 13:50:29 |
| 15680 | 7873 | 2 | 2019-04-15 13:54:33 |
| 15681 | 7846 | 2 | 2019-04-15 13:55:43 |
| 15682 | 7845 | 2 | 2019-04-15 13:57:40 |
| 15683 | 7828 | 2 | 2019-04-15 13:57:53 |
| 15684 | 7855 | 2 | 2019-04-15 14:01:52 |
| 15685 | 7993 | 2 | 2019-04-16 09:32:31 |
| 15686 | 7992 | 2 | 2019-04-16 09:39:00 |
| 15687 | 8084 | 3 | 2019-04-16 09:42:33 |
| 15688 | 8083 | 1 | 2019-04-16 09:47:23 |
| 15689 | 7993 | 3 | 2019-04-16 10:18:19 |
| 15690 | 8084 | 1 | 2019-04-16 10:27:56 |
| 15691 | 7992 | 3 | 2019-04-16 10:31:04 |
| 15692 | 7993 | 1 | 2019-04-16 10:45:51 |
| 15693 | 8084 | 3 | 2019-04-16 11:03:11 |
| 15694 | 7992 | 1 | 2019-04-16 11:09:21 |
| 15695 | 7992 | 3 | 2019-04-16 11:52:21 |
| 15696 | 7993 | 3 | 2019-04-16 12:15:17 |
| 15697 | 8065 | 2 | 2019-04-16 15:24:38 |
| 15698 | 8066 | 1 | 2019-04-16 15:33:18 |
| 15699 | 8064 | 2 | 2019-04-16 15:35:25 |
| 15700 | 8063 | 2 | 2019-04-16 15:36: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;