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)