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