houseapi
Tables (17)
Apart (tb_apart)
- apartId (고유id) — INT — Primary key
- apartName (아파트명) — VARCHAR(64)
- apartAddress (주소(도로명)) — VARCHAR(128)
- apartOrgAddress (주소(네이버)) — VARCHAR(128)
- createdAt (사용승인일) — DATE
- lat (위도) — FLOAT
- lon (경도) — FLOAT
- household (세대 수) — INT
- totalFloor (층 수) — INT
ApartDetail (tb_apart_detail)
- apartId (고유id) — INT — Foreign key → Apart.apartId
- constructor (시공사) — VARCHAR(64)
- parkingCount (주차 수) — INT
- heatMethod (난방방식) — VARCHAR(8)
- heatFuel (난방연료) — VARCHAR(8)
Auction (tb_auction)
- Key — Primary key — NOT NULL
- Field (경매)
Building (Untitled)
- id (빌딩id) — VARCHAR(32) — Primary key — NOT NULL
- apartId (고유id) — INT — Foreign key → Apart.apartId
- buildingAsmb (집합여부) — VARCHAR(4)
- buildingType (건물구분) — VARCHAR(8)
- structure (구조) — VARCHAR(16)
- purpose (목적) — VARCHAR(16)
- mainAtch (주건물) — VARCHAR(16)
Bunyang (tb_bunyang)
- id (Key) — INT — Primary key — NOT NULL
- platformId (플랫폼) — SMALLINT — Foreign key → Platform.platformId — NOT NULL
- apartId (고유id) — VARCHAR(16)
- apartName (주택명) — VARCHAR(64)
- apartAddress (주소) — VARCHAR(128)
- presaleAt (분양예정일) — DATE
- moveAt (입주예정일) — DATE
- detailUrl (상세링크) — VARCHAR(256)
- lat (위도) — FLOAT
- lon (경도) — FLOAT
- createdAt (공고일) — DATE
BunyangDetail (tb_bunyang_detail)
- Key — Primary key — NOT NULL
- bunyangId (분양) — INT — Foreign key → Bunyang.id — NOT NULL
- apartType (주택구분) — VARCHAR(4)
- constructor (건설사) — VARCHAR(64)
- phone (문의처) — VARCHAR(32)
- household (세대 수) — INT
- boardUrl (공고문) — VARCHAR(256)
EstateAgent (tb_estate_agent)
- Key — VARCHAR(32) — Primary key — NOT NULL
- agentName (중개사명) — VARCHAR(16)
- agentCEO (중개사대표) — VARCHAR(16)
- agentAddress (중개사주소) — VARCHAR(128)
- agentBizId (중개사등록번호) — VARCHAR(64)
- tel (전화) — VARCHAR(16)
- phone (폰) — VARCHAR(16)
- Field
Photo (tb_photo)
- id (Key) — INT — Primary key — NOT NULL
- propertyId (매물id) — INT UNSIGNED — Foreign key → Property.Key — NOT NULL
- imgUrl (이미지) — VARCHAR(256)
- Field
Platform (tb_platform)
- platformId (Key) — SMALLINT — Primary key — NOT NULL
- name (Field) — VARCHAR(16)
Property (tb_property)
- Key — INT UNSIGNED — Primary key — NOT NULL
- pyeongId (평id) — INT — Foreign key → Pyeong.id — NOT NULL
- feature (매물특징) — VARCHAR(64)
- tags (태그;) — VARCHAR(64)
- tradeType (매물타입) — VARCHAR(4)
- floor (층) — INT
- price (가격(만원)) — INT
- direction (방향) — VARCHAR(4)
- dong (동) — VARCHAR(8)
- lat (위도) — DOUBLE
- lon (경도) — DOUBLE
- createdAt (승인일) — DATE
- imgUrl (대표img) — VARCHAR(256)
- unitPrice (평단가(만원)) — INT
PropertyDetail (tb_property_detail)
- propertyId (매물id) — INT UNSIGNED — Foreign key → Property.Key — NOT NULL
- content (설명) — TEXT
- maintenanceNames (관리비항목;) — VARCHAR(64)
- maintenanceFee (관리비) — INT
- moveInType (입주형태) — VARCHAR(8)
- moveAt (입주가능일) — DATE
- agentId (중개사) — VARCHAR(32) — Foreign key → EstateAgent.Key — NOT NULL
- brokerFee (중개수수료) — INT
- maxBrokerFee (상한요율(%)) — FLOAT
- acquisitionFee (취득세) — INT
Pyeong (tb_pyeong)
- id (Key) — INT — Primary key — NOT NULL
- apartId (아파트id) — INT — Foreign key → Apart.apartId
- pyeongName (이름) — VARCHAR(8)
- size (전용면적) — DECIMAL(5, 2)
- supply (공급면적) — DECIMAL(5, 2)
- imgUrl (방구조img) — VARCHAR(256)
PyeongDetail (tb_pyeong_detail)
- pyeongId (평id) — INT — Foreign key → Pyeong.id — NOT NULL
- roomCount (방 개수) — INT
- bathroomCount (화장실 개수) — INT
- layerType (단,복층) — VARCHAR(4)
Region (tb_region)
- Key — INT — Primary key — NOT NULL
- address (주소(동)) — VARCHAR(32)
Room (tb_room)
- id (Key) — INT — Primary key — NOT NULL
- bunyangId (분양) — Foreign key → Bunyang.id — NOT NULL
- size (전용면적) — DECIMAL(7, 4)
- price (가격(만원)) — INT
- general (일반공급) — SMALLINT
- special (특별공급) — SMALLINT
RoomSpecial (tb_room_special)
- Key — Primary key — NOT NULL
- roomId (룸id) — Foreign key → Room.id — NOT NULL
- childrens (다자녀) — INT
- honeymoon (신혼) — INT
- old (노부모) — INT
- lifefirst (생애최초) — INT
- youth (청년) — INT
Sise (tb_sise)
- Key — Primary key — NOT NULL
- Field (KB시세)