SSAFYHOME
Tables (7)
board
- board_no — INT — Primary key — NOT NULL
- id — VARCHAR(20) — Foreign key → userinfo.id — NOT NULL
- subject — VARCHAR(20) — NOT NULL
- content — VARCHAR(20) — NOT NULL
- post_date — TIMESTAMP — 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)
- nearest_station — INT — Foreign key → station.station_code
- INDEX — `houseinfo_dongCode_dongcode_dongCode_fk_idx`
- INDEX — `station_info_idx`
station
- station_code — INT — Primary key — NOT NULL
- station_name — VARCHAR(45)
- station_name_en — VARCHAR(45)
- station_name_ja — VARCHAR(45)
- station_name_ch — VARCHAR(45)
- line — VARCHAR(45)
- stationcol — VARCHAR(45)
- lng — VARCHAR(45)
- lat — VARCHAR(45)
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
- pw — VARCHAR(64) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- address — VARCHAR(100) — NOT NULL