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