Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 18,726–18,750 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 18726 | 8995 | 1 | 2019-12-15 13:29:00 |
| 18727 | 8988 | 1 | 2019-12-15 13:33:02 |
| 18728 | 8994 | 1 | 2019-12-15 13:33:07 |
| 18729 | 8980 | 1 | 2019-12-15 13:33:08 |
| 18730 | 8965 | 1 | 2019-12-15 13:34:13 |
| 18731 | 8973 | 1 | 2019-12-15 13:34:28 |
| 18732 | 8992 | 1 | 2019-12-15 13:36:30 |
| 18733 | 8964 | 1 | 2019-12-15 13:36:32 |
| 18734 | 8969 | 1 | 2019-12-15 13:37:28 |
| 18735 | 8970 | 1 | 2019-12-15 13:39:09 |
| 18736 | 9004 | 1 | 2019-12-15 13:39:14 |
| 18737 | 8963 | 1 | 2019-12-15 13:42:50 |
| 18738 | 8998 | 1 | 2019-12-15 13:43:16 |
| 18739 | 8982 | 1 | 2019-12-15 13:45:31 |
| 18740 | 8999 | 1 | 2019-12-15 13:46:58 |
| 18741 | 8976 | 1 | 2019-12-15 13:47:58 |
| 18742 | 8991 | 1 | 2019-12-15 13:49:05 |
| 18743 | 8984 | 1 | 2019-12-15 13:53:02 |
| 18744 | 9003 | 1 | 2019-12-15 13:54:11 |
| 18745 | 9006 | 1 | 2019-12-15 13:55:50 |
| 18746 | 8981 | 1 | 2019-12-15 13:56:33 |
| 18747 | 8962 | 1 | 2019-12-15 13:58:22 |
| 18748 | 8997 | 1 | 2019-12-15 14:00:01 |
| 18749 | 8986 | 1 | 2019-12-15 14:09:57 |
| 18750 | 9007 | 1 | 2019-12-15 14:14:18 |
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;