ㅁ

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