Table

wing_scan

Every scan at a wing entrance.

Replaces in 2020: Wings

Rows 26–50 of 19,545

wing_scan, page 2 of 782
scan_idINTEGER	ticket_id→ ticket.ticket_id	wing_id→ wing.wing_id	scanned_atTEXT
26	86	2	2015-03-06 10:45:21
27	87	2	2015-03-06 11:16:42
28	87	3	2015-03-06 12:19:28
29	87	2	2015-03-06 13:10:53
30	88	2	2015-03-06 13:22:51
31	89	2	2015-03-06 13:23:30
32	90	2	2015-03-07 11:16:44
33	90	3	2015-03-07 12:32:28
34	92	2	2015-03-08 10:10:40
35	91	1	2015-03-08 10:13:22
36	92	3	2015-03-08 11:03:41
37	92	1	2015-03-08 11:48:12
38	7	2	2015-03-08 14:39:57
39	77	2	2015-03-08 14:43:23
40	76	3	2015-03-08 14:51:19
41	77	1	2015-03-08 15:28:31
42	77	2	2015-03-08 16:18:20
43	67	1	2015-03-09 11:54:05
44	66	1	2015-03-09 12:03:09
45	67	3	2015-03-09 12:28:45
46	66	3	2015-03-09 12:31:30
47	67	1	2015-03-09 13:11:01
48	66	1	2015-03-09 13:51:09
49	80	2	2015-03-09 17:02:40
50	101	2	2015-03-12 12:29:10

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;