ㅁ
Tables (14)
ai_models
- model_id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 모델 등록자
- model_name — VARCHAR(100) — NOT NULL
- model_type — VARCHAR(20) — NOT NULL
- version — INT — NOT NULL — 재감사 시 증가
- artifact_path — VARCHAR(255) — NOT NULL
- is_high_impact — BOOLEAN — 사전진단 후 확정
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
audit_law_mappings
- mapping_id — BIGSERIAL — Primary key — NOT NULL
- audit_id — BIGINT — Foreign key → audits.audit_id — NOT NULL
- article_id — BIGINT — Foreign key → law_articles.article_id — NOT NULL
- compliance — VARCHAR(20) — NOT NULL
- evidence — TEXT — 분석결과+조항 요약
audits
- audit_id — BIGSERIAL — Primary key — NOT NULL
- model_id — BIGINT — Foreign key → ai_models.model_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- dataset_path — VARCHAR(255) — NOT NULL — 원본 미저장, 경로 참조
- sensitive_features — VARCHAR(255) — NOT NULL — 민감변수 목록(콤마 구분)
- current_step — INT — NOT NULL — 1~5 스텝바
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP
- retention_until — DATE — 완료일+5년(시행령 27조②)
diagnosis_answers
- answer_id — BIGSERIAL — Primary key — NOT NULL
- diagnosis_id — BIGINT — Foreign key → pre_diagnoses.diagnosis_id — NOT NULL
- question_code — VARCHAR(30) — NOT NULL — 예: GATE_01, A_03, B_02
- answer — BOOLEAN — NOT NULL — true=예, false=아니오
- score — INT — NOT NULL
fairness_results
- result_id — BIGSERIAL — Primary key — NOT NULL
- audit_id — BIGINT — Foreign key → audits.audit_id — NOT NULL
- metric_code — VARCHAR(30) — NOT NULL — DEMOGRAPHIC_PARITY, EQUALIZED_ODDS 등
- value — NUMERIC(10, 4) — NOT NULL
- threshold — NUMERIC(10, 4) — NOT NULL
- status — VARCHAR(20) — NOT NULL
law_articles
- article_id — BIGSERIAL — Primary key — NOT NULL
- law_name — VARCHAR(100) — NOT NULL — AI기본법/시행령/금융위 가이드라인
- article_no — VARCHAR(30) — NOT NULL — 예: 제31조
- content — TEXT — NOT NULL
- embedding — VECTOR(1536) — NOT NULL — pgvector RAG 검색용
- effective_date — DATE — NOT NULL
- revision_date — DATE
law_revisions
- revision_id — BIGSERIAL — Primary key — NOT NULL
- source — VARCHAR(50) — NOT NULL — LAW_GO_KR, MSIT, FSC
- title — VARCHAR(200) — NOT NULL
- revision_type — VARCHAR(20) — NOT NULL
- revised_at — DATE — NOT NULL
- collected_at — TIMESTAMP — NOT NULL — 피드 최신순 정렬 기준
notifications
- notification_id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- revision_id — BIGINT — Foreign key → law_revisions.revision_id — 재감사 권고 시 NULL 가능
- audit_id — BIGINT — Foreign key → audits.audit_id — 법령개정 알림 시 NULL
- notif_type — VARCHAR(20) — NOT NULL
- channel — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- sent_at — TIMESTAMP — NOT NULL
objections
- objection_id — BIGSERIAL — Primary key — NOT NULL
- objection_no — VARCHAR(20) — NOT NULL — 예: #2026-0412
- model_id — BIGINT — Foreign key → ai_models.model_id — NOT NULL
- customer_ref — VARCHAR(50) — NOT NULL — 내부 참조번호(PII 아님)
- decision — VARCHAR(20)
- shap_evidence — TEXT — SHAP 근거 변수(JSON)
- staff_note — TEXT
- draft_content — TEXT — LLM 생성 초안
- status — VARCHAR(20) — NOT NULL
- approver_id — BIGINT — Foreign key → users.user_id — 승인자
- approved_at — TIMESTAMP
- delivered_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
pre_diagnoses
- diagnosis_id — BIGSERIAL — Primary key — NOT NULL
- model_id — BIGINT — Foreign key → ai_models.model_id — NOT NULL
- condition_met — BOOLEAN — NOT NULL — 1단계 확정 조건 해당 여부
- group_a_score — INT — NOT NULL
- group_b_score — INT — NOT NULL
- total_score — INT — NOT NULL — 6점 이상 시 고영향 판정
- result — VARCHAR(20) — NOT NULL
- report_path — VARCHAR(255) — 자가검토 결과서 PDF(S3)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
reports
- report_id — BIGSERIAL — Primary key — NOT NULL
- audit_id — BIGINT — Foreign key → audits.audit_id — NOT NULL
- report_type — VARCHAR(20) — NOT NULL
- version — INT — NOT NULL
- format — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
self_check_answers
- check_id — BIGSERIAL — Primary key — NOT NULL
- audit_id — BIGINT — Foreign key → audits.audit_id — NOT NULL
- item_code — VARCHAR(30) — NOT NULL — SUPERVISION, DOC_RETENTION 등
- answer — BOOLEAN — NOT NULL
users
- user_id — BIGSERIAL — Primary key — NOT NULL
- institution — VARCHAR(100) — NOT NULL — 소속 기관
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL — 로그인 ID
- password_hash — VARCHAR(255) — NOT NULL — BCrypt 해시
- law_sms_enabled — BOOLEAN — NOT NULL
- reaudit_alert_enabled — BOOLEAN — NOT NULL
- role — VARCHAR(20) — NOT NULL — 권한(ADMIN/AUDITOR/USER)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
xai_results
- result_id — BIGSERIAL — Primary key — NOT NULL
- audit_id — BIGINT — Foreign key → audits.audit_id — NOT NULL
- metric_code — VARCHAR(30) — NOT NULL
- value — NUMERIC(10, 4) — NOT NULL
- threshold — NUMERIC(10, 4) — NOT NULL
- status — VARCHAR(20) — NOT NULL