File size: 1,585 Bytes
1ca9ba2 5655f74 1ca9ba2 5655f74 1ca9ba2 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | import uuid
from datetime import datetime
from sqlalchemy import String, DateTime, JSON, Float, ForeignKey, func, Integer
from sqlalchemy.orm import Mapped, mapped_column
from sqlalchemy.dialects.postgresql import UUID
from ..database import Base
class MatchResult(Base):
__tablename__ = "match_results"
id: Mapped[uuid.UUID] = mapped_column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4)
jd_id: Mapped[uuid.UUID] = mapped_column(UUID(as_uuid=True), ForeignKey("job_descriptions.id", ondelete="CASCADE"), index=True)
candidate_id: Mapped[uuid.UUID] = mapped_column(UUID(as_uuid=True), ForeignKey("candidates.id", ondelete="CASCADE"), index=True)
session_id: Mapped[uuid.UUID | None] = mapped_column(UUID(as_uuid=True), ForeignKey("sessions.id", ondelete="CASCADE"), nullable=True, index=True)
rank: Mapped[int | None] = mapped_column(nullable=True)
stage1_score: Mapped[float] = mapped_column(Float, default=0.0)
stage2_score: Mapped[float | None] = mapped_column(Float, nullable=True)
final_score: Mapped[float] = mapped_column(Float, default=0.0)
component_scores: Mapped[dict] = mapped_column(JSON, default=dict)
gaps: Mapped[list] = mapped_column(JSON, default=list)
explanation: Mapped[str | None] = mapped_column(String, nullable=True)
explanation_generated_at: Mapped[datetime | None] = mapped_column(DateTime(timezone=True), nullable=True)
weights_used: Mapped[dict] = mapped_column(JSON, default=dict)
created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), server_default=func.now())
|