Properties Table (All Columns)

Overview

This page documents every column in the properties table, grouped by the same categories used in the code model. The schema is provisioned from a single SQL file and is compatible with MySQL and Doris (Doris directives are appended at runtime).

• Source model: mill/internal/models/property_comprehensive.go and mill/internal/models/property_features.go
• Provisioning DDL: mill/internal/database/sql/properties_schema.sql

Categories and Columns

Basic Identification

• id: Unique property ID (string)
• property_uuid: Secondary UUID identifier (string)
• mls_number: MLS number when sourced from MLS (string)
• property_id_alt: Alternate integration identifier (string)

Basic Property Information

• property_name, property_type, property_subtype, property_style, property_use
• title, description

Financial (PropertyFinancial)

• Context: PropertyFinancial contains detailed financial information for a property including pricing, costs, and investment metrics.
• price, currency
• price_current, price_per_sqm, price_original, price_history
• taxes_annual, tax_year, tax_assessment, homestead_exemption
• insurance_annual, insurance_flood_required
• Market analytics: market_value_estimated, value_per_sqm_estimated, appreciation_1yr_pct, appreciation_5yr_pct, appreciation_10yr_pct
• Rentals: rental_estimate_monthly, rental_yield_annual_pct

Address (ComprehensiveAddress)

• address_street, address_unit, address_city, address_state, address_county
• address_country, address_postal_code, address_full

Location (ComprehensiveLocation)

• latitude, longitude
• neighborhood, subdivision, school_district, time_zone, elevation_meters, flood_zone
• Views: view_type, view_quality, view_direction, has_water_view, has_mountain_view, has_city_view, has_golf_course_view
• Distances/scores: distance_to_airport, distance_to_downtown, distance_to_shopping, distance_to_hospital, distance_to_beach, distance_to_highway, walkability_score, transit_score, bike_score, crime_score, school_rating

Dimensions (PropertyDimensions)

• Areas (sqm): square_meters_total, square_meters_living, square_meters_heated, square_meters_cooled
• Finished/unfinished: square_meters_finished_above_grade, square_meters_finished_below_grade, square_meters_unfinished_above_grade, square_meters_unfinished_below_grade
• Spaces: square_meters_garage, square_meters_storage, square_meters_basement, square_meters_attic
• Lot: lot_size_sqm, lot_size_hectares, lot_dimensions, lot_shape, frontage_meters, depth_meters

Rooms & Layout (PropertyRooms)

• Bedrooms: bedrooms_total, bedrooms_above_grade, bedrooms_below_grade
• Bathrooms: bathrooms_total, bathrooms_full, bathrooms_three_quarter, bathrooms_half, bathrooms_one_quarter
• Specific rooms: living_rooms, dining_rooms, family_rooms, great_rooms, kitchens, pantries, laundry_rooms, mudrooms, offices, studies, libraries, bonus_rooms, recreation_rooms, media_rooms, home_theaters, exercise_rooms, game_rooms, workshops, craft_rooms, wine_cellars, storage_rooms, closets_walk_in
• Levels: stories, levels_total, levels_above_grade, levels_below_grade, basement_type, attic_type

Construction & Materials (PropertyConstruction)

• Years: year_built, year_renovated, effective_year_built, age_years
• Condition/quality: condition_rating, quality_rating, overall_condition, maintenance_level, renovation_level
• Structure: construction_type, foundation_type, exterior_material, roof_material, roof_style, roof_age_years, siding_material, window_material, window_type, door_material
• Architecture: architectural_style, ceiling_height_main, ceiling_height_max, ceiling_types, floor_plan_type, entry_type

Interior (PropertyInterior)

• Flooring: flooring_main, flooring_kitchen, flooring_bathrooms, flooring_bedrooms, flooring_living_areas, flooring_basement
• Booleans: has_hardwood_floors, has_tile_floors, has_carpet, has_laminate, has_vinyl, has_concrete_floors
• Kitchen (KitchenFeatures): kitchen_style, kitchen_size, has_kitchen_island, has_breakfast_bar, has_breakfast_nook, has_pantry, has_butler_pantry
• Appliances/finishes: appliances_included, has_dishwasher, has_garbage_disposal, has_microwave, has_range, has_oven, has_cooktop, has_refrigerator, has_wine_fridge, has_ice_maker, countertop_material, backsplash_material, cabinet_material, cabinet_style, sink_type, faucet_type
• Bathrooms (BathroomFeatures): master_bath_features, has_master_bath, has_en_suite_baths, has_jack_and_jill_bath, has_powder_room, has_soaking_tub, has_jetted_tub, has_separate_shower, has_walk_in_shower, has_steam_shower, has_dual_vanities, has_heated_bathroom_floors, has_bidet
• Storage (StorageFeatures): has_walk_in_closets, walk_in_closets_count, has_storage_room, has_basement_storage, has_attic_storage, has_garage_storage, has_shed, shed_size

Systems (HVAC, Electrical, Plumbing) (PropertySystems)

• HVAC: hvac_type, heating_system, heating_fuel, cooling_system, air_conditioning_type, has_central_air, has_heat_pump, has_radiant_heating, has_forced_air, has_boiler, has_furnace, has_fireplace, fireplaces_total, fireplace_types, hvac_age_years, hvac_zones, has_programmable_thermostat, has_smart_thermostat
• Electrical: electrical_panel_type, electrical_amps, electrical_voltage, has_220v_service, has_whole_house_generator, has_backup_generator, has_solar_panels, solar_owned_leased, solar_kw_capacity
• Plumbing: plumbing_type, water_supply, sewer_system, water_heater_type, water_heater_fuel, water_heater_age_years, has_tankless_water_heater, has_water_softener, has_water_filtration, has_sump_pump
• Internet: internet_available, internet_speed_mbps, has_fiber_internet, has_cable_internet, has_satellite_internet, has_5g_coverage, has_structured_wiring, has_security_pre_wire, has_sound_pre_wire

Smart Home (SmartHomeFeatures)

• smart_home_level, has_smart_thermostats, has_smart_lighting, has_smart_locks, has_smart_doorbell, has_smart_security_system, has_smart_cameras, has_smart_smoke_detectors, has_smart_irrigation, has_smart_garage_doors, has_smart_appliances, has_voice_control, has_home_automation_hub, has_smart_blinds, has_smart_mirrors, smart_features_list

Security & Safety (SecurityFeatures)

• security_system_type, has_alarm_system, has_security_cameras, has_motion_sensors, has_door_sensors, has_window_sensors, has_smoke_alarms, has_carbon_monoxide_detectors, has_fire_sprinklers, has_security_lighting, has_panic_room

Outdoor Features & Parking (OutdoorFeatures)

• Parking/garage: parking_total_spaces, garage_spaces, garage_type, garage_door_type, has_automatic_garage_doors, has_heated_garage, has_workshop_space, driveway_spaces, driveway_material, has_circular_driveway, has_gated_entry
• Outdoor living: has_outdoor_kitchen, has_outdoor_fireplace, has_fire_pit, has_deck, has_patio, has_balcony, has_porch, has_gazebo, has_pergola, has_outdoor_shower
• Landscaping: landscaping_level, has_irrigation_system, has_sprinkler_system, has_outdoor_lighting, has_garden, has_vegetable_garden, has_fruit_trees, has_mature_trees, has_privacy_fencing, fence_material
• Waterfront: is_waterfront, waterfront_type, waterfront_meters, has_dock, has_boat_slip, has_boat_lift, water_access_type

Luxury & Entertainment (LuxuryFeatures)

• luxury_level, has_wine_cellar, has_wine_room, has_home_gym, has_sauna, has_steam_room, has_home_office, has_library, has_art_studio, has_music_room, has_craft_room, has_safe_room, has_elevator, has_intercom_system, has_central_vacuum, has_built_in_bar, has_home_theater, has_media_room, has_game_room, has_billiards_room, has_recreation_room, has_sports_court, sports_court_type, has_putting_green

Community & HOA (CommunityFeatures)

• community_name, is_gated_community, community_amenities, has_community_pool, has_community_clubhouse, has_community_gym, has_community_tennis, has_community_golf, has_community_marina
• HOA: has_hoa, hoa_fee_monthly, hoa_fee_annual, hoa_includes, hoa_name

Environmental & Accessibility (EnvironmentalData)

• Energy efficiency: energy_star_certified, energy_efficiency_rating, has_energy_efficient_windows, has_energy_efficient_appliances, has_led_lighting, has_insulation_upgrade, insulation_type, has_storm_windows
• Green: green_certification, has_solar_water_heater, has_geothermal_system, has_wind_power, has_rainwater_collection, has_greywater_system, has_electric_car_charging, charging_station_type
• Hazards: environmental_hazards, flood_insurance_required, in_floodplain, earthquake_zone, hurricane_zone, wildfire_risk
• Accessibility: ada_compliant, has_wheelchair_access, has_ramps, has_wide_doorways, has_accessible_bathroom, has_grab_bars, has_stairlift

Listing & Agent (ComprehensiveListing)

• listing_status, listing_date, listing_price, listing_remarks, days_on_market, cumulative_days_on_market, sold_date, sold_price
• Agents/offices: listing_agent_name, listing_agent_phone, listing_agent_email, listing_office_name, co_listing_agent, buying_agent_name, buying_agent_phone, buying_office_name

Media (PropertyMedia)

• has_virtual_tour, virtual_tour_url, photo_count, video_count, drone_photos
• Showings: showing_instructions, lockbox_type, access_code, showing_requirements

Data Quality & Source (DataQualityInfo)

• data_source, data_quality_score, last_verified, data_confidence_level

Legacy & Timestamps

• Legacy/compat: status
• Timestamps: created_at, updated_at, indexed_at

Notes

• Types and names are chosen for MySQL compatibility; Doris-specific distribution and key settings are appended at runtime.
• The model in code is the source of truth; this page is generated to mirror that model structure.