HappyHouse
Tables (9)
bunyang
- bid — int — Primary key — NOT NULL
- bname — varchar(50)
- bstate — varchar(50)
- bdate — date
- btype — varchar(50)
- blocation — varchar(100)
dongcode
- num — char(10) — Primary key — NOT NULL
- city — varchar(50)
- code — varchar(50)
- dongcode — varchar(50)
- gugun — varchar(50)
- dong — varchar(50)
- lat — varchar(50)
- lng — varchar(50)
guguncode
- gugun_code — varchar(10) — Primary key — NOT NULL
- gugun_name — varchar(30)
housedeal
- no — int — Primary key — NOT NULL
- dong — varchar(30) — NOT NULL
- AptName — varchar(50) — NOT NULL
- code — varchar(30) — NOT NULL
- dealAmount — varchar(50) — NOT NULL
- buildYear — varchar(30)
- dealYear — varchar(30)
- dealMonth — varchar(30)
- dealDay — varchar(30)
- area — varchar(30)
- floor — varchar(30)
- jibun — varchar(30)
- type — varchar(30)
- rentMoney — varchar(30)
- img — varchar(50)
houseinfo
- no — int — Primary key — NOT NULL
- dong — varchar(30) — NOT NULL
- aptName — varchar(50) — NOT NULL
- code — varchar(30) — NOT NULL
- buildYear — varchar(30)
- jibun — varchar(30)
- lat — varchar(30)
- lng — varchar(30)
- img — varchar(50)
interestarea
- aid — int — Primary key — NOT NULL
- uid — varchar(50)
- dong — varchar(50)
- dongcode — varchar(50) — NOT NULL
recently_visited
- uid — varchar(50) — Primary key — NOT NULL
- no — int — Primary key — NOT NULL
- rid — datetime
seoul_apart_avg_deal
- gu_name — varchar(10) — Primary key — NOT NULL
- deal_month — int — Primary key — NOT NULL
- avg_deal_price — int
sidocode
- sido_code — varchar(10) — Primary key — NOT NULL
- sido_name — varchar(30)