budongbudong

Tables (5)

APT (단지 정보)

  • apt_id (PK) — VARCHAR — Primary key — NOT NULL
  • dong_code (FK) — VARCHAR — Foreign key → DONG_CODE.dong_code — NOT NULL
  • apt_name (아파트이름) — VARCHAR
  • total_dong (총 동 수) — VARCHAR
  • sale_price (매매가) — VARCHAR
  • rent_price (전세가) — VARCHAR
  • total_households (총세대수) — VARCHAR
  • apt_floor (아파트 저/최고층) — VARCHAR
  • approval_date (사용승인일) — VARCHAR
  • total_parking_lot (총주차대수) — VARCHAR
  • floor_area_ratio (용적률) — VARCHAR
  • building_land_ratio (건폐율) — VARCHAR
  • construction_company (건설사) — VARCHAR
  • heating_system (난방) — VARCHAR
  • management_office (관리사무소) — VARCHAR
  • apt_address (아파트 주소) — VARCHAR
  • school_name (학군 이름) — VARCHAR
  • school_dist (아파트 학군 거리) — VARCHAR
  • school_address (학군 주소) — VARCHAR
  • apt_hit (조회수) — INT
  • total_score (종합 점수) — INT
  • interior_score (인테리어 점수) — INT
  • facilities_score (편의시설 점수) — INT

APT_AREA (단지 내 면적별 정보)

  • apt_area_id (PK) — INT — Primary key — NOT NULL
  • apt_area (PK2) — VARCHAR — Primary key — NOT NULL
  • apt_id (PK3) — VARCHAR — Foreign key → APT.apt_id — NOT NULL
  • apt_area_img (면적별 이미지) — VARCHAR
  • apt_area_supply_exclusive (공급면적/전용면적) — VARCHAR
  • total_room (방수/욕실수) — VARCHAR
  • apt_area_total_households (해당면적세대수) — VARCHAR
  • front_door_structure (현관구조) — VARCHAR
  • price (공시가격) — VARCHAR
  • apt_area_real_trans (해당면적매물) — VARCHAR
  • administration_cost (관리비) — VARCHAR
  • holding_tax (보유세) — VARCHAR
  • upper_limit_sale (매매상한가) — VARCHAR
  • lower_limit_sale (매매하한가) — VARCHAR
  • upper_limit_rent (전세상한가) — VARCHAR
  • lower_limit_rent (전세하한가) — VARCHAR
  • sale_comp_rent (매매가대비전세가) — VARCHAR

APT_REAL_HISOTRY (단지 내 면적 별 실거래가 내역)

  • apt_real_history_id (PK) — INT — Primary key — NOT NULL
  • apt_area_id (FK) — INT — Foreign key → APT_AREA.apt_area_id — NOT NULL
  • apt_area (FK2) — VARCHAR — Foreign key → APT_AREA.apt_area — NOT NULL
  • apt_id (FK3) — VARCHAR — Foreign key → APT_AREA.apt_id — NOT NULL
  • apt_real_history_month (거래월) — VARCHAR
  • apt_real_history_type (거래타입) — VARCHAR("매매", "전세")
  • apt_real_history_price (거래가) — VARCHAR

APT_REAL_TRANS (매물)

  • apt_real_trans_id (INT) — VARCHAR — Primary key — NOT NULL
  • apt_id (FK) — VARCHAR — Foreign key → APT.apt_id — NOT NULL
  • apt_real_trans_name (매물명) — VARCHAR
  • apt_real_trans_price (가격) — VARCHAR
  • apt_real_trans_img (매물이미지) — VARCHAR
  • apt_real_trans_floor (층) — VARCHAR
  • apt_real_trans_dir (방향) — VARCHAR
  • apt_real_trans_area (면적) — VARCHAR

DONG_CODE (주소코드)

  • dong_code (PK) — VARCHAR — Primary key — NOT NULL
  • sido_name (시, 도) — VARCHAR
  • gugun_name (구, 군) — VARCHAR
  • dong_name (동) — VARCHAR