home ssafy

Tables (7)

Board (board)

  • id — int — Primary key
  • user_id — varchar(40) — Foreign key → User.id
  • title — varchar(30) — NOT NULL
  • content — varchar(1000) — NOT NULL
  • hit — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

Comment (comment)

  • id — int — Primary key
  • user_id — varchar(40) — Foreign key → User.id
  • board_id — int — Foreign key → Board.id
  • content — varchar(1000) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

Like_Area (like_area)

  • user_id — varchar(40) — Foreign key → User.id
  • dongCode — varchar(10) — Foreign key → dongcode.dongCode — NOT NULL
  • created_at — timestamp

User (user)

  • id — varchar(40) — Primary key
  • password — varchar(100) — NOT NULL
  • nickname — varchar(40) — NOT NULL
  • created_at — timestamp

dongcode

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

housedeal

  • no — bigint — Primary key — NOT NULL
  • aptCode — bigint — Foreign key → houseinfo.aptCode — NOT NULL
  • dealAmount — varchar(20)
  • dealYear — int
  • dealMonth — int
  • dealDay — int
  • area — varchar(20)
  • floor — varchar(4)
  • cancelDealType — varchar(1)

houseinfo

  • aptCode — bigint — Primary key — NOT NULL
  • dongCode — varchar(10) — Foreign key → dongcode.dongCode — 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)
  • landCode — varchar(1)
  • apartmentName — varchar(40)
  • jibun — varchar(10)
  • lng — varchar(30)
  • lat — varchar(30)