Skip to content

staff#

Staff Database Model

Staff #

Bases: Base, IDMixin, DeletedAtMixin, CreatedUpdatedMixin

Staff Database Model

Source code in zoo/models/staff.py 
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
class Staff(Base, IDMixin, DeletedAtMixin, CreatedUpdatedMixin):
    """
    Staff Database Model
    """

    __tablename__ = "staff"

    id: Mapped[int] = mapped_column(primary_key=True)  # noqa: A003
    name: Mapped[str]
    job_title: Mapped[str] = mapped_column(default=None, nullable=True)
    email: Mapped[str] = mapped_column(default=None, nullable=True)
    phone: Mapped[str] = mapped_column(default=None, nullable=True)
    notes: Mapped[str] = mapped_column(default=None, nullable=True)
    exhibit_id: Mapped[int] = mapped_column(
        ForeignKey("exhibits.id"), nullable=True, default=None
    )

    exhibit: Mapped["Exhibits"] = relationship(back_populates="staff")