Source code for orm.project_user

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

from app.model.orm.orm_base import OrmBase



[docs]
class ProjectUser(OrmBase):

[docs]
    __tablename__ = 'ProjectUsers'



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



[docs]
    projectUniqueID: Mapped[str] = mapped_column(sql.ForeignKey('Projects.projectUniqueID'), nullable=False)


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



[docs]
    project: Mapped['Project'] = relationship(back_populates="projectUsers")


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