Table
entry_scan
Every entrance scan; only the first of the day records how the visitor travelled.
Replaces in 2020: Entrance, Ticket.Transportation
Rows 1,526–1,550 of 9,738
| scan_idINTEGER | ticket_id→ ticket.ticket_id | entrance_id→ entrance.entrance_id | scanned_atTEXT | is_first_entryINTEGER | transport_modeTEXT |
|---|---|---|---|---|---|
| 1526 | 1618 | 3 | 2015-12-22 09:41:20 | 1 | Walk |
| 1527 | 1620 | 5 | 2015-12-22 10:17:48 | 1 | Walk |
| 1528 | 1619 | 5 | 2015-12-22 10:18:05 | 1 | Walk |
| 1529 | 1456 | 2 | 2015-12-22 11:58:08 | 1 | Metro |
| 1530 | 1618 | 3 | 2015-12-22 12:16:08 | 0 | NULL |
| 1531 | 1625 | 4 | 2015-12-22 15:29:50 | 1 | Metro |
| 1532 | 1607 | 1 | 2015-12-22 16:22:32 | 1 | Walk |
| 1533 | 1606 | 1 | 2015-12-22 16:22:47 | 1 | Walk |
| 1534 | 1630 | 4 | 2015-12-23 09:04:23 | 1 | Walk |
| 1535 | 1629 | 4 | 2015-12-23 09:04:27 | 1 | Walk |
| 1536 | 1628 | 4 | 2015-12-23 09:04:35 | 1 | Walk |
| 1537 | 1627 | 4 | 2015-12-23 09:05:04 | 1 | Walk |
| 1538 | 1626 | 4 | 2015-12-23 09:05:05 | 1 | Walk |
| 1539 | 1610 | 1 | 2015-12-24 11:25:24 | 1 | Walk |
| 1540 | 1585 | 4 | 2015-12-25 14:24:09 | 1 | Walk |
| 1541 | 1635 | 4 | 2015-12-26 09:04:56 | 1 | Walk |
| 1542 | 1632 | 5 | 2015-12-26 10:29:45 | 1 | Metro |
| 1543 | 1631 | 5 | 2015-12-26 10:30:04 | 1 | Metro |
| 1544 | 1637 | 2 | 2015-12-26 12:30:57 | 1 | Metro |
| 1545 | 1639 | 2 | 2015-12-26 12:31:00 | 1 | Metro |
| 1546 | 1640 | 2 | 2015-12-26 12:31:07 | 1 | Metro |
| 1547 | 1638 | 2 | 2015-12-26 12:31:17 | 1 | Metro |
| 1548 | 1636 | 4 | 2015-12-26 13:39:41 | 1 | Walk |
| 1549 | 1641 | 3 | 2015-12-27 10:39:12 | 1 | Private Vehicle |
| 1550 | 1642 | 3 | 2015-12-27 10:39:52 | 1 | Private Vehicle |
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;