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