Untitled

from typing import Optional

from sqlalchemy import TIMESTAMP, VARCHAR, BigInteger, ForeignKey, Integer, Text
from sqlalchemy.orm import Mapped, mapped_column

from .base import Base


class ReltioSearch(Base):
    __tablename__ = "mdm_reltio"
    # therapeutic_area: Mapped[Optional[int]] = None
    # group_status: Mapped[Optional[str]] = None
    # pgjn_flag: Mapped[Optional[str]] = None
    # uri: Mapped[Optional[str]] = None
    # display_name_product: Mapped[Optional[str]] = None
    # group_type: Mapped[Optional[str]] = None
    id: Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True)  # Add a primary key column
    therapeutic_area: Mapped[Optional[int]] = None
    group_status: Mapped[Optional[str]] = None
    pgjn_flag: Mapped[Optional[str]] = None
    uri: Mapped[Optional[str]] = None
    display_name_product: Mapped[Optional[str]] = None
    group_type: Mapped[Optional[str]] = None

    class Config:
        orm_mode = True
        exclude_none = True  # Exclude fields with None values from the output