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)