bus_project
Tables (8)
Untitled (route_id_station)
- Key (routeId) — Primary key — NOT NULL
- Field (centerYn)
- Field2 (districtCd)
- Field3 (mobileNe)
- Field4 (regionName)
- Field5 (stationId)
- Field6 (stationName)
- Field7 (x)
- Field8 (y)
- Field9 (stationSeq)
- Field (turnYn)
Untitled (station_info1)
- Key (stationId) — Primary key — NOT NULL
- Field (stationName)
- Field2 (mobileNo)
- Field3 (x)
- Field4 (centerYn)
- Field5 (districtCd)
- Field6 (regionName)
Untitled (route_info)
- Key (routeId) — Primary key — NOT NULL
- Field2 (routeName)
- Field3 (routeTypeCd)
- Field6 (regionName)
- Field7 (districtCd)
- Field8 (upFirstTime)
- Field (upLasttime)
- Field2 (downFirstTime)
- Field3 (downLastTime)
- Field4 (peekAlloc)
- Field5 (nPeekAlloc)
- Key (companyId) — Foreign key → Untitled.Key — NOT NULL
- Key (startStationId) — Foreign key → Untitled.Key — NOT NULL
- Key (endStationId) — Foreign key → Untitled.Key — NOT NULL
Untitled (company_info)
- Key (companyId) — Primary key — NOT NULL
- Field2 (companyName)
- Field7 (companyTel)
Untitled (route_info_detail)
- Key (plateNo) — Primary key — NOT NULL
- Key (routeId) — Foreign key → Untitled.Key — NOT NULL
- Field3 (lowPlate)
- Field4 (plateType)
Untitled (route_station_list_info)
- Key (routeId) — Foreign key → Untitled.Key — NOT NULL
- Field3 (stationSeq)
- Key (stationId) — Foreign key → Untitled.Key — NOT NULL
Untitled (station_info)
- Key (stationId) — Primary key — NOT NULL
- Field (stationName)
- Field3 (regionName)
- Field4 (districtCd)
- Field5 (turnYn)
- Field6 (x)
- Field7 (y)
- Field (mobileNo)
route_id_summary
- Key (routeId) — Primary key — NOT NULL
- Field (routeName)
- Field2 (routeTypeCd)
- Field (startStationId)
- Field3 (startStationName)
- Field4 (startMobileNo)
- Field5 (endStationId)
- Field6 (endStationName)
- Field7 (endMobileNo)
- Field8 (upFirstTime)
- Field9 (upLastTime)
- Field10 (downFirstTime)
- Field11 (downLastTime)
- Field (peekAlloc)
- Field2 (nPeekAlloc)
- Field3 (companyId)
- Field4 (companyName)
- Field5 (regionName)
- Field (districtCd)