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)