Property

Tables (5)

AnalysisModel (Untitled3)

  • analysis_model_id (Key) — Integer — Primary key — NOT NULL
  • title (Field) — Char(48)
  • version (Field2) — Float
  • model (Field3) — PrivateFileField

PropertyBasic (Untitled)

  • bpid (Key) — Integer — Primary key — NOT NULL
  • full_address (Field) — Char(256) — NOT NULL
  • street_address (Field2) — Char(128) — NOT NULL
  • route (Field3) — Char(64) — NOT NULL
  • unit (Field4) — Char(16)
  • city (Field5) — Char(32) — NOT NULL
  • state (Field6) — Char(16) — NOT NULL
  • county (Field7) — Char(64)
  • longitude (Field9) — Float — NOT NULL
  • latitude (Field10) — Float — NOT NULL

PropertyDetails (매물)

  • property_details_id (Key) — Integer — Primary key — NOT NULL
  • property_basic (Key2) — PropertyBasic — Foreign key → PropertyBasic.bpid — NOT NULL
  • source (Field) — Char(40) — NOT NULL
  • source_id (리스트 상태) — Char(64) — NOT NULL
  • description (생활면적) — Text(512)
  • lot_area_sqft (가격) — Float
  • living_area_sqft (리스트된 시간) — Float
  • price (등록된 기간) — BigInteger
  • status (Field2) — Char(16) — NOT NULL
  • image_source (Field3) — URL
  • detail_images (Field4) — Array
  • time_on_sales (Field5) — Char(10)
  • source_url (Field6) — URL(256)
  • property_type (Field7) — Char(24) — NOT NULL
  • monthly_hoa_fee (Field8) — Integer
  • year_built (Field9) — Integer
  • mortgage_rates (Field10) — json
  • price_history (Field11) — Array(json)
  • schools (Field12) — Array(json)
  • mls_id (Field13) — Char(80)
  • estimated_value (Field14) — Integer
  • estimated_value_high_percentage (Field15) — Char(4)
  • estimated_value_low_percentage (Field16) — Char(4)
  • rent_estimate (Field17) — Integer
  • resource_facts (Field18) — json
  • annual_home_owners_insurance (Field19) — Integer
  • parking (Field20) — Char(128)
  • heating (Field21) — Char(128)
  • cooling (Field22) — Char(128)
  • building_permits (Field23) — json
  • num_bathrooms (Field24) — Integer
  • num_bedrooms (Field25) — Integer

PropertyHistories (매물 세부정보)

  • property_histories_id (Key) — Integer — Primary key — NOT NULL
  • property_basic (Key2) — PropertyBasic — Foreign key → PropertyBasic.bpid
  • source (Field) — Char(16) — NOT NULL
  • source_id (Field3) — Char(64) — NOT NULL
  • origin_data (Field2) — json — NOT NULL

PropertyScore (Untitled2)

  • property_score_id (Key) — Integer — Primary key — NOT NULL
  • analysis_model (Key3) — AnalysisModel — Foreign key → AnalysisModel.analysis_model_id — NOT NULL
  • property (Key2) — PropertyDetails — Foreign key → PropertyDetails.property_details_id — NOT NULL
  • score (Field2) — Float