"""Gateway-owned AI job drafts (Platform Job/Company IDs are string refs)."""

from __future__ import annotations

from datetime import datetime
from uuid import uuid4

from sqlalchemy import Column, DateTime, JSON, String, Text

from app.database import Base


class AiJobRecord(Base):
    """Persisted Create Job drafts / published AI payloads.

    Does not duplicate Platform ``User`` / ``Company`` / marketplace Job catalogs.
    ``company_id`` / ``created_by`` / ``platform_job_id`` are external string refs.
    """

    __tablename__ = "ai_jobs"

    job_id = Column(String(64), primary_key=True, default=lambda: f"job-{uuid4().hex[:12]}")
    company_id = Column(String(128), nullable=True, index=True)
    created_by = Column(String(128), nullable=True, index=True)
    platform_job_id = Column(String(128), nullable=True, index=True)
    status = Column(String(32), nullable=False, default="draft", index=True)
    role_title = Column(String(512), nullable=False)
    title = Column(String(512), nullable=True)
    employment_type = Column(String(64), nullable=True)
    location = Column(String(256), nullable=True)
    years_of_experience = Column(String(128), nullable=True)
    seniority = Column(String(128), nullable=True)
    department = Column(String(256), nullable=True)
    markdown = Column(Text, nullable=True)
    sections = Column(JSON, nullable=False, default=dict)
    validation = Column(JSON, nullable=True)
    meta = Column(JSON, nullable=False, default=dict)
    created_at = Column(DateTime(timezone=True), nullable=False, default=datetime.utcnow)
    updated_at = Column(DateTime(timezone=True), nullable=False, default=datetime.utcnow)
