Bus

Tables (8)

AREA (Untitled7)

  • AREA_ID (Key) — VARCHAR(5) — Primary key — NOT NULL
  • AREA_NAME (Field) — VARCHAR(20)
  • CENTER_ID (Field2) — VARCHAR(10)

ArriveInfo (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • route_id (Key2) — INT — Foreign key → Route.route_id — NOT NULL
  • station_id (Key3) — INT — Foreign key → station.station_id — NOT NULL
  • remain_seat_cnt (Field) — TINYINT
  • station_seq (Field4) — TINYINT
  • end_bus (Field5) — TINYINT
  • date (Field2) — date

Route (노선)

  • route_id (Key) — INT — Primary key — NOT NULL
  • route_name (Field) — VARCHAR(20)
  • route_type (Field2) — TINYINT
  • route_type_name (Field3) — VARCHAR(30)
  • region_name (Field4) — VARCHAR(50)
  • compnay_id (Field5) — INT
  • company_name (Field6) — VARCHAR(50)
  • company_tel (Field7) — VARCHAR(50)
  • down_first_time (Field8) — VARCHAR(50)
  • down_last_time (Field9) — VARCHAR(50)
  • end_mobile_no (Field10) — INT
  • end_station_id (Field11) — INT
  • end_station_name (Field12) — VARCHAR(100)
  • start_mobile_no (Field13) — INT
  • start_station_id (Field14) — INT
  • start_station_name (Field15) — VARCHAR(100)
  • up_first_name (Field16) — VARCHAR(50)
  • up_last_time (Field17) — VARCHAR(50)
  • peek_alloc (Field18) — 10
  • npeek_alloc (Field19) — 14

USER (Untitled4)

  • Key — Primary key — NOT NULL

like_route (Untitled5)

  • routeId (Key2) — INT — Foreign key → Route.route_id — NOT NULL
  • Key — Foreign key → USER.Key — NOT NULL

route_line (Untitled2)

  • id (Key2) — INT — Primary key — NOT NULL
  • route_id (Key) — INT — Foreign key → Route.route_id — NOT NULL
  • location_seq (Field5)
  • location_type (Field) — INT
  • location_id (Field4)
  • sub_length (Field6)
  • sum_length (Field7)
  • x (Field2) — FLOAT
  • y (Field3) — FLOAT
  • link_id (Field8)

route_station (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • station_id (Key2) — INT — Foreign key → station.station_id — NOT NULL
  • route_id (Key3) — INT — Foreign key → Route.route_id — NOT NULL
  • updown (Field) — varchar(2)
  • station_order (Field2) — SMALLINT
  • route_name (Field3) — VARCHAR(100)
  • station_name (Field4) — VARCHAR(100)

station (Untitled)

  • station_id (Key) — INT — Primary key — NOT NULL
  • mobile_no (Field) — INT
  • region_name (Field2) — VARCHAR(50)
  • center_yn (Field4) — VARCHAR(5)
  • district_cd (Field5) — INT
  • station_name (Field6) — VARCHAR(100)
  • station_x (Field7) — FLOAT
  • station_y (Field8) — FLOAT