Source code for app.model.orm.community_strain

import sqlalchemy as sql
from sqlalchemy.orm import (
    mapped_column,
    relationship,
    Mapped,
)

from app.model.orm.orm_base import OrmBase


[docs] class CommunityStrain(OrmBase): "Join table between Communities and StudyStrains"
[docs] __tablename__ = "CommunityStrains"
[docs] id: Mapped[int] = mapped_column(primary_key=True)
[docs] communityId: Mapped[int] = mapped_column(sql.ForeignKey('Communities.id'))
[docs] strainId: Mapped[int] = mapped_column(sql.ForeignKey('StudyStrains.id'))
[docs] community: Mapped['Community'] = relationship(back_populates='communityStrains')
[docs] strain: Mapped['StudyStrain'] = relationship(back_populates='communityStrains')