Table

wing_scan

Every scan at a wing entrance.

Replaces in 2020: Wings

Rows 4,651–4,675 of 19,545

wing_scan, page 187 of 782
scan_idINTEGER	ticket_id→ ticket.ticket_id	wing_id→ wing.wing_id	scanned_atTEXT
4651	1931	2	2016-07-01 14:05:55
4652	1915	2	2016-07-01 14:06:29
4653	1948	2	2016-07-01 14:06:29
4654	1932	2	2016-07-01 14:06:38
4655	1920	2	2016-07-01 14:08:15
4656	1893	2	2016-07-01 14:08:17
4657	1923	2	2016-07-01 14:08:31
4658	1907	2	2016-07-01 14:08:34
4659	1928	2	2016-07-01 14:08:35
4660	1945	2	2016-07-01 14:08:40
4661	1916	2	2016-07-01 14:09:24
4662	1904	2	2016-07-01 14:09:26
4663	1898	2	2016-07-01 14:09:33
4664	1909	2	2016-07-01 14:09:35
4665	1902	2	2016-07-01 14:09:39
4666	1944	2	2016-07-01 14:09:45
4667	1914	2	2016-07-01 14:09:48
4668	1941	2	2016-07-01 14:10:30
4669	1922	2	2016-07-01 14:10:31
4670	1905	2	2016-07-01 14:10:37
4671	1899	2	2016-07-01 14:10:40
4672	2435	1	2016-07-01 14:11:02
4673	1917	2	2016-07-01 14:11:48
4674	1919	2	2016-07-01 14:12:05
4675	1938	2	2016-07-01 14:12:12

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;