ssafyhome

Tables (10)

crime_categories

  • crime_ctg_no — INT — Primary key — NOT NULL — Auto Incremental, 범죄종류번호
  • ctg_name (Field) — VARCHAR(10) — 범죄명

crimes

  • crime_no — INT — Primary key — NOT NULL — Auto Incremental, 범죄번호
  • 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 — 범죄건수

dongcodes

  • dong_code — VARCHAR(10) — Primary key — NOT NULL
  • sido_name — VARCHAR(30)
  • gugun_name — VARCHAR(30)
  • dong_name — VARCHAR(30)

facilities

  • facilities_no — INT — Primary key — NOT NULL — Auto Incremental
  • 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) — 경도

facility_categories

  • facility_ctg_no — INT — Primary key — NOT NULL — Auto Incremental
  • ctg_name — VARCHAR(10) — 카테고리명

favorite_facilities

  • favorite_facilities_no — INT — Primary key — NOT NULL — Auto Incremental
  • facilities_no — INT — Foreign key → facilities.facilities_no — NOT NULL
  • members_no — INT — Foreign key → members.members_no — NOT NULL

favorite_housedeals

  • favorite_housedeals_no — INT — Primary key — NOT NULL — Auto Incremental
  • no — INT — Foreign key → housedeals.no — NOT NULL
  • members_no — INT — Foreign key → members.members_no — NOT NULL

housedeals

  • no — INT — Primary key — NOT NULL — Auto Incremental
  • apt_seq — VARCHAR(20) — Foreign key → houseinfos.apt_seq — NOT NULL
  • 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)

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

  • members_no — INT — Primary key — NOT NULL — Auto Incremental
  • id — VARCHAR(20)
  • password — VARCHAR(20)
  • name — VARCHAR(45)
  • email — VARCHAR(50)
  • role — VARCHAR(10) — admin, user, estate 등