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)