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)