pubtrans-service
Tables (28)
Untitled (bus_line_graph)
- Key (graph_id) — number — Primary key — NOT NULL
- Field (sequence) — number
- Field (distance) — number
- Key (stop_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (route_id) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (service_day)
- Key (service_day_id) — number — Primary key — NOT NULL
- Field (service_day_name) — string
- Field (mon) — boolean
- Field (tue) — boolean
- Field (wed) — boolean
- Field (thu) — boolean
- Field (fri) — boolean
- Field (sat) — boolean
- Field (sun) — boolean
- Field (binary) — number
Untitled (airline_timetable)
- Key (timetable_id) — number — Primary key — NOT NULL
- Field (flight) — string
- Field (plane_kind) — string
- Field (departure_time) — time
- Field (duration) — string
- Field (arrival_time) — time
- Key (company_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (airline_id) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (airline_company)
- Key (company_id) — number — Primary key — NOT NULL
- Field (company_name) — string
Untitled (airline_type)
- Key (type_id) — number — Primary key — NOT NULL
- Field (type_name) — string
- Field (color) — string
Untitled (airport)
- Key (airport_id) — number — Primary key — NOT NULL
- Field (airport_name) — string
- Field (address) — string
- Field (road_address) — string
- Field (tel) — string
- Field (tel_lostcenter) — string
- Field (fax) — string
- Field (homepage) — string
- Field (x) — float
- Field (y) — float
Untitled (airline)
- Key (airline_id) — number — Primary key — NOT NULL
- Key (departure_airport_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (arrival_airport_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (type_id) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (train_timetable)
- Key (timetable_id) — number — Primary key — NOT NULL
- Field (train_no) — number
- Key (departure_station_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (arrival_station_id) — number — Foreign key → Untitled.Key — NOT NULL
- Field (departure_index) — number
- Field (arrival_index) — number
- Field (departure_time) — time
- Field (arrival_time) — time
- Field (runday) — string
- Key (route_id) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (train_station)
- Key (station_id) — number — Primary key — NOT NULL
- Field (station_name) — string
- Field (address) — string
- Field (tel) — string
- Field (tel_lost_center) — string
- Field (fax) — string
- Field (homepage) — string
- Field (x) — float
- Field (y) — float
- Field (road_address) — string
Untitled (train_route)
- Key (route_id) — number — Primary key — NOT NULL
- Field (route_name) — string
- Key (type_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (group_id) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (train_group)
- Key (group_id) — number — Primary key — NOT NULL
- Field (group_name) — string
Untitled (train_type)
- Key (type_id) — number — Primary key — NOT NULL
- Field (type_name) — string
- Field (color) — string
Untitled (bus_interpolation_point)
- Key (interpolation_point_id) — number — Primary key — NOT NULL
- Field (x) — float
- Field (y) — float
- Key (graph_id) — number — Foreign key → Untitled.Key — NOT NULL
- Field (sequence) — number
Untitled (bus_stop)
- Key (stop_id) — number — Primary key — NOT NULL
- Field (stop_name) — string
- Field (sub_name) — string
- Field (x) — float
- Field (y) — float
- Field (address) — string
- Field (road_address) — string
- Field (ars_id) — string
Untitled (bus_interval)
- Key (interval_id) — number — Primary key — NOT NULL
- Field (driving_count) — number
- Field (interval_minute) — number
- Field (mon) — boolean
- Field (tue) — boolean
- Field (wed) — boolean
- Field (thu) — boolean
- Field (fri) — boolean
- Field (sat) — boolean
- Field (sun) — boolean
- Field (first_time) — time
- Field (last_time) — time
- Key (route_id) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (bus_driving_info)
- Key (driving_id) — number — Primary key — NOT NULL
- Field (first_time) — time
- Field (last_time) — time
- Key (route_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (service_day_id) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (bus_company)
- Key (company_id) — number — Primary key — NOT NULL
- Field (company_name) — string
- Field (tel) — string
Untitled (bus_route)
- Key (route_id) — number — Primary key — NOT NULL
- Field (bus_no) — string
- Field (include_low_plate) — boolean
- Field (tel_reservation) — string
- Key (type_id) — number — Foreign key → Untitled.Key — NOT NULL
- Key (company_id) — number — Foreign key → Untitled.Key — NOT NULL
Untitled (bus_route_type)
- Key (type_id) — number — Primary key — NOT NULL
- Field (type_name) — string
- Field (icon_name) — string
- Field (type_color) — string
- Field (sort_priority) — number
Untitled2 (train_faretable)
- Key (faretable_id) — number — Primary key — NOT NULL
- Field (day) — string
- Field (special_adult) — number
- Field (special_kid) — number
- Field (special_senior) — number
- Field (general_adult) — number
- Field (general_kid) — number
- Field (general_senior) — number
- Field (standing_adult) — number
- Field (standing_kid) — number
- Field (standing_senior) — number
- Key (timetable_id) — number — Foreign key → Untitled.Key — NOT NULL
station_timetable
- timetable_id — number — Primary key — NOT NULL
- direction — string
- order — number
- departure_time — time
- arrival_time — time
- subway_line_id — number — Foreign key → subway_line.line_id — NOT NULL
- station_id — number — Foreign key → subway_station.station_id — NOT NULL
subway_interpolation_point (subway_interpoltaion_point)
- interpoltaion_id (interpolation_id) — number — Primary key — NOT NULL
- x — float
- y — float
- graph_id — number — Foreign key → subway_line_graph.graph_id — NOT NULL
- Field (sequence) — number
subway_line
- line_id — number — Primary key — NOT NULL
- line_type — string
- route_id — number — Foreign key → subway_route.route_id — NOT NULL
subway_line_graph
- graph_id — number — Primary key — NOT NULL
- sequence — number
- subway_line_id — number — Foreign key → subway_line.line_id — NOT NULL
- station_id — number — Foreign key → subway_station.station_id — NOT NULL
subway_route
- route_id — number — Primary key — NOT NULL
- type_id — number — Foreign key → subway_route_type.type_id — NOT NULL
subway_route_type
- type_id — number — Primary key — NOT NULL
- type_name — string
- type_color — string
- sort_priority — number
- type_long_name — string
- icon_name — string
subway_station
- station_id — number — Primary key — NOT NULL
- station_name — string
- display_id — string
- tel — string
- x — float
- y — float
- address — string
- road_address — string
subway_station_facility
- facility_id — number — Primary key — NOT NULL
- lost_center — boolean
- lost_center_url — string
- lost_center_tel — string
- bicycle_rack — boolean
- transfer_parking — boolean
- station_office — boolean
- public_office — boolean
- ticket — boolean
- disabled_toilet — boolean
- elevator — boolean
- wheelchair_lift — boolean
- visitor_center — boolean
- automatic_dispenser — boolean
- lactation_room — boolean
- locker — boolean
- station_id — number — Foreign key → subway_station.station_id — NOT NULL