home ssafy
Tables (7)
Board (board)
- id — int — Primary key
- user_id — varchar(40) — Foreign key → User.id
- title — varchar(30) — NOT NULL
- content — varchar(1000) — NOT NULL
- hit — int — NOT NULL
- created_at — timestamp
- updated_at — timestamp
Comment (comment)
- id — int — Primary key
- user_id — varchar(40) — Foreign key → User.id
- board_id — int — Foreign key → Board.id
- content — varchar(1000) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
Like_Area (like_area)
- user_id — varchar(40) — Foreign key → User.id
- dongCode — varchar(10) — Foreign key → dongcode.dongCode — NOT NULL
- created_at — timestamp
User (user)
- id — varchar(40) — Primary key
- password — varchar(100) — NOT NULL
- nickname — varchar(40) — NOT NULL
- created_at — timestamp
dongcode
- dongCode — varchar(10) — Primary key — NOT NULL
- sidoName — varchar(30)
- gugunName — varchar(30)
- dongName — varchar(30)
housedeal
- no — bigint — Primary key — NOT NULL
- aptCode — bigint — Foreign key → houseinfo.aptCode — NOT NULL
- dealAmount — varchar(20)
- dealYear — int
- dealMonth — int
- dealDay — int
- area — varchar(20)
- floor — varchar(4)
- cancelDealType — varchar(1)
houseinfo
- aptCode — bigint — Primary key — NOT NULL
- dongCode — varchar(10) — Foreign key → 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)