1 files changed, 20 insertions, 0 deletions
diff --git a/packages/meshbay-hub/src/meshbay_hub/db/models.py b/packages/meshbay-hub/src/meshbay_hub/db/models.py
index d06bcda..c420661 100644
--- a/packages/meshbay-hub/src/meshbay_hub/db/models.py
+++ b/packages/meshbay-hub/src/meshbay_hub/db/models.py
@@ -195,6 +195,26 @@ class SwarmSource(Base):
     __table_args__ = (Index("ix_swarm_hash", "content_hash"),)
 
 
+class Notification(Base):
+    __tablename__ = "notifications"
+
+    id:        Mapped[int] = mapped_column(Integer, primary_key=True, autoincrement=True)
+    user_id:   Mapped[str] = mapped_column(ForeignKey("users.id"), nullable=False)
+    kind:      Mapped[str] = mapped_column(String(32), nullable=False)
+    title:     Mapped[str] = mapped_column(String(256), nullable=False)
+    detail:    Mapped[str | None] = mapped_column(String(512))
+    link:      Mapped[str | None] = mapped_column(String(256))
+    read:      Mapped[bool] = mapped_column(Boolean, default=False)
+    created_at: Mapped[datetime] = mapped_column(DateTime(timezone=True), default=_now)
+
+    user: Mapped["User"] = relationship()
+
+    __table_args__ = (
+        Index("ix_notifications_user", "user_id"),
+        Index("ix_notifications_created", "created_at"),
+    )
+
+
 class ContentReport(Base):
     """
     Report of a public content hash for moderation.