15 lines
787 B
SQL
15 lines
787 B
SQL
-- Free short summaries: a few sentences about a natal chart, written by a
|
|||
|
|
-- cheap model when the chart is saved. The detailed analyses stay paid.
|
||
|
|
|
||
|
|
ALTER TABLE analyses DROP CONSTRAINT analyses_kind_check;
|
||
|
|
ALTER TABLE analyses ADD CONSTRAINT analyses_kind_check CHECK (kind IN ('natal', 'synastry', 'summary'));
|
||
|
|
|
||
|
|
ALTER TABLE analyses DROP CONSTRAINT analyses_target;
|
||
|
|
ALTER TABLE analyses ADD CONSTRAINT analyses_target CHECK (
|
||
|
|
(kind IN ('natal', 'summary') 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)
|
||
|
|
);
|
||
|
|
|
||
|
|
COMMENT ON COLUMN analyses.content IS
|
||
|
|
'Structured result. natal/synastry: {title, summary, sections: {key: {title, body}}, strengths: [], challenges: [], advice}; summary: {title, summary}';
|