from sqlalchemy import Boolean, String
from sqlalchemy.orm import Mapped, mapped_column, relationship

from app.db.base import Base, TimestampMixin


class InsuranceCompany(Base, TimestampMixin):
    __tablename__ = "insurance_companies"

    id: Mapped[int] = mapped_column(primary_key=True, autoincrement=True)
    name: Mapped[str] = mapped_column(String(255), nullable=False, unique=True)
    code: Mapped[str] = mapped_column(String(50), nullable=False, unique=True)
    is_active: Mapped[bool] = mapped_column(Boolean, default=True, nullable=False)
    parser_key: Mapped[str | None] = mapped_column(String(50))

    policies: Mapped[list["Policy"]] = relationship(back_populates="insurance_company")
    scan_keywords: Mapped[list["PolicyScanKeyword"]] = relationship(
        back_populates="insurance_company",
        cascade="all, delete-orphan",
    )


from app.models.policy import Policy  # noqa: E402
from app.models.policy_scan_keyword import PolicyScanKeyword  # noqa: E402