house

Tables (6)

board

  • board_no — INT — Primary key — NOT NULL
  • subject — VARCHAR(20) — NOT NULL
  • content — VARCHAR(20) — NOT NULL
  • post_date — TIMESTAMP — NOT NULL
  • id — VARCHAR(20) — Foreign key → userinfo.id — NOT NULL
  • INDEX — `id`

dongcode

  • dongCode — VARCHAR(10) — Primary key — NOT NULL
  • sidoName — VARCHAR(30)
  • gugunName — VARCHAR(30)
  • dongName — VARCHAR(30)

housedeal

  • no — BIGINT — Primary key — NOT NULL
  • dealAmount — VARCHAR(20)
  • dealYear — INT
  • dealMonth — INT
  • dealDay — INT
  • area — VARCHAR(20)
  • floor — VARCHAR(4)
  • cancelDealType — VARCHAR(1)
  • aptCode — BIGINT — Foreign key → houseinfo.aptCode
  • INDEX — `housedeal_aptCode_houseinfo_aptCode_fk_idx`

houseinfo

  • aptCode — BIGINT — Primary key — NOT NULL
  • buildYear — INT
  • roadName — VARCHAR(40)
  • roadNameBonbun — VARCHAR(5)
  • roadNameBubun — VARCHAR(5)
  • roadNameSeq — VARCHAR(2)
  • roadNameBasementCode — VARCHAR(1)
  • roadNameCode — VARCHAR(7)
  • dong — VARCHAR(40)
  • bonbun — VARCHAR(4)
  • bubun — VARCHAR(4)
  • sigunguCode — VARCHAR(5)
  • eubmyundongCode — VARCHAR(5)
  • dongCode — VARCHAR(10) — Foreign key → dongcode.dongCode
  • landCode — VARCHAR(1)
  • apartmentName — VARCHAR(40)
  • jibun — VARCHAR(10)
  • lng — VARCHAR(30)
  • lat — VARCHAR(30)
  • INDEX — `houseinfo_dongCode_dongcode_dongCode_fk_idx`

uattention

  • ano — INT — Primary key — NOT NULL
  • id — VARCHAR(20) — Foreign key → userinfo.id — NOT NULL
  • aptCode — BIGINT — Foreign key → housedeal.aptCode — NOT NULL
  • INDEX — `id`
  • INDEX — `aptCode`

userinfo

  • id — VARCHAR(20) — Primary key — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • address — VARCHAR(100) — NOT NULL