HoshinoHome
Tables (8)
Comment
- comment_id — INT
- post_id — INT
- board_type — VARCHAR(50)
- user_id — INT — Foreign key → UserInfo.user_id
- user_name — VARCHAR(50)
- content — VARCHAR(255)
- date — TIMESTAMP
DongStory
- post_id — INT — Primary key — NOT NULL
- dong_code — varchar(10) — Foreign key → dong.dong_code — NOT NULL
- title — VARCHAR(45)
- content — VARCHAR(45)
- date — DATETIME
- user_id — int — Foreign key → UserInfo.user_id — NOT NULL
Enviroment
- dong_code — varchar(10) — Foreign key → dong.dong_code — NOT NULL
- station_proximity — INT
- commercial_area — INT
- Academic_num — INT
- Security_Index — INT
- dong_score — INT
Notice
- post_id — INT — Primary key — NOT NULL
- title — VARCHAR(45)
- content — VARCHAR(45)
- date — DATETIME
UserInfo
- user_id — int — Primary key — NOT NULL
- user_name — varchar(50) — NOT NULL
- user_password — varchar(100) — NOT NULL
- user_address — varchar(100) — NOT NULL
- user_favorite_place — varchar(100) — NOT NULL
- user_type — varchar(10) — NOT NULL
dong
- dong_code — varchar(10) — Primary key — NOT NULL
- si_do_name — varchar(30)
- gu_gun_name — varchar(30)
- dong_name — varchar(30)
housedeal
- deal_code — bigint — Primary key — NOT NULL
- deal_type — INT — NOT NULL
- deal_amount — varchar(20)
- deposit_amount — varchar(20)
- monthly_amount — varchar(20)
- jibun_address — varchar(40)
- road_address — varchar(40)
- deal_year — int
- deal_month — int
- deal_day — int
- area — varchar(20)
- floor — varchar(4)
- house_code — bigint — Foreign key → houseinfo.house_code
- house_type — int
houseinfo
- house_code — bigint — Primary key — NOT NULL
- house_type — int — NOT NULL
- build_year — int
- dong_code — varchar(10) — Foreign key → dong.dong_code
- house_name — varchar(30)
- si_gun_gu_name — varchar(20)
- dong_name — varchar(20)
- road_name — varchar(20)
- bonbun — varchar(5)
- bubun — varchar(5)
- jibun_address — varchar(40)
- road_address — VARCHAR(40)
- lng — varchar(30)
- lat — varchar(30)