MetaHome

테이블 (10)

고등학교 (HIGHSCHOOLE)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • HI_NAME — VARCHAR2(1000)
  • HI_LAT — NUMBER
  • HI_LON — NUMBER
  • HI_BUIL — VARCHAR2(100)
  • HI_ADDRESS — VARCHAR2(1000)

공원 (PARK)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • PARK_NAME — VARCHAR2(1000)
  • PARK_LAT — NUMBER
  • PARK_LON — NUMBER
  • PARK_IMG — VARCHAR2(2000)
  • PARK_AREA — VARCHAR2(200)
  • PARK_ADDRESS — VARCHAR2(1000)

버스 (BUS)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • BUS_NAME — VARCHAR2(1000)
  • BUS_LAT — NUMBER
  • BUS_LON — NUMBER

병원 개수 (HOSPITAL)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • HOS_NAME — VARCHAR2(1000)
  • HOS_LAT — NUMBER
  • HOS_LON — NUMBER
  • HOS_ADDRESS — VARCHAR2(1000)
  • HOS_CALL — VARCHAR2(100)
  • HOS_S — VARCHAR2(100)
  • HOS_C — VARCHAR2(100)

주차장 (PARKING)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • PARKING_NAME — VARCHAR2(1000)
  • PARKING_LAT — NUMBER
  • PARKING_LON — NUMBER
  • PARKING_ADDRESS — VARCHAR2(1000)
  • PARKING_CALL — VARCHAR2(100)
  • PARKING_FREE — VARCHAR2(10)
  • PARKING_PLANE — INTEGER
  • PARKING_MORE — INTEGER
  • PARKING_PLANE_TIME — INTEGER
  • PARKING_MORE_TIME — INTEGER
  • PARKING_DMAX — INTEGER
  • PARKING_BUS_PLANE — INTEGER
  • PARKING_BUS_MORE — INTEGER

중학교 (MIDDLESCHOOLE)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • MID_NAME — VARCHAR2(1000)
  • MID_LAT — NUMBER
  • MID_LON — NUMBER
  • MID_BUIL — VARCHAR2(100)
  • MID_ADDRESS — VARCHAR2(1000)

지하철 (SUBWAY)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • SUB_NAME — VARCHAR2(1000)
  • SUB_LAT — NUMBER
  • SUB_LON — NUMBER

집 (HOME)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • HOME_ADDRESS — VARCHAR2(1000)
  • HOME_LAT — NUMBER
  • HOME_LON — NUMBER
  • HOME_NAME — VARCHAR2(1000)
  • HOME_KIND — VARCHAR2(100)
  • HOME_COUNT — VARCHAR2(100)
  • HOME_CO — VARCHAR2(200)
  • HOME_PARKING — VARCHAR2(100)
  • HOME_IMG — VARCHAR2(4000)
  • HOME_NO — NUMBER
  • HOME_MYAREA — VARCHAR2(100)
  • HOME_WEAREA — VARCHAR2(100)
  • HOME_DEP — VARCHAR2(100)
  • HOME_MOTH_PAI — VARCHAR2(100)
  • HOME_CHANGE_DEP — VARCHAR2(100)
  • HOME_RECR — VARCHAR2(10)

집_최단거리 (AI_LEARN)

  • AI_IDX — INTEGER — 기본 키
  • PARK_NAME — VARCHAR2(1000)
  • PARK_DIST — INTEGER — NOT NULL
  • HOS_NAME — VARCHAR2(1000)
  • HOS_DIST — INTEGER — NOT NULL
  • SUB_NAME — VARCHAR2(1000)
  • SUB_DIST — INTEGER — NOT NULL
  • BUS_NAME — VARCHAR2(1000)
  • BUS_DIST — INTEGER — NOT NULL
  • PARKING_NAME — VARCHAR2(1000)
  • PARKING_DIST — INTEGER
  • LOW_NAME — VARCHAR2(1000)
  • LOW_DIST — INTEGER — NOT NULL
  • MID_NAME — VARCHAR2(1000)
  • MID_DIST — INTEGER — NOT NULL
  • HI_NAME — VARCHAR2(1000)
  • HI_DIST — INTEGER
  • CF_NAME — VARCHAR2(1000)
  • CF_DIST — INTEGER
  • CONVE_NAME — VARCHAR2(1000)
  • CONVE_DIST — INTEGER
  • ART_NAME — VARCHAR2(1000)
  • ART_DIST — INTEGER
  • ADDRESS — VARCHAR2(1000)

초등학교 (LOWSCHOOLE)

  • AI_IDX — INTEGER — 외래 키 → 집_최단거리.AI_IDX
  • LOW_NAME — VARCHAR2(1000)
  • LOW_LAT — NUMBER
  • LOW_LON — NUMBER
  • LOW_BUIL — VARCHAR2(100)
  • LOW_ADDRESS — VARCHAR2(1000)