db관통프로젝트

테이블 (9)

dongcode

  • dongCode (pk) — varchar(10) — 기본 키 — NOT NULL
  • sidoName — varchar(30)
  • gugunName — varchar(30)
  • dongName — varchar(30)

housedeal

  • no (pk) — bigint — 기본 키 — NOT NULL
  • aptCode (fk) — bigint — 외래 키 → houseinfo.aptCode — NOT NULL
  • dealAmount — varchar(20)
  • dealYear — int
  • dealMonth — int
  • dealDay — int
  • area — varchar(20)
  • floor — varchar(4)
  • cancelDealType — varchar(1)

houseinfo

  • aptCode (pk) — bigint — 기본 키 — NOT NULL
  • dongCode (fk) — varchar(10) — 외래 키 → 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)

member

  • no (pk) — int — 기본 키 — NOT NULL
  • name — varchar(20) — NOT NULL
  • email — varchar(30) — NOT NULL
  • user_enc_password — varchar(256) — NOT NULL
  • ssn — varchar(1000) — NOT NULL

member_login_attempt

  • no (pk) — int — 기본 키 — NOT NULL
  • member_no (fk) — int — 외래 키 → member.no — NOT NULL
  • count — int — NOT NULL
  • login_recent_attempt — datetime — NOT NULL

member_secret

  • no (pk) — int — 기본 키 — NOT NULL
  • member_no (fk) — int — 외래 키 → member.no — NOT NULL
  • salt — varchar(1000) — NOT NULL
  • ssn_key — varchar(128) — NOT NULL

wish_deal_list

  • id (pk) — int — 기본 키 — NOT NULL
  • member_no (fk) — int — 외래 키 → member.no — NOT NULL
  • housedeal_no (fk2) — bigint — 외래 키 → housedeal.no — NOT NULL
  • created_at — timestamp — NOT NULL

wish_dong_list

  • id (pk) — int — 기본 키 — NOT NULL
  • no (fk) — int — 외래 키 → member.no — NOT NULL
  • dongCode (fk2) — varchar(10) — 외래 키 → dongcode.dongCode — NOT NULL
  • created_at — timestamp — NOT NULL

wish_house_list (관심 주택 정보)

  • id (Key) — int — 기본 키 — NOT NULL
  • no (fk) — int — 외래 키 → member.no — NOT NULL
  • aptCode (fk2) — bigint — 외래 키 → houseinfo.aptCode — NOT NULL
  • created_at — timestamp — NOT NULL