cb7080c460
14 new optional residence fields (heating, cooling, water heater, roof, pool, sprinkler, septic, fireplace, garage, basement, attic, exterior, flooring, landscaping) with JSONB conditions on templates. Suggestion engine scores templates against home profile: string match +0.25, bool +0.3, property type +0.15, universal base 0.3. Graceful degradation from minimal to full profile info. GET /api/tasks/suggestions/?residence_id=X returns ranked templates. 54 template conditions across 44 templates in seed data. 8 suggestion service tests.
19 lines
671 B
SQL
19 lines
671 B
SQL
-- Migration: 019_residence_home_profile (rollback)
|
|
-- Remove home profile fields from residence
|
|
|
|
ALTER TABLE residence_residence
|
|
DROP COLUMN IF EXISTS heating_type,
|
|
DROP COLUMN IF EXISTS cooling_type,
|
|
DROP COLUMN IF EXISTS water_heater_type,
|
|
DROP COLUMN IF EXISTS roof_type,
|
|
DROP COLUMN IF EXISTS has_pool,
|
|
DROP COLUMN IF EXISTS has_sprinkler_system,
|
|
DROP COLUMN IF EXISTS has_septic,
|
|
DROP COLUMN IF EXISTS has_fireplace,
|
|
DROP COLUMN IF EXISTS has_garage,
|
|
DROP COLUMN IF EXISTS has_basement,
|
|
DROP COLUMN IF EXISTS has_attic,
|
|
DROP COLUMN IF EXISTS exterior_type,
|
|
DROP COLUMN IF EXISTS flooring_primary,
|
|
DROP COLUMN IF EXISTS landscaping_type;
|