SSAFYHOME

Tables (7)

board

  • board_no — INT — Primary key — NOT NULL
  • id — VARCHAR(20) — Foreign key → userinfo.id — NOT NULL
  • subject — VARCHAR(20) — NOT NULL
  • content — VARCHAR(20) — NOT NULL
  • post_date — TIMESTAMP — 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)
  • nearest_station — INT — Foreign key → station.station_code
  • INDEX — `houseinfo_dongCode_dongcode_dongCode_fk_idx`
  • INDEX — `station_info_idx`

station

  • station_code — INT — Primary key — NOT NULL
  • station_name — VARCHAR(45)
  • station_name_en — VARCHAR(45)
  • station_name_ja — VARCHAR(45)
  • station_name_ch — VARCHAR(45)
  • line — VARCHAR(45)
  • stationcol — VARCHAR(45)
  • lng — VARCHAR(45)
  • lat — VARCHAR(45)

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
  • pw — VARCHAR(64) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • address — VARCHAR(100) — NOT NULL