backend/update_applications_table.sql

-- Update applications table to include semantic match score results
ALTER TABLE applications 
ADD COLUMN IF NOT EXISTS semantic_score FLOAT,
ADD COLUMN IF NOT EXISTS score_breakdown JSONB;

-- Add comments for documentation
COMMENT ON COLUMN applications.semantic_score IS 'Overall semantic match score calculated via embeddings';
COMMENT ON COLUMN applications.score_breakdown IS 'Breakdown of entity-wise similarity scores';