feat: add TenantMixin for tenant_id column

fiqrikm18 · fiqrikm18 · commit 14564fbb093e · 2026-06-26T11:52:10.000+07:00
diff --git a/src/shared/database/mixin/tenant.py b/src/shared/database/mixin/tenant.py
@@ -0,0 +1,14 @@
+from uuid import UUID
+
+from sqlalchemy import ForeignKey
+from sqlalchemy.dialects.postgresql import UUID as PG_UUID
+from sqlalchemy.orm import Mapped, mapped_column
+
+
+class TenantMixin:
+    tenant_id: Mapped[UUID] = mapped_column(
+        PG_UUID(as_uuid=True),
+        ForeignKey("tenants.id"),
+        nullable=False,
+        sort_order=-60,
+    )
diff --git a/src/shared/database/model.py b/src/shared/database/model.py
@@ -3,6 +3,8 @@
 from sqlalchemy.dialects.postgresql import UUID as PG_UUID
 from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
 
+from src.shared.database.mixin.tenant import TenantMixin  # noqa: F401
+
 
 class Base(DeclarativeBase):
     id: Mapped[UUID] = mapped_column(
