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