HAPPY_HOUSE

Tables (11)

crime_categories

  • crime_ctg_no — INT — Primary key — NOT NULL
  • ctg_name — VARCHAR(10)

crimes

  • crime_no — INT — Primary key — NOT NULL
  • dong_code — VARCHAR(10) — Foreign key → dongcodes.dong_code — NOT NULL
  • crime_ctg_no — INT — Foreign key → crime_categories.crime_ctg_no — NOT NULL
  • year — INT
  • count — INT
  • INDEX — `fk_crimes_dongcodes1_idx`
  • INDEX — `fk_crimes_crime_categories1_idx`

dongcodes

  • dong_code — VARCHAR(10) — Primary key — NOT NULL — 법정동코드
  • sido_name — VARCHAR(30) — 시도이름
  • gugun_name — VARCHAR(30) — 구군이름
  • dong_name — VARCHAR(30) — 동이름

facilities

  • facility_no — INT — Primary key — NOT NULL
  • dong_code — VARCHAR(10) — Foreign key → dongcodes.dong_code — NOT NULL
  • facility_ctg_no — INT — Foreign key → facility_categories.facility_ctg_no — NOT NULL
  • name — VARCHAR(30)
  • address — VARCHAR(50)
  • latitude — VARCHAR(45)
  • longitude — VARCHAR(45)
  • INDEX — `fk_facilities_dongcodes1_idx`
  • INDEX — `fk_facilities_facility_categories1_idx`

facility_categories

  • facility_ctg_no — INT — Primary key — NOT NULL
  • ctg_name — VARCHAR(10)

favorite_facilities

  • favorite_facility_no — INT — Primary key — NOT NULL
  • member_no — INT — Foreign key → members.member_no — NOT NULL
  • facility_no — INT — Foreign key → facilities.facility_no — NOT NULL
  • INDEX — `fk_favorite_facilities_members1_idx`
  • INDEX — `fk_favorite_facilities_facilities1_idx`

favorite_housedeals

  • favorite_houseinfo_no — INT — Primary key — NOT NULL
  • member_no — INT — Foreign key → members.member_no — NOT NULL
  • apt_seq — VARCHAR(20) — Foreign key → houseinfos.apt_seq — NOT NULL
  • INDEX — `fk_favorite_housedeals_members1_idx`
  • INDEX — `fk_favorite_housedeals_houseinfos1_idx`

housedeals

  • no — INT — Primary key — NOT NULL — 거래번호
  • apt_seq — VARCHAR(20) — Foreign key → houseinfos.apt_seq — 아파트코드
  • apt_dong — VARCHAR(40) — 아파트동
  • floor — VARCHAR(3) — 아파트층
  • deal_year — INT — 거래년도
  • deal_month — INT — 거래월
  • deal_day — INT — 거래일
  • exclu_use_ar — DECIMAL(7, 2) — 아파트면적
  • deal_amount — VARCHAR(10) — 거래가격
  • INDEX — `apt_seq_to_house_info_idx`

houseinfos

  • apt_seq — VARCHAR(20) — Primary key — NOT NULL — 아파트코드
  • sgg_cd — VARCHAR(5) — 시군구코드
  • umd_cd — VARCHAR(5) — 읍면동코드
  • umd_nm — VARCHAR(20) — 읍면동이름
  • jibun — VARCHAR(10) — 지번
  • road_nm_sgg_cd — VARCHAR(5) — 도로명시군구코드
  • road_nm — VARCHAR(20) — 도로명
  • road_nm_bonbun — VARCHAR(10) — 도로명기초번호
  • road_nm_bubun — VARCHAR(10) — 도로명추가번호
  • apt_nm — VARCHAR(40) — 아파트이름
  • build_year — INT — 준공년도
  • latitude — VARCHAR(45) — 위도
  • longitude — VARCHAR(45) — 경도

members

  • member_no — INT — Primary key — NOT NULL
  • id — VARCHAR(20)
  • password — VARCHAR(20)
  • name — VARCHAR(45)
  • email — VARCHAR(50)
  • role — VARCHAR(10)

notices

  • notice_no — INT — Primary key — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • register_time — TIMESTAMP — NOT NULL
  • member_no — INT — Foreign key → members.member_no — NOT NULL
  • INDEX — `fk_notices_members1_idx`