MilVis-Crawler

Tables (8)

bus_line (버스 노선)

  • id (노선 id) — UNSIGEND INT — Primary key — NOT NULL
  • line_name (노선 이름) — VARCHAR(20)

bus_line_detail (노선 상세)

  • line_id (노선 id) — UNSIGEND INT — Foreign key → bus_line.id — NOT NULL
  • station_id (정류장 id) — UNSIGNED INT — Foreign key → bus_station.id — NOT NULL
  • num (순서) — UNSIGNED INT

bus_schedule (Untitled)

  • line_name (노선명) — VARCHAR(20)
  • depart_time (출발시간) — DATETIME
  • arrive_time (도착시간) — DATETIME
  • direction (방면) — VARCHAR(20)

bus_station (정류장)

  • id (정류장 id) — UNSIGNED INT — Primary key — NOT NULL
  • aID (정류장 aid) — UNSIGNED INT
  • name (정류장 이름) — VARCHAR(20) — NOT NULL
  • latitude (위도) — DECIMAL(10, 7) — NOT NULL
  • longitude (경도) — DECIMAL(11, 7) — NOT NULL

city (Untitled3)

  • code (코드) — VARCHAR(2) — Primary key — NOT NULL
  • name (이름) — VARCHAR(20)

collection_data (수집된 데이터)

  • station_id (정류장 id) — UNSIGNED INT — Foreign key → bus_station.id — NOT NULL
  • line_id (노선 id) — UNSIGEND INT — Foreign key → bus_line.id — NOT NULL
  • call_time (호출시간) — DATETIME
  • moving (이동중) — Boolean
  • bus_num (버스번호) — UNSIGEND INT

station (Untitled4)

  • city_code (도시 코드) — VARCHAR(2) — Foreign key → city.code — NOT NULL
  • code (역 코드) — VARCHAR(20)
  • name (역 이름) — VARCHAR(20)

train (Untitled2)

  • id — VARCHAR(2)
  • name (이름) — VARCHAR(20)