姚章浩
25 lines
699 B
SQL
25 lines
699 B
SQL
-- 000006_native_card_feedback_reasons up migration
|
|
-- Preserve the original B2 reasons and add the six exact reason codes emitted
|
|
-- by DingTalk's built-in AI feedback component.
|
|
|
|
ALTER TABLE answer_feedback
|
|
DROP CONSTRAINT IF EXISTS answer_feedback_reason_code_check;
|
|
|
|
ALTER TABLE answer_feedback
|
|
ADD CONSTRAINT answer_feedback_reason_code_check
|
|
CHECK (reason_code IN (
|
|
'',
|
|
'incorrect',
|
|
'not_resolved',
|
|
'irrelevant',
|
|
'unclear',
|
|
'outdated',
|
|
'other',
|
|
'content_mismatch',
|
|
'content_incomplete',
|
|
'illogical_expression',
|
|
'factual_error',
|
|
'sensitive_content',
|
|
'answer_not_wanted'
|
|
));
|