citymonitoring

Tables (9)

AcceptRecord (수신기록)

  • Id (id) — int — Primary key — NOT NULL
  • resultCode (결과코드) — int
  • resultMsg (결과메시지) — VARCHAR(255)
  • acceptTime (수신시각) — LocalDateTime

City (도시)

  • Id (id) — int — Primary key — NOT NULL
  • name (이름) — VARCHAR(255)

County (군또는구)

  • Id (id) — int — Primary key — NOT NULL
  • cityId (도시Id) — int — Foreign key → City.Id — NOT NULL
  • name (이름) — VARCHAR(255)
  • Field

Dong (동)

  • Id (id) — int — Primary key — NOT NULL
  • countyId (군Id) — int — Foreign key → County.Id — NOT NULL
  • name (이름) — VARCHAR(255)
  • Field

Spot (장소)

  • Id (id) — int — Primary key — NOT NULL
  • dongId (동Id) — int — Foreign key → Dong.Id — NOT NULL
  • name (장소명칭) — VARCHAR(255)
  • Field

TrafficInfo (교통정보)

  • Id (Key) — int — Primary key — NOT NULL
  • spotId (장소Id) — int — Foreign key → Spot.Id — NOT NULL
  • roadMsg (메시지) — VARCHAR(255)
  • roadTrafficSpeed (평균속도) — int
  • referenceTime (기준시각) — LocalDateTime
  • Field

TransmissionRecord (발신기록)

  • Id (id) — int — Primary key — NOT NULL
  • url (시도URL) — VARCHAR(255)
  • port (시도PORT) — int
  • time (발신시각) — LocalDateTime

WeatherForecastInfo (기상예측정보)

  • Id (id) — int — Primary key — NOT NULL
  • temperature (기온) — int
  • rainChance (강수확률) — float
  • stystts (날씨) — VARCHAR2(255)
  • Field

WeatherInfo (날씨정보)

  • Id (id) — int — Primary key — NOT NULL
  • spotId (장소Id) — int — Foreign key → Spot.Id — NOT NULL
  • weatherForecastInfoId (기상예측정보Id) — int — Foreign key → WeatherForecastInfo.Id — NOT NULL
  • temperature (기온) — double
  • maxTemp (최고기온) — double
  • minTemp (최저기온) — double
  • pcpMsg (예보) — VARCHAR2(255)
  • referenceTime (기준시각) — LocalDateTime
  • sunrise (일출) — LocalDateTime
  • sunset (일몰) — LocalDateTime
  • uvIndexLevel (자외선지수변수) — VARCHAR2(255)
  • uvIndex (자외선지수) — int
  • uvMsg (자외선주의설명) — VARCHAR2
  • pm25Index (공기25지수변수) — VARCHAR2
  • pm25 (공기25지수) — int
  • pm10Index (공기10지수변수) — VARCHAR2
  • pm10 (공기10지수) — int
  • airIdx (Field)