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