22 lines
741 B
Python
22 lines
741 B
Python
from sqlalchemy.orm import Mapped
|
|
from sqlalchemy.orm import mapped_column
|
|
from sqlalchemy.orm import relationship
|
|
from .base import Base
|
|
|
|
from typing import TYPE_CHECKING
|
|
|
|
if TYPE_CHECKING:
|
|
from isp_connection import IspConnection
|
|
|
|
|
|
class Isp(Base):
|
|
name: Mapped[str]
|
|
manager_name: Mapped[str] = mapped_column(nullable=True)
|
|
manager_phone: Mapped[str] = mapped_column(nullable=True)
|
|
manager_email: Mapped[str] = mapped_column(nullable=True)
|
|
tech_support_phone: Mapped[str] = mapped_column(nullable=True)
|
|
tesh_support_email: Mapped[str] = mapped_column(nullable=True)
|
|
comment: Mapped[str] = mapped_column(nullable=True)
|
|
|
|
isp_connections: Mapped[list["IspConnection"]] = relationship(back_populates="isp")
|