Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 676–700 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 676 | 501 | 3 | 2015-05-08 12:58:31 |
| 677 | 500 | 2 | 2015-05-08 13:23:07 |
| 678 | 498 | 2 | 2015-05-08 13:34:25 |
| 679 | 501 | 2 | 2015-05-08 14:20:50 |
| 680 | 500 | 3 | 2015-05-08 14:26:33 |
| 681 | 498 | 3 | 2015-05-08 14:47:43 |
| 682 | 501 | 3 | 2015-05-08 15:40:50 |
| 683 | 442 | 2 | 2015-05-09 09:53:50 |
| 684 | 442 | 1 | 2015-05-09 10:47:16 |
| 685 | 442 | 2 | 2015-05-09 11:47:52 |
| 686 | 504 | 3 | 2015-05-10 09:49:58 |
| 687 | 339 | 3 | 2015-05-10 10:22:36 |
| 688 | 340 | 3 | 2015-05-10 10:27:38 |
| 689 | 505 | 2 | 2015-05-10 15:28:42 |
| 690 | 505 | 1 | 2015-05-10 16:47:25 |
| 691 | 507 | 3 | 2015-05-12 10:46:07 |
| 692 | 353 | 2 | 2015-05-12 11:04:30 |
| 693 | 351 | 2 | 2015-05-12 11:06:36 |
| 694 | 349 | 2 | 2015-05-12 11:14:00 |
| 695 | 350 | 2 | 2015-05-12 11:15:40 |
| 696 | 352 | 2 | 2015-05-12 11:17:33 |
| 697 | 507 | 2 | 2015-05-12 11:34:28 |
| 698 | 351 | 3 | 2015-05-12 11:53:44 |
| 699 | 353 | 3 | 2015-05-12 11:56:53 |
| 700 | 350 | 3 | 2015-05-12 12:02:19 |
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;