1 files changed, 70 insertions, 0 deletions
diff --git a/api/models.py b/api/models.py
index 7623c86c..68833328 100644
--- a/api/models.py
+++ b/api/models.py
@@ -216,6 +216,76 @@ class User(ModelReprMixin, models.Model):
         return f"{self.name}#{self.discriminator}"
 
 
+class Message(ModelReprMixin, models.Model):
+    id = models.BigIntegerField(
+        primary_key=True,
+        help_text="The message ID as taken from Discord.",
+        validators=(
+            MinValueValidator(
+                limit_value=0,
+                message="Message IDs cannot be negative."
+            ),
+        )
+    )
+    author = models.ForeignKey(
+        User,
+        on_delete=models.CASCADE,
+        help_text="The author of this message."
+    )
+    channel_id = models.BigIntegerField(
+        help_text=(
+            "The channel ID that this message was "
+            "sent in, taken from Discord."
+        ),
+        validators=(
+            MinValueValidator(
+                limit_value=0,
+                message="Channel IDs cannot be negative."
+            ),
+        )
+    )
+    content = models.CharField(
+        max_length=2_000,
+        help_text="The content of this message, taken from Discord."
+    )
+    embeds = pgfields.ArrayField(
+        pgfields.JSONField(
+            validators=(validate_tag_embed,)
+        ),
+        help_text="Embeds attached to this message."
+    )
+
+    class Meta:
+        abstract = True
+
+
+class MessageDeletionContext(ModelReprMixin, models.Model):
+    actor = models.ForeignKey(
+        User,
+        on_delete=models.CASCADE,
+        help_text=(
+            "The original actor causing this deletion. Could be the author "
+            "of a manual clean command invocation, the bot when executing "
+            "automatic actions, or nothing to indicate that the bulk "
+            "deletion was not issued by us."
+        ),
+        null=True
+    )
+    creation = models.DateTimeField(
+        # Consider whether we want to add a validator here that ensures
+        # the deletion context does not take place in the future.
+        help_text="When this deletion took place."
+    )
+
+
+class DeletedMessage(Message):
+    deletion_context = models.ForeignKey(
+        MessageDeletionContext,
+        help_text="The deletion context this message is part of.",
+        on_delete=models.CASCADE
+    )
+
+
 class Tag(ModelReprMixin, models.Model):
     """A tag providing (hopefully) useful information."""