Init project

1 files changed, 18 insertions, 0 deletions

diff --git a/models/announcement.py b/models/announcement.py
new file mode 100644
index 0000000..5f752d7
--- /dev/null
+++ b/models/announcement.py
@@ -0,0 +1,18 @@
+from aiogram.types import MessageEntity
+from pydantic import BaseModel
+from sqlalchemy import JSON
+from sqlalchemy.orm import Mapped, mapped_column
+
+from models import BaseTable
+
+
+class Message(BaseModel):
+    text: str
+    entities: list[MessageEntity] = []
+
+
+class Announcement(BaseTable):
+    __tablename__ = "announcement"
+
+    id: Mapped[int] = mapped_column(primary_key=True, autoincrement=True)
+    message: Mapped[str] = mapped_column(JSON())