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)