Class AppDB

api/oss/src/models/db_models.py:150–181

# KEEP in oss/
class AppDB(Base):
    __tablename__ = "app_db"

    id = Column(
        UUID(as_uuid=True),
        primary_key=True,
        default=uuid.uuid7,
        unique=True,
        nullable=False,
    )
    app_name = Column(String)
    app_type = Column(Enum(AppType, name="app_type_enum"), nullable=True)  # type: ignore
    project_id = Column(
        UUID(as_uuid=True), ForeignKey("projects.id", ondelete="CASCADE")
    )
    modified_by_id = Column(UUID(as_uuid=True), ForeignKey("users.id"), nullable=True)
    created_at = Column(
        DateTime(timezone=True), default=lambda: datetime.now(timezone.utc)
    )
    updated_at = Column(
        DateTime(timezone=True), default=lambda: datetime.now(timezone.utc)
    )

    modified_by = relationship("UserDB", foreign_keys=[modified_by_id])
    variant = relationship(
        "AppVariantDB", cascade=CASCADE_ALL_DELETE, back_populates="app"
    )
    deployment = relationship(
        "oss.src.models.db_models.DeploymentDB",
        cascade=CASCADE_ALL_DELETE,
        back_populates="app",
    )


# KEEP in oss/