"""Gateway-owned metadata tables (blobs stay on disk).

Platform User/Company IDs are plain string refs — no FKs into Prisma tables.
"""

from __future__ import annotations

from datetime import datetime

from sqlalchemy import Boolean, Column, DateTime, Float, Integer, JSON, String, Text

from app.database import Base


class FaceVerificationAuditRecord(Base):
    __tablename__ = "face_verification_audits"

    audit_id = Column(String(128), primary_key=True)
    interview_id = Column(String(128), nullable=False, index=True)
    candidate_id = Column(String(128), nullable=True, index=True)
    status = Column(String(32), nullable=False)
    verified = Column(Boolean, nullable=False, default=False)
    identity_matched = Column(Boolean, nullable=False, default=False)
    liveness_passed = Column(Boolean, nullable=False, default=False)
    match_score = Column(Float, nullable=True)
    distance = Column(Float, nullable=True)
    threshold = Column(Float, nullable=True)
    liveness_score = Column(Float, nullable=True)
    model = Column(String(128), nullable=True)
    detector = Column(String(128), nullable=True)
    attempt = Column(Integer, nullable=False, default=1)
    face_count = Column(Integer, nullable=True)
    frame_count = Column(Integer, nullable=False, default=0)
    registered_image_sha256 = Column(String(128), nullable=True)
    live_image_sha256s = Column(JSON, nullable=False, default=list)
    error_code = Column(String(128), nullable=True)
    warnings = Column(JSON, nullable=False, default=list)
    created_at = Column(String(64), nullable=False)
    expires_at = Column(String(64), nullable=True)


class IdVerificationRecordRow(Base):
    __tablename__ = "id_verifications"

    verification_id = Column(String(128), primary_key=True)
    interview_id = Column(String(128), nullable=True, index=True)
    candidate_id = Column(String(128), nullable=True, index=True)
    verification_status = Column(String(64), nullable=False)
    verified = Column(Boolean, nullable=False, default=False)
    consent_given = Column(Boolean, nullable=False, default=False)
    consent_id = Column(String(128), nullable=True)
    consent_version = Column(String(64), nullable=True)
    consent_timestamp = Column(String(64), nullable=True)
    extracted_name = Column(String(512), nullable=True)
    extracted_id_number_masked = Column(String(128), nullable=True)
    document_type = Column(String(128), nullable=True)
    match_score = Column(Float, nullable=True)
    identity_matched = Column(Boolean, nullable=True)
    liveness_passed = Column(Boolean, nullable=True)
    expiry_valid = Column(Boolean, nullable=True)
    authenticity_passed = Column(Boolean, nullable=True)
    name_matched = Column(Boolean, nullable=True)
    encrypted_storage_id = Column(String(256), nullable=True)
    id_image_sha256 = Column(String(128), nullable=True)
    attempt = Column(Integer, nullable=False, default=1)
    error_code = Column(String(128), nullable=True)
    warnings = Column(JSON, nullable=False, default=list)
    checks = Column(JSON, nullable=False, default=list)
    created_at = Column(String(64), nullable=False)
    verified_at = Column(String(64), nullable=True)
    expires_at = Column(String(64), nullable=True)


class EvaluationReportRecord(Base):
    __tablename__ = "evaluation_reports"

    report_id = Column(String(64), primary_key=True)
    interview_id = Column(String(128), nullable=True, index=True)
    storage_path = Column(Text, nullable=False)
    summary_markdown = Column(Text, nullable=True)
    candidate_name = Column(String(512), nullable=True)
    role_title = Column(String(512), nullable=True)
    company_name = Column(String(512), nullable=True)
    created_at = Column(DateTime(timezone=True), nullable=False, default=datetime.utcnow)
    meta = Column(JSON, nullable=False, default=dict)


class VoiceProfileRecord(Base):
    __tablename__ = "voice_profiles"

    voice_id = Column(String(128), primary_key=True)
    company_id = Column(String(128), nullable=False, index=True)
    voice_name = Column(String(512), nullable=False)
    tts_model = Column(String(128), nullable=False)
    mode = Column(String(32), nullable=False)
    openai_voice_id = Column(String(256), nullable=True)
    builtin_voice = Column(String(64), nullable=True)
    consent_id = Column(String(128), nullable=True)
    sample_sha256 = Column(String(128), nullable=True)
    created_at = Column(String(64), nullable=False)
    meta = Column(JSON, nullable=False, default=dict)
