테이블구조_2안_위치_카테고리분리

테이블 (16)

building (건물)

  • ppk (표제부pk) — varchar(33) — 기본 키 — NOT NULL
  • complex_key (단지키) — varchar(9) — 외래 키 → complex.complex_key — NOT NULL
  • road_name_address_number (도로명주소번호)
  • road_name_address (도로명주소)
  • dong_name (동명)
  • main_sub_division_code (주무속구분명)
  • building_area (건축면적)
  • total_floor_area (연면적)
  • buildingcoverage_rate (건폐율)
  • floorarea_rate (용적률)
  • building_height (건물면적)
  • ground_floor_count (지상층면적)
  • underground_floor_count (지하면적)
  • use_approval_date (사용승인일)
  • building_elevator_count (엘리베이터 수)
  • building_parking_count (주차대수)
  • household_count (세대수)
  • family_count (가구수)
  • ho_count (호수)
  • structure_name (구조명)
  • roof_name (지붕명)
  • road_name_address_number (도로명주소2) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL

building_notice_price (건물공시가격)

  • notice_standard_ym (공시기준년월) — char(6) — 기본 키 — NOT NULL
  • jpk (전유부pk) — varchar(33) — 외래 키 → building_property.jpk — NOT NULL
  • ppk (표제부pk) — varchar(33) — 외래 키 → building_property.ppk — NOT NULL
  • notice_price (공시가격)
  • unit_notice_price (제곱미터당공시가격)
  • unit_notice_price_pyeong (평당공시가격)
  • road_name_address_number (도로명주소) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL

building_owner (건물소유자)

  • owner_index (소유자번호) — numeric — 기본 키 — NOT NULL
  • jpk (전유부pk) — varchar(33) — 외래 키 → building_property.jpk — NOT NULL
  • ppk (표제부pk) — varchar(33) — 외래 키 → building_property.ppk — NOT NULL
  • owner_name (소유자명)
  • owner_registration_number (소유자등록번호)
  • owner_division_name (소유자구분명)
  • owner_age (소유자연령)
  • owner_age_division_name (소유자연령대)
  • owner_gender (소유자성별)
  • owner_address (소유자주소)
  • public_rate (지분률)
  • change_date (소유권변동일자)
  • change_reason (소유권변동원인)
  • road_name_address_number (도로명주소) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL

building_property (건물자산)

  • jpk (전유부pk) — varchar(33) — 기본 키 — NOT NULL
  • ppk (표제부pk) — varchar(33) — 외래 키 → building.ppk — NOT NULL
  • building_document_division_name (건축물대장_구분명)
  • owner_count (소유자수)
  • floor_number (층수)
  • ho_name (호명)
  • main_purpose_code (주용도코드)
  • main_purpose_name (주용도명)
  • private_area (전용면적)
  • public_area (공용면적)
  • registry_realestate_identification_key (등기고유번호)
  • kb_house_identification_key (kb단지키)
  • kb_house_type_division_number (kb면적키)
  • rtech_apartment_series_number (rtech단지키)
  • rtech_pyeong_series_number (rtech면적키)
  • road_name_address_number (도로명주소) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL
  • recent_owner_change_date (최근소유권변동일자)

building_sise (건물시세)

  • sise_standard_ym (시세기준년월) — char(6) — 기본 키 — NOT NULL
  • jpk (전유부pk) — varchar(33) — 외래 키 → building_property.jpk — NOT NULL
  • ppk (표제부pk) — varchar(33) — 외래 키 → building_property.ppk — NOT NULL
  • sise (시세)
  • upper_limit_sise (시세상한가)
  • lower_limit_sise (시세하한가)
  • unit_sise (제곱미터당시세)
  • unit_sise_pyeong (평당시세)
  • road_name_address_number (도로명주소) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL

bunyang (분양)

  • house_management_number (분양관리번호) — char(10) — 기본 키 — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_location.pnu — NOT NULL

bunyang_area_type (분양면적타입)

  • house_type (주택타입) — varchar(20) — 기본 키 — NOT NULL
  • pyeong_name (평이름) — varchar(20) — 기본 키 — NOT NULL
  • house_management_number (분양관리번호) — char(10) — 외래 키 → bunyang.house_management_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → bunyang.pnu — NOT NULL

complex (단지)

  • complex_key (단지키) — varchar(9) — 기본 키 — NOT NULL
  • complex_name (단지명)
  • complex_household_count (단지세대수)
  • road_name_address_number (도로명주소) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL

house (주택)

  • jpk (전유부pk) — varchar(33) — 외래 키 → building_property.jpk — NOT NULL
  • ppk (표제부pk) — varchar(33) — 외래 키 → building_property.ppk — NOT NULL
  • house_division_name (주택분류명)
  • supply_area (공급면적)
  • pyeong (평형)
  • pyeong_type_name (평형타입명)
  • road_name_address_number (도로명주소) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL

house_realdeal (주택실거래)

  • deal_number (거래번호) — numeric — 기본 키 — NOT NULL
  • deal_building_number (거래건물번호) — numeric — 기본 키 — NOT NULL
  • deal_house_division_name (거래주택분류) — varchar(10) — 기본 키 — NOT NULL
  • deal_division_name (거래구분이름) — varchar(10) — 기본 키 — NOT NULL
  • complex_key (단지키) — varchar(9) — 외래 키 → complex.complex_key — NOT NULL
  • road_name_address_number (도로명주소) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL

land (토지)

  • pnu (토지고유번호) — 외래 키 → pnu_location.pnu — NOT NULL
  • land_number_address (지번주소)
  • legaldong_name (법정동명)
  • land_document_division_name (토지대장구분명)
  • land_area (토지면적)
  • land_purpose_name (지목)
  • purpose_region (용도지역)
  • land_use_situation (토지이용상황)
  • land_shape_height (지형고저)
  • land_shape (지형형상)
  • road_boundary_type (도로접면)
  • standard_land_is (표준지여부)
  • owner_count (소유자수)
  • registry_realestate_identification_key (등기고유번호)
  • recent_owner_change_date (최근소유권변동일자)

land_notice_price (공시지가)

  • notice_standard_ym (공시기준년월) — char(6) — 기본 키 — NOT NULL
  • pnu (토지고유번호) — 외래 키 → land.pnu — NOT NULL
  • notice_price (공시가격)
  • unit_notice_price (제곱미터당공시가격)
  • unit_notice_price_pyeong (평당공시가격)

land_owner (토지소유자)

  • owner_index (소유자번호) — numeric — 기본 키 — NOT NULL
  • pnu (토지고유번호) — 외래 키 → land.pnu — NOT NULL
  • owner_name (소유자명)
  • owner_registration_number (소유자등록번호)
  • owner_division_name (소유자구분명)
  • owner_age (소유자연령)
  • owner_age_division_name (소유자연령대)
  • owner_gender (소유자성별)
  • owner_address (소유자주소)
  • public_rate (지분률)
  • change_date (소유권변동일자)
  • change_reason (소유권변동원인)

non_house_realdeal (비주택실거래)

  • complex_key (단지키) — varchar(9) — 외래 키 → complex.complex_key — NOT NULL
  • road_name_address_number (도로명주소) — 외래 키 → pnu_roadname_location.road_name_address_number — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_roadname_location.pnu — NOT NULL

pnu_location (pnu_위치)

  • pnu (토지고유번호) — 기본 키 — NOT NULL
  • x (x좌표)
  • y (y좌표)

pnu_roadname_location (pnu_도로명_위치)

  • road_name_address_number (도로명주소) — 기본 키 — NOT NULL
  • pnu (토지고유번호) — 외래 키 → pnu_location.pnu — NOT NULL
  • x
  • y