1 files changed, 13 insertions, 0 deletions

diff --git a/db/models.py b/db/models.py
new file mode 100644
index 0000000..b66f5bc
--- /dev/null
+++ b/db/models.py
@@ -0,0 +1,13 @@
+from uuid import uuid4, UUID
+
+from sqlmodel import SQLModel, Field
+
+
+class BaseModel(SQLModel):
+    id: int | None = Field(primary_key=True, default=None)
+
+class ExternalModelMixin:
+    external_id: UUID = Field(index=True, unique=True, default_factory=uuid4)
+
+class User(BaseModel, ExternalModelMixin, table=True):
+    username: str = Field(unique=True, index=True)