Table
wing_scan
Every scan at a wing entrance.
Replaces in 2020: Wings
Rows 1,776–1,800 of 19,545
| scan_idINTEGER | ticket_id→ ticket.ticket_id | wing_id→ wing.wing_id | scanned_atTEXT |
|---|---|---|---|
| 1776 | 883 | 2 | 2015-08-23 11:27:07 |
| 1777 | 882 | 2 | 2015-08-23 11:31:06 |
| 1778 | 881 | 2 | 2015-08-23 11:33:19 |
| 1779 | 880 | 2 | 2015-08-23 11:35:34 |
| 1780 | 880 | 3 | 2015-08-23 12:09:12 |
| 1781 | 883 | 3 | 2015-08-23 12:22:43 |
| 1782 | 881 | 3 | 2015-08-23 12:23:18 |
| 1783 | 1015 | 2 | 2015-08-23 12:36:38 |
| 1784 | 882 | 3 | 2015-08-23 12:41:43 |
| 1785 | 1015 | 1 | 2015-08-23 13:45:55 |
| 1786 | 909 | 1 | 2015-08-23 15:25:05 |
| 1787 | 907 | 1 | 2015-08-23 15:32:47 |
| 1788 | 908 | 2 | 2015-08-23 15:34:36 |
| 1789 | 910 | 1 | 2015-08-23 15:34:53 |
| 1790 | 945 | 3 | 2015-08-23 15:56:23 |
| 1791 | 946 | 3 | 2015-08-23 16:11:11 |
| 1792 | 908 | 1 | 2015-08-23 16:23:02 |
| 1793 | 945 | 1 | 2015-08-23 16:26:42 |
| 1794 | 909 | 3 | 2015-08-23 16:36:19 |
| 1795 | 910 | 3 | 2015-08-23 17:02:49 |
| 1796 | 903 | 2 | 2015-08-23 17:04:49 |
| 1797 | 907 | 3 | 2015-08-23 17:08:31 |
| 1798 | 904 | 2 | 2015-08-23 17:10:05 |
| 1799 | 946 | 1 | 2015-08-23 17:42:30 |
| 1800 | 1022 | 3 | 2015-08-24 10:57:35 |
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;