public_data
테이블 (57)
건물수치표고모델 (BUILDING_DEM)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- point_num — INT — 외래 키 → 수치표고모델.point_num — NOT NULL
- distance — DECIMAL(13,8)
경찰관서정보 (POLICE_STATION)
- pid — INT — 기본 키 — NOT NULL
- national_police_agency — VARCHAR(255)
- police_station — VARCHAR(255)
- police_box — VARCHAR(255)
- x_coordinate — DECIMAL(13,8)
- y_coordinate — DECIMAL(13,8)
- address — VARCHAR(255)
경찰청교통CCTV (POLICE_AGENCY_CCTV)
- cctvid — VARCHAR(255) — 기본 키 — NOT NULL
- rn — INT
- cctvname — VARCHAR(255)
- centername — VARCHAR(255)
- xcoord — DECIMAL(13,8)
- ycoord — DECIMAL(13,8)
경찰청교통CCTV영상 (POLICE_AGENCY_CCTV_VIDEO)
- generatedate — BIGINT — 기본 키
- cctvid — VARCHAR(255) — 외래 키 → 경찰청교통CCTV.cctvid — NOT NULL
- file_path — LONGTEXT
- video_length — INT
경찰청교통CCTV와 도로링크 릴레이션 (REL_POLICE_CCTV_ROAD_LINK)
- cctvid — VARCHAR(255) — 외래 키 → 경찰청교통CCTV.cctvid — NOT NULL
- fid — INT — 외래 키 → 도로링크정보.fid
- link_id — BIGINT — 외래 키 → 도로링크정보.link_id
- distance — DECIMAL(13,8)
공공시설정보 (PUBLIC_FACILITY)
- pfn — INT — 기본 키
- openfcltynm — VARCHAR(255)
- openlcnm — VARCHAR(255)
- openfcltytype — VARCHAR(255)
- rstde — VARCHAR(255)
- weekdayoperopenhhmm — VARCHAR(255)
- weekdayopercolsehhmm — VARCHAR(255)
- wkendoperopenhhmm — VARCHAR(255)
- wkendoperclosehhmm — VARCHAR(255)
- pchrguseyn — VARCHAR(255)
- usestdrtime — FLOAT
- rntfee — VARCHAR(255)
- excessuseunittime — VARCHAR(255)
- excessrntfee — VARCHAR(255)
- aceptncposblco — INT
- ar — FLOAT
- etcfclty — VARCHAR(255)
- sbscrptnmthse — VARCHAR(255)
- fcltypicinfo — LONGTEXT
- rdnmadr — VARCHAR(255)
- lnmadr — VARCHAR(255)
- institutionnm — VARCHAR(255)
- chrgdeptnm — VARCHAR(255)
- phonenumber — VARCHAR(255)
- homepageurl — VARCHAR(255)
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
- referencedate — VARCHAR(255)
- insttcode — VARCHAR(255)
국문관광정보 (KR_TOURISM)
- contentid — INT — 기본 키 — NOT NULL
- areacode — INT
- cat1 — VARCHAR(255)
- cat2 — VARCHAR(255)
- cat3 — VARCHAR(255)
- contenttypeid — INT
- createdtime — BIGINT
- firstimage — VARCHAR(255)
- firstimage2 — VARCHAR(255)
- mapx — DECIMAL(13,8)
- mapy — DECIMAL(13,8)
- mlevel — INT
- modifiedtime — BIGINT
- readcount — INT
- sigungucode — INT
- title — VARCHAR(255)
도로링크와 도로혼잡도 릴레이션 (REL_LINK_CONFUSION)
- fid — INT — 외래 키 → 도로링크정보.fid
- link_id — BIGINT — 외래 키 → 도로혼잡도정보.link_id — NOT NULL
- generatedate — BIGINT — 외래 키 → 도로혼잡도정보.generatedate — NOT NULL
도로링크정보 (ROAD_LINK)
- fid — INT — 기본 키
- link_id — BIGINT — 기본 키
- f_node — BIGINT
- t_node — BIGINT
- lanes — INT
- road_rank — INT
- road_name — VARCHAR(255)
- max_spd — INT
- length — FLOAT
- vertex_ind — INT
- vertex_par — INT
- vertex_p_1 — INT
- distance — FLOAT
- angle — FLOAT
- lat — DECIMAL(13,8)
- lon — DECIMAL(13,8)
도로혼잡도정보 (ROAD_CONFUSION)
- link_id — BIGINT — 기본 키 — NOT NULL
- generatedate — BIGINT — 기본 키 — NOT NULL
- avgspeed — INT
- startnodeid — BIGINT
- roadnametext — VARCHAR(255)
- traveltime — INT
- endnodeid — BIGINT
- roadsituation — VARCHAR(255)
도시공원정보 (CITY_PARK)
- management_number (park_number) — VARCHAR(255) — 기본 키
- park_name — VARCHAR(255)
- park_classification — VARCHAR(255)
- location_road_name_address — VARCHAR(255)
- location_number_address — VARCHAR(255)
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
- park_area — FLOAT
- park_retention_facility_exercise_facility — VARCHAR(255)
- park_retention_facility_playful_facility — VARCHAR(255)
- park_owned_facility_beneficial_facility — VARCHAR(255)
- park_facility_cultivation_facility — VARCHAR(255)
- park_facility_other_facility — VARCHAR(255)
- designated_notice_date — VARCHAR(255)
- name_of_management_agency — VARCHAR(255)
- phone_number — VARCHAR(255)
- data_base_date — VARCHAR(255)
도시공원정보와 지하철정보 릴레이션 (REL_CITYPARK_SUBWAY)
- management_number (park_number) — VARCHAR(255) — 외래 키 → 도시공원정보.management_number
- code — INT — 외래 키 → 지하철정보.code — NOT NULL
- distance — DECIMAL(13,8)
메타데이터 관측지점 정보 (META_STATION_POINT)
- place_id — INT — 기본 키 — NOT NULL
- start_date — date
- end_date — date
- point_name — varchar(100)
- point_address — varchar(100)
- management_office — varchar(100)
- latitude — decimal(11,6)
- longitude — decimal(11,6)
- outdoor_weather_station_height — decimal(11,6)
- barometer_height — decimal(11,6)
- thermometer_height — decimal(11,6)
- anemometer_height — decimal(11,6)
- rain_gauge_height — decimal(11,6)
버스도착정보 (BUS_ARRIVE)
- rtnm — VARCHAR(255) — 기본 키
- mktm — BIGINT — 기본 키
- node_id — VARCHAR(255) — 외래 키 → 버스정류장정보.node_id — NOT NULL
- arrmsg1 — VARCHAR(255)
- arrmsg2 — VARCHAR(255)
- arsid — VARCHAR(255)
- brdrde_num1 — VARCHAR(255)
- brdrde_num2 — VARCHAR(255)
- busrouteid — VARCHAR(255)
- exps1 — VARCHAR(255)
- exps2 — VARCHAR(255)
- firsttm — VARCHAR(255)
- lasttm — VARCHAR(255)
- full1 — VARCHAR(255)
- full2 — VARCHAR(255)
- islast1 — VARCHAR(255)
- islast2 — VARCHAR(255)
- nstnid1 — VARCHAR(255)
- nstnid2 — VARCHAR(255)
- nstnsec1 — VARCHAR(255)
- nstnsec2 — VARCHAR(255)
- plainno1 — VARCHAR(255)
- plainno2 — VARCHAR(255)
- reptm1 — VARCHAR(255)
- stnm — VARCHAR(255)
- term — VARCHAR(255)
- traspd1 — VARCHAR(255)
- traspd2 — VARCHAR(255)
- vehid1 — VARCHAR(255)
- vehid2 — VARCHAR(255)
버스정류장정보 (BUS_STOP)
- node_id — VARCHAR(255) — 기본 키 — NOT NULL
- node_nm — VARCHAR(255)
- gps_lati — DECIMAL(13,8)
- gps_long — DECIMAL(13,8)
- node_mobile_id — INT
- city_code — INT
- city_name — VARCHAR(255)
병원정보 (HOSPITAL)
- hpid — VARCHAR(255) — 기본 키 — NOT NULL
- dutyaddr — VARCHAR(255)
- dutydivnam — VARCHAR(255)
- dutyemclsname — VARCHAR(255)
- dutyname — VARCHAR(255)
- wgs84lat — DECIMAL(13,8)
- wgs84lon — DECIMAL(13,8)
상가인허가정보 (COMMERCIAL_LOCALDATA)
- management_number — VARCHAR(255) — 기본 키 — NOT NULL
- open_service_name — VARCHAR(255)
- business_status_name — VARCHAR(255)
- location_phone — VARCHAR(255)
- location_area — DECIMAL(6,2)
- location_zip_code — INT
- location_full_address — VARCHAR(255)
- business_place_name — VARCHAR(255)
- classification_of_business — VARCHAR(255)
- gridx — DECIMAL(13,8)
- gridy — DECIMAL(13,8)
상가인허가정보와 도시공원정보 릴레이션 (REL_LOCALDATA_CITYPARK)
- management_number — VARCHAR(255) — 외래 키 → 상가인허가정보.management_number — NOT NULL
- management_number (park_number) — VARCHAR(255) — 외래 키 → 도시공원정보.management_number
- distance — DECIMAL(13,8)
상영내역 (SCREENING_DETAILS)
- 상영관 (screening_theater) — VARCHAR(255) — 기본 키
- 영화상영관코드 (movie_theater_code) — INT — 외래 키 → 영화상영관.영화상영관코드
- 일자 (date) — INT — 외래 키 → 일자 릴레이션.일자 — NOT NULL
- 1회 (one_time) — VARCHAR(255)
- 2회 (two_time) — VARCHAR(255)
- 3회 (three_time) — VARCHAR(255)
- 4회 (four_time) — VARCHAR(255)
- 5회 (five_time) — VARCHAR(255)
- 6회 (six_time) — VARCHAR(255)
- 7회 (seven_time) — VARCHAR(255)
- 8회 (eighth_time) — VARCHAR(255)
생활인구정보 (LIVING_POPULATION)
- borough_code — INT — 기본 키
- base_date_id — INT — 기본 키
- time_zone — INT — 기본 키
- total_living_population — VARCHAR(255)
- male_0_to_9_years_old — VARCHAR(255)
- male_10_to_14_years_old — VARCHAR(255)
- male_15_to_19_years_old — VARCHAR(255)
- male_20_to_24_years_old — VARCHAR(255)
- male_25_to_29_years_old — VARCHAR(255)
- male_30_to_34_years_old — VARCHAR(255)
- male_35_to_39_years_old — VARCHAR(255)
- male_40_to_44_years_old — VARCHAR(255)
- male_45_to_49_years_old — VARCHAR(255)
- male_50_to_54_years_old — VARCHAR(255)
- male_55_to_59_years_old — VARCHAR(255)
- male_60_to_64_years_old — VARCHAR(255)
- male_65_to_69_years_old — VARCHAR(255)
- male_70_and_over_living — VARCHAR(255)
- female_0_to_9_years_old — VARCHAR(255)
- female_10_to_14_years_old — VARCHAR(255)
- female_15_to_19_years_old — VARCHAR(255)
- female_20_to_24_years_old — VARCHAR(255)
- female_25_to_29_years_old — VARCHAR(255)
- female_30_to_34_years_old — VARCHAR(255)
- female_35_to_39_years_old — VARCHAR(255)
- female_40_to_44_years_old — VARCHAR(255)
- female_45_to_49_years_old — VARCHAR(255)
- female_50_to_54_years_old — VARCHAR(255)
- female_55_to_59_years_old — VARCHAR(255)
- female_60_to_64_years_old — VARCHAR(255)
- female_65_to_69_years_old — VARCHAR(255)
- female_70_and_over_living — VARCHAR(255)
소방서정보 (FIRE_STATION)
- fnum — INT — 기본 키 — NOT NULL
- addrnm — VARCHAR(255)
- facilityname — VARCHAR(255)
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
- rnum — INT
- fax — VARCHAR(255)
- tel — VARCHAR(255)
수치표고모델 (DIGITAL_ELEVATION_MODEL)
- point_num — INT — 기본 키 — NOT NULL
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
- altitude — DECIMAL(6,2)
영화상영관 (CINEMA)
- 영화상영관코드 (movie_theater_code) — INT — 기본 키
- 광역단체 (metropolitan_organization) — VARCHAR(255)
- 기초단체 (basic_organization) — VARCHAR(255)
- 영화상영관명 (movie_theater_name) — VARCHAR(255)
- 총 스크린수 (total_screens) — INT
- 총 좌석수 (total_seats) — INT
- 필름 상영관수 (number_of_film_theaters) — INT
- 2D 상영관수 (number_of_2d_theaters) — INT
- 3D 상영관수 (number_of_3d_theaters) — INT
- 4D 상영관수 (number_of_4d_theaters) — INT
- IMAX 상영관수 (number_of_imax_theaters) — INT
- 상설여부 (permanent_status) — VARCHAR(255)
- 특별관운영여부 (operation_status_of_special_hall) — VARCHAR(255)
- 가입여부 (sign_up_status) — VARCHAR(255)
- 전송사업자명 (transfer_business_name) — VARCHAR(255)
- 개관일 (opening_day) — INT
- 영업상태 (business_status) — VARCHAR(255)
- 운영형태 (type_of_operation) — VARCHAR(255)
- 주소 (address) — VARCHAR(255)
- 전화번호 (phone_number) — VARCHAR(255)
- 홈페이지 (homepage) — VARCHAR(255)
- Latitude (latitude) — DECIMAL(13,8)
- Longitude (longitude) — DECIMAL(13,8)
영화상영관과 상가인허가정보 릴레이션 (REL_CINEMA_LOCALDATA)
- 영화상영관코드 (movie_theater_code) — INT — 외래 키 → 영화상영관.영화상영관코드
- management_number — VARCHAR(255) — 외래 키 → 상가인허가정보.management_number — NOT NULL
- distance — DECIMAL(13,8)
영화정보 (MOVIE_INFORMATION)
- 영화명 (movie_name) — VARCHAR(255) — 기본 키 — NOT NULL
- 영화명(영문) (movie_name_en) — VARCHAR(255)
- 제작연도 (year_of_production) — INT
- 제작국가 (country_of_production) — VARCHAR(255)
- 유형 (type) — VARCHAR(255)
- 장르 (genre) — VARCHAR(255)
- 제작상태 (fabrication_status) — VARCHAR(255)
- 감독 (direct) — VARCHAR(255)
- 제작사 (production_company) — VARCHAR(255)
- 예고편 (trailer) — LONGTEXT
용도별건물 (BUILDING_INFO_PURPOSE)
- building_identification_number — INT — 기본 키 — NOT NULL
- place_id — INT — 외래 키 → 메타데이터 관측지점 정보.place_id — NOT NULL
- court_dong_name — VARCHAR(255) — NOT NULL
- lot_number — VARCHAR(50)
- name_of_building — VARCHAR(255)
- major_purpose_name — VARCHAR(255)
- detailed_purpose_name — VARCHAR(255)
- building_purpose_classification_name — VARCHAR(50)
- building_height — DECIMAL(6,2)
- ground_floor_number — INT
- underground_floor_number — INT
- latitude — DECIMAL(12,8) — NOT NULL
- longitude — DECIMAL(12,8) — NOT NULL
용도별건물과 경찰관서 릴레이션 (REL_BUILDING_POLICE_STATION)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- pid — INT — 외래 키 → 경찰관서정보.pid — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 경찰청교통CCTV 릴레이션 (REL_BUILDING_POLICE_AGENCY_CCTV)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- cctvid — VARCHAR(255) — 외래 키 → 경찰청교통CCTV.cctvid — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 공공시설 릴레이션 (REL_BUILDING_PUBLIC_FACILITY)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- pfn — INT — 외래 키 → 공공시설정보.pfn
- distance — DECIMAL(13,8)
용도별건물과 국문관광정보 릴레이션 (REL_BUILDING_TOURISM)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- contentid — INT — 외래 키 → 국문관광정보.contentid — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 도로링크 릴레이션 (REL_BUILDING_ROAD_LINK)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- fid — INT — 외래 키 → 도로링크정보.fid
- distance — DECIMAL(13,8)
용도별건물과 도시공원 릴레이션 (REL_BUILDING_CITY_PARK)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- management_number — VARCHAR(255) — 외래 키 → 도시공원정보.management_number
- distance — DECIMAL(13,8)
용도별건물과 버스정류장 릴레이션 (REL_BUILDING_BUS_STOP)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- node_id — VARCHAR(255) — 외래 키 → 버스정류장정보.node_id — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 병원 릴레이션 (REL_BUILDING_HOSPITAL)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- hpid — VARCHAR(255) — 외래 키 → 병원정보.hpid — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 상가인허가 릴레이션 (REL_BUILDING_LOCALDATA)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- management_number — VARCHAR(255) — 외래 키 → 상가인허가정보.management_number — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 소방서 릴레이션 (REL_BUILDING_FIRE_STATION)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- fnum — INT — 외래 키 → 소방서정보.fnum — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 시네마 릴레이션 (REL_BUILDING_CINEMA)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- 영화상영관코드 (movie_theater_code) — INT — 외래 키 → 영화상영관.영화상영관코드
- distance — DECIMAL(13,8)
용도별건물과 유치원 릴레이션 (REL_BUILDING_KINDERGARDEN)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- kid — INT — 외래 키 → 유치원정보.kid
- distance — DECIMAL(13,8)
용도별건물과 은행 릴레이션 (REL_BUILDING_BANK)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- cn — INT — 외래 키 → 은행정보.cn
- distance — DECIMAL(13,8)
용도별건물과 전국CCTV 릴레이션 (REL_BUILDING_NATIONAL_CCTV)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- number — INT — 외래 키 → 전국CCTV정보.number — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 주차장 릴레이션 (REL_BUILDING_PARKING_LOT)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- prkplceno — VARCHAR(255) — 외래 키 → 주차장정보.prkplceno
- distance — DECIMAL(13,8)
용도별건물과 지하철 릴레이션 (REL_BUILDING_SUBWAY)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- code — INT — 외래 키 → 지하철정보.code — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 토지특성 릴레이션 (REL_BUILDING_LAND)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- land_serial_number — BIGINT — 외래 키 → 토지특성정보.land_serial_number — NOT NULL
용도별건물과 학교 릴레이션 (REL_BUILDING_SCHOOL)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- sn — INT — 외래 키 → 학교정보.sn — NOT NULL
- distance — DECIMAL(13,8)
용도별건물과 학원 릴레이션 (REL_BUILDING_ACADEMY)
- building_identification_number — INT — 외래 키 → 용도별건물.building_identification_number — NOT NULL
- academy_designation_number — BIGINT — 외래 키 → 학원정보.academy_designation_number
- distance — DECIMAL(13,8)
유치원정보 (KINDERGARDEN)
- kid — INT — 기본 키
- name_of_office_of_education — VARCHAR(255)
- name_of_the_office_of_education — VARCHAR(255)
- name_of_kindergarten — VARCHAR(255)
- type_of_establishment — VARCHAR(255)
- name_of_representative — VARCHAR(255)
- name_of_director — VARCHAR(255)
- date_of_establishment — INT
- opening_day — INT
- address — VARCHAR(255)
- phone_number — VARCHAR(255)
- homepage — VARCHAR(255)
- three_year_old_school_series — INT
- four_year_old_school_year_old — INT
- five_year_old_school_series — INT
- mixed_academic_water_supply — INT
- specialized_school_series — INT
- three_year_old_infant — INT
- four_year_old_infant — INT
- five_year_old_infant — INT
- mixed_infant — INT
- special_infant — INT
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
은행정보 (BANK)
- cn — INT — 기본 키
- mega_nm — VARCHAR(255)
- mega_cd — INT
- cty_nm — VARCHAR(255)
- cty_cd — INT
- x_axis — INT
- y_axis — INT
- bank_nm — VARCHAR(255)
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
일별 박스오피스 (DAILY_BOX_OFFICE)
- 일자 (date) — INT — 외래 키 → 일자 릴레이션.일자 — NOT NULL
- 영화명 (movie_name) — VARCHAR(255) — 외래 키 → 영화정보.영화명 — NOT NULL
- 순위 (ranking) — INT
- 개봉일 (release_date) — INT
- 매출액 (sales) — VARCHAR(255)
- 매출액(점유율) (revenue) — VARCHAR(255)
- 매출액증감(전일대비) (increase_or_decrease_in_sales) — VARCHAR(255)
- 매출액증감율(전일대비) (sales_increase_and_decrease_rate) — VARCHAR(255)
- 누적매출액 (accumulated_sales) — VARCHAR(255)
- 관객수 (audience_count) — VARCHAR(255)
- 관객수증감(전일대비) (audience_increase_and_decrease) — VARCHAR(255)
- 관객수증감율(전일대비) (audience_increase_and_decrease_rate) — VARCHAR(255)
- 누적관객수 (cumulative_audience_count) — VARCHAR(255)
- 스크린수 (number_of_screens) — VARCHAR(255)
- 상영횟수 (number_of_screenings) — VARCHAR(255)
- 대표국적 (representative_nationality) — VARCHAR(255)
- 국적 (nationality) — VARCHAR(255)
- 제작사 (production_company) — VARCHAR(255)
- 배급사 (distributor) — VARCHAR(255)
- 등급 (rating) — VARCHAR(255)
- 장르 (genre) — VARCHAR(255)
- 감독 (direct) — VARCHAR(255)
- 배우 (actor) — LONGTEXT
일자 릴레이션 (REL_DATE)
- 일자 (date) — INT — 기본 키 — NOT NULL
전국CCTV정보 (NATIONAL_CCTV)
- number — INT — 기본 키 — NOT NULL
- name_of_management_agency — VARCHAR(255)
- location_road_address — VARCHAR(255)
- location_number_address — VARCHAR(255)
- installation_purpose — VARCHAR(255)
- camera_count — INT
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
전국기상정보 (WEATHER)
- weather_id — BIGINT — 기본 키
- place_id — INT — 외래 키 → 메타데이터 관측지점 정보.place_id — NOT NULL
- temperature — FLOAT
- precipitation — FLOAT
- precipitation_qc — FLOAT
- wind_speed — FLOAT
- direction_wind — FLOAT
- wetness — FLOAT
- fine_dust_grade — VARCHAR(255)
- fine_dust_1h — INT
- fine_particulate_matter_grade — VARCHAR(255)
- fine_particulate_matter_1h — INT
- ozone_grade — VARCHAR(255)
- ozone_1h — FLOAT
- co2_grade — VARCHAR(255)
- co2_1h — FLOAT
- co_grade — VARCHAR(255)
- co_1h — FLOAT
- sulfite_gas_grade — VARCHAR(255)
- sulfite_gas_1h — FLOAT
주차장정보 (PARKING_LOT)
- prkplceno — VARCHAR(255) — 기본 키
- prkplcenm — VARCHAR(255)
- prkplcese — VARCHAR(255)
- prkplcetype — VARCHAR(255)
- rdnmadr — VARCHAR(255)
- lnmadr — VARCHAR(255)
- prkcmprt — INT
- feedingse — VARCHAR(255)
- enforcese — VARCHAR(255)
- operday — VARCHAR(255)
- weekdayoperopenhhmm — VARCHAR(255)
- weekdayopercolsehhmm — VARCHAR(255)
- satoperoperopenhhmm — VARCHAR(255)
- satoperclosehhmm — VARCHAR(255)
- holidayoperopenhhmm — VARCHAR(255)
- holidaycloseopenhhmm — VARCHAR(255)
- parkingchrgeinfo — VARCHAR(255)
- basictime — INT
- basiccharge — INT
- addunittime — VARCHAR(255)
- addunitcharge — VARCHAR(255)
- daycmmtktadjtime — INT
- daycmmtkt — INT
- monthcmmtkt — INT
- metpay — VARCHAR(255)
- spcmnt — LONGTEXT
- institutionnm — VARCHAR(255)
- phonenumber — VARCHAR(255)
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
- referencedate — VARCHAR(255)
- insttcode — VARCHAR(255)
지하철정보 (SUBWAY)
- code — INT — 기본 키 — NOT NULL
- line — VARCHAR(255)
- name — VARCHAR(255)
- lat — DECIMAL(13,8)
- lng — DECIMAL(13,8)
토지특성과 생활인구 릴레이션 (REL_LAND_LIVING_POPULATION)
- borough_code — INT — 외래 키 → 생활인구정보.borough_code
- base_date_id — INT — 외래 키 → 생활인구정보.base_date_id
- time_zone — INT — 외래 키 → 생활인구정보.time_zone
- land_serial_number — BIGINT — 외래 키 → 토지특성정보.land_serial_number — NOT NULL
토지특성정보 (LAND_CHARACTERISTIC)
- land_serial_number — BIGINT — 기본 키 — NOT NULL
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)
- place_id — INT
- unique_number — BIGINT
- cour_dong_name — VARCHAR(255)
- lot_number — VARCHAR(255)
- pointing_name — VARCHAR(255)
- land_area — FLOAT
- purpose_area_name1 — VARCHAR(255)
- purpose_area_name2 — VARCHAR(255)
- land_movement_status — VARCHAR(255)
- land_height — VARCHAR(255)
- land_shape — VARCHAR(255)
- road_surface — VARCHAR(255)
- officially_assessed_land_price — BIGINT
학교정보 (SCHOOL)
- sn — INT — 기본 키 — NOT NULL
- adres — VARCHAR(255)
- schoolname — VARCHAR(255)
- region — VARCHAR(255)
- y_value — DECIMAL(13,8)
- x_value — DECIMAL(13,8)
학원정보 (ACADEMY)
- academy_designation_number — BIGINT — 기본 키
- city_office_of_education_code — VARCHAR(255)
- provincial_office_of_education — VARCHAR(255)
- administrative_district_name — VARCHAR(255)
- academy_classroom_name — VARCHAR(255)
- academy_name — VARCHAR(255)
- date_of_establishment — INT
- registration_date — INT
- registration_status_name — VARCHAR(255)
- closing_start_date — INT
- closing_date — INT
- total_capacity — INT
- total_number_of_people_with_temporary_capacity — INT
- field_name — VARCHAR(255)
- teaching_department_name — VARCHAR(255)
- course_list_name — VARCHAR(255)
- course_name — VARCHAR(255)
- details_of_tuition_per_person — LONGTEXT
- whether_tuition_fees_are_disclosed — VARCHAR(255)
- dormitory_academy — VARCHAR(255)
- road_name_zip_code — INT
- street_name_address — VARCHAR(255)
- road_name_detailed_address — VARCHAR(255)
- insert_date — VARCHAR(255)
- latitude — DECIMAL(13,8)
- longitude — DECIMAL(13,8)