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