Table

entry_scan

Every entrance scan; only the first of the day records how the visitor travelled.

Replaces in 2020: Entrance, Ticket.Transportation

Rows 976–1,000 of 9,738

entry_scan, page 40 of 390
scan_idINTEGER	ticket_id→ ticket.ticket_id	entrance_id→ entrance.entrance_id	scanned_atTEXT	is_first_entryINTEGER	transport_modeTEXT
976	552	4	2015-09-03 11:54:39	1	Bus
977	553	4	2015-09-03 11:54:45	1	Bus
978	556	4	2015-09-03 11:54:47	1	Bus
979	557	4	2015-09-03 11:54:57	1	Bus
980	561	4	2015-09-03 11:54:59	1	Bus
981	563	4	2015-09-03 11:55:03	1	Bus
982	564	4	2015-09-03 11:55:14	1	Bus
983	558	4	2015-09-03 11:55:23	1	Bus
984	568	4	2015-09-03 11:55:49	1	Bus
985	565	4	2015-09-03 11:55:51	1	Bus
986	579	4	2015-09-03 11:55:55	1	Bus
987	569	4	2015-09-03 11:55:56	1	Bus
988	582	4	2015-09-03 11:56:07	1	Bus
989	566	4	2015-09-03 11:56:09	1	Bus
990	591	4	2015-09-03 11:56:39	1	Bus
991	570	4	2015-09-03 11:56:51	1	Bus
992	572	4	2015-09-03 11:56:59	1	Bus
993	571	4	2015-09-03 11:57:02	1	Bus
994	590	4	2015-09-03 11:57:04	1	Bus
995	574	4	2015-09-03 11:57:19	1	Bus
996	584	4	2015-09-03 11:57:27	1	Bus
997	578	4	2015-09-03 11:57:57	1	Bus
998	586	4	2015-09-03 11:57:59	1	Bus
999	577	4	2015-09-03 11:58:03	1	Bus
1000	580	4	2015-09-03 11:58:19	1	Bus

Table definition

CREATE TABLE entry_scan (
  scan_id        INTEGER PRIMARY KEY,
  ticket_id      INTEGER NOT NULL REFERENCES ticket (ticket_id),
  entrance_id    INTEGER NOT NULL REFERENCES entrance (entrance_id),
  scanned_at     TEXT NOT NULL,
  is_first_entry INTEGER NOT NULL CHECK (is_first_entry IN (0, 1)),
  transport_mode TEXT CHECK (transport_mode IN ('Walk', 'Metro', 'Train', 'Bus', 'Taxi', 'Private Vehicle', 'Other')),
  CHECK ((is_first_entry = 1) = (transport_mode IS NOT NULL))
) STRICT;