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