Answer Submission 推荐表结构
推荐新建 assessment_answer_submissions 专用表。
GateSCHEMA
推荐表assessment_answer_submissions
字段数32
写库no
建表no
下一步Schema Apply
| 字段 |
|---|
| submission_id TEXT PRIMARY KEY |
| assignment_id TEXT NOT NULL |
| employee_id TEXT NOT NULL |
| subject_id TEXT |
| template_id TEXT NOT NULL |
| review_cycle_id TEXT |
| relationship_type TEXT |
| submission_status TEXT NOT NULL |
| answer_payload JSONB NOT NULL |
| answer_count INTEGER |
| dimension_count INTEGER |
| question_count INTEGER |
| score_min NUMERIC |
| score_max NUMERIC |
| dimension_scores_preview JSONB |
| total_score_preview NUMERIC |
| risk_flags_preview JSONB |
| algorithm_input_mapping_preview JSONB |
| pre_go_live_validation BOOLEAN DEFAULT TRUE |
| business_effective BOOLEAN DEFAULT FALSE |
| not_for_people_action BOOLEAN DEFAULT TRUE |
| not_for_feishu_writeback BOOLEAN DEFAULT TRUE |
| data_purpose TEXT DEFAULT 'normalized_business_run_validation' |
| source TEXT DEFAULT 'assessment_normalized_business_run' |
| submitted_by_subject_id TEXT |
| submitted_at TIMESTAMPTZ |
| created_at TIMESTAMPTZ DEFAULT now() |
| updated_at TIMESTAMPTZ |
| audit_id TEXT |
| rollback_ref TEXT |
| raw_payload_hash TEXT |
| schema_version TEXT DEFAULT 'v1' |
约束
- 同一 assignment 仅允许一个 active normalized submission
- business_effective=false
- not_for_people_action=true
- not_for_feishu_writeback=true
- pre_go_live_validation=true
- answer_payload 必须存在
- question_count=15
- score_min/score_max 必须在 1-5
生成时间：2026-05-20 18:12:34；当前 Gate：ASSESSMENT_NORMALIZED_ANSWER_SUBMISSION_SCHEMA_APPLY_APPROVAL_GATE