apart
Tables (6)
Ingredients (Untitled)
- iduser — int — Foreign key → Member.iduser — NOT NULL
- salt — varchar(100)
Member
- iduser — int — Primary key — NOT NULL
- id — varchar(45)
- pw — varchar(100)
- name — varchar(45)
- email — varchar(45)
- role (Field) — enum
dongcode
- dongCode — varchar(10) — Primary key — NOT NULL
- sidoName — varchar(30)
- gugunName — varchar(30)
- dongName — varchar(30)
favorites (Untitled2)
- iduser — int — Foreign key → Member.iduser — NOT NULL
- sidoName (Field) — varchar(40)
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
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)