Source code for app.model.orm.study_user

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

from app.model.orm.orm_base import OrmBase



[docs]
class StudyUser(OrmBase):
    """
    Join table between Studies and Users.

    The users recorded in this table have the ability to manage a particular
    study, to update it, or to reuse its components in other uploads.
    """


[docs]
    __tablename__ = 'StudyUsers'



[docs]
    id: Mapped[int] = mapped_column(sql.Integer, primary_key=True)



[docs]
    studyUniqueID: Mapped[str] = mapped_column(sql.ForeignKey('Studies.uuid'), nullable=False)


[docs]
    userUniqueID:  Mapped[str] = mapped_column(sql.ForeignKey('Users.uuid'),   nullable=False)



[docs]
    study: Mapped['Study'] = relationship(back_populates="studyUsers")


[docs]
    user:  Mapped['User']  = relationship(back_populates="studyUsers")