kPaaS

Tables (4)

city (큰 지역 정보)

  • Key — Int — Primary key — NOT NULL
  • name (Field) — varChar
  • maxLat (Field2) — Double
  • maxLng (Field3) — Double
  • minLat (Field4) — Double
  • minLng (Field5) — Double

floodRisk (침수 위험도 데이터)

  • id (Key) — Int — Primary key — NOT NULL
  • cityId (Key2) — Int — Foreign key → subRegion.Key — NOT NULL
  • location (Field) — varChar
  • gidChar (Field2) — varChar
  • gidCode1 (Field6) — Int
  • gidCode2 (Field7) — Int
  • depth10 (Field3) — Float
  • depth20 (Field4) — Float
  • depth50 (Field5) — Float

subRegion (하위 지역)

  • Key — Int — Primary key — NOT NULL
  • cityId (Key2) — Int — Foreign key → city.Key — NOT NULL
  • name (Field) — varChar
  • detail (Field2) — varChar
  • lat (Field3) — Double
  • lng (Field4) — double

subway (지하철 데이터)

  • id (Key) — Int — Primary key — NOT NULL
  • cityId (Key2) — Int — Foreign key → subRegion.Key — NOT NULL
  • name (Field) — varChar
  • line (Field2) — varChar
  • lat (Field3) — Double
  • lng (Field4) — Double