Files
sorsfonalak/crates/db/migrations/0011_synastry_previews.sql
fecoandClaude Opus 5.5 0bd5c39080
CI / test (push) Successful in 45s
CI / build (push) Successful in 4m19s
CI / deploy (push) Skipped
Comparisons (synastry) of the own chart and persons
/osszevetesek compares any two of the user's charts (own and persons); the
person card and the person's chart page have "Összevetés velem". The
comparison page shows a double wheel (first person inside with houses, second
outside, aspects between them), the aspects by character, and tabs: paid
relationship analysis (synastry unit), the cross aspect grid, house overlays,
composite and the full aspect list.

Correcting a person within the hour now deletes the user's own comparisons
with them instead of being refused; still refused after a paid analysis or
when someone else's comparison uses the chart.

The relationship analysis prompt is editable on /admin/promptok too, and can be
tried on one of the admin's comparisons.

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_012vLHzh5qUhFtmJhzkcTbXL
2026-11-17 16:04:44 +00:00

11 lines
581 B
SQL

-- Prompt test runs of the relationship (synastry) analysis: on one of the
-- admin's comparisons instead of a chart.
ALTER TABLE prompt_previews DROP CONSTRAINT prompt_previews_kind_check;
ALTER TABLE prompt_previews ALTER COLUMN chart_id DROP NOT NULL;
ALTER TABLE prompt_previews
ADD COLUMN synastry_id uuid REFERENCES synastries ON DELETE CASCADE,
ADD CONSTRAINT prompt_previews_target CHECK (
(kind IN ('summary', 'natal') AND chart_id IS NOT NULL AND synastry_id IS NULL)
OR (kind = 'synastry' AND synastry_id IS NOT NULL AND chart_id IS NULL)
);