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시세)