Data Schema Index
This section provides comprehensive documentation for all 300+ attributes in the Pillow properties table. Attributes are organized by functional category for easy navigation.
Schema Overview
Section titled “Schema Overview”The properties table is a comprehensive, flat schema designed for analytics and OLAP queries. All attributes use metric units (square meters, kilometers, meters) and are stored in a single table for optimal query performance.
Key Characteristics:
- 300+ attributes covering the complete property domain
- Metric-first units for consistency
- Flat structure optimized for analytics
- MySQL-compatible (Doris database)
Attribute Categories
Section titled “Attribute Categories”Core identifiers and source tracking for properties.
id,property_uuid,source_id,mls_number,property_id_altaddress_hash(for deduplication)data_source,data_quality_score,data_confidence_level
Fundamental property characteristics and metadata.
property_name,property_type,property_subtype,property_style,property_usetitle,descriptionstatus,listing_status
Pricing, taxes, insurance, and investment metrics.
price,currency,price_current,price_per_sqm,price_originaltaxes_annual,tax_assessment,insurance_annualmarket_value_estimated,rental_estimate_monthly,rental_yield_annual_pctappreciation_1yr_pct,appreciation_5yr_pct,appreciation_10yr_pct
Complete address components and location identifiers.
address_street,address_unit,address_city,address_stateaddress_county,address_country,address_postal_codeaddress_full
Geographic coordinates and location metadata.
latitude,longitude,s2_cell_idneighborhood,subdivision,school_districttime_zone,elevation_meters,flood_zone
Views, proximity metrics, and location scores.
view_type,view_quality,has_water_view,has_mountain_viewdistance_to_airport,distance_to_downtown,distance_to_shoppingwalkability_score,transit_score,bike_score,crime_score,school_rating
Property and lot size measurements in square meters.
square_meters_total,square_meters_living,square_meters_heatedlot_size_sqm,lot_size_hectares,lot_dimensionsfrontage_meters,depth_meters,lot_shape
Room counts, types, and layout information.
bedrooms_total,bathrooms_total,stories,levels_totalliving_rooms,dining_rooms,kitchens,officesbasement_type,attic_type
Building materials, age, and structural details.
year_built,year_renovated,age_yearsconstruction_type,foundation_type,exterior_materialroof_material,roof_style,siding_materialcondition_rating,quality_rating,overall_condition
Interior finishes, kitchen, and bathroom details.
flooring_main,flooring_kitchen,has_hardwood_floorskitchen_style,has_kitchen_island,appliances_includedmaster_bath_features,has_soaking_tub,has_walk_in_shower
HVAC, electrical, plumbing, and internet infrastructure.
hvac_type,heating_system,cooling_system,has_central_airelectrical_amps,has_220v_service,has_solar_panelsplumbing_type,water_supply,water_heater_typeinternet_available,has_fiber_internet,internet_speed_mbps
Home automation and smart device features.
smart_home_level,has_smart_thermostats,has_smart_lightinghas_smart_locks,has_smart_security_system,has_voice_controlsmart_features_list
Security systems and safety features.
security_system_type,has_alarm_system,has_security_camerashas_smoke_alarms,has_carbon_monoxide_detectorshas_fire_sprinklers,has_security_lighting
Parking, pools, outdoor features, and landscaping.
parking_total_spaces,garage_spaces,garage_typehas_pool,pool_type,has_spa,has_hot_tubhas_deck,has_patio,has_outdoor_kitchenlandscaping_level,has_irrigation_system,fence_material
Waterfront properties and view characteristics.
is_waterfront,waterfront_type,waterfront_metershas_dock,has_boat_slip,water_access_type
High-end amenities and premium features.
luxury_level,has_wine_cellar,has_home_gymhas_sauna,has_elevator,has_central_vacuumhas_built_in_bar,has_library
Community amenities and homeowners association details.
community_name,is_gated_community,community_amenitieshas_hoa,hoa_fee_monthly,hoa_fee_annual,hoa_includes
Energy efficiency, green features, and environmental factors.
energy_star_certified,energy_efficiency_ratinghas_solar_panels,has_geothermal_systemhas_electric_car_charging,green_certificationflood_insurance_required,wildfire_risk,earthquake_zone
ADA compliance and accessibility features.
ada_compliant,has_wheelchair_access,has_rampshas_wide_doorways,has_accessible_bathroom,has_grab_bars
Listing information, agent details, and media assets.
listing_price,listing_remarks,days_on_marketsold_date,sold_pricelisting_agent_name,listing_agent_phone,listing_office_namehas_virtual_tour,virtual_tour_url,photo_count,video_count
Audit and tracking timestamps.
created_at,updated_at,indexed_atlisting_date,last_verified
Quick Reference
Section titled “Quick Reference”Most Common Attributes
Section titled “Most Common Attributes”| Attribute | Type | Description |
|---|---|---|
id | VARCHAR(50) | Unique property identifier |
property_type | VARCHAR(50) | Type of property (house, apartment, etc.) |
price_current | BIGINT | Current listing price |
address_full | VARCHAR(500) | Complete formatted address |
latitude | DOUBLE | Geographic latitude |
longitude | DOUBLE | Geographic longitude |
bedrooms_total | INT | Total number of bedrooms |
bathrooms_total | DOUBLE | Total number of bathrooms |
square_meters_total | DOUBLE | Total area in square meters |
year_built | INT | Year the property was built |
Data Types
Section titled “Data Types”- VARCHAR(n): Variable-length string (max n characters)
- INT: 32-bit integer
- BIGINT: 64-bit integer
- DOUBLE: Double-precision floating point
- BOOLEAN: True/false value
- TEXT: Variable-length text (unlimited)
- DATETIME: Date and time value
All measurements use metric units:
- Area: Square meters (sqm)
- Distance: Meters or kilometers
- Price: Local currency (stored as integer in smallest unit, e.g., cents)
- Coordinates: Decimal degrees (WGS84)
Schema Source
Section titled “Schema Source”The schema is defined in:
- DDL Script:
mill/internal/database/sql/properties_schema.sql - Go Model:
mill/internal/models/property_comprehensive.go - OpenAPI Schema: Generated from Go model
Related Documentation
Section titled “Related Documentation”- API Documentation - How to query and submit properties
- Architecture - System design and data flow
- The Mill API - API service documentation