from sqlalchemy import BigInteger, String
from sqlalchemy.orm import Mapped, mapped_column

from alien_database.base import Base, AuditMixin


class ContractBundle(Base, AuditMixin):
    __tablename__ = "contract_bundle"

    id: Mapped[int] = mapped_column(BigInteger, primary_key=True, autoincrement=True)
    subject_type: Mapped[str] = mapped_column(String(20))
    subject_id: Mapped[int] = mapped_column(BigInteger)
    subject_name: Mapped[str] = mapped_column(String(120))
    business_segment: Mapped[str] = mapped_column(String(100))
    contact_name: Mapped[str] = mapped_column(String(100))
    contact_phone: Mapped[str] = mapped_column(String(20))
    ord_id: Mapped[str] = mapped_column(String(40))
    bundle_type: Mapped[str] = mapped_column(String(50))
    status: Mapped[str] = mapped_column(String(20), default="pending")
    primary_document_id: Mapped[int | None] = mapped_column(BigInteger, nullable=True)