3 files changed, 44 insertions, 0 deletions
diff --git a/pydis_site/apps/api/models/bot/__init__.py b/pydis_site/apps/api/models/bot/__init__.py
index 6f09473d..c07a3238 100644
--- a/pydis_site/apps/api/models/bot/__init__.py
+++ b/pydis_site/apps/api/models/bot/__init__.py
@@ -8,6 +8,8 @@ from .infraction import Infraction
 from .message import Message
 from .aoc_completionist_block import AocCompletionistBlock
 from .aoc_link import AocAccountLink
+from .mailing_list import MailingList
+from .mailing_list_seen_item import MailingListSeenItem
 from .message_deletion_context import MessageDeletionContext
 from .nomination import Nomination, NominationEntry
 from .off_topic_channel_name import OffTopicChannelName
diff --git a/pydis_site/apps/api/models/bot/mailing_list.py b/pydis_site/apps/api/models/bot/mailing_list.py
new file mode 100644
index 00000000..eaca8fb5
--- /dev/null
+++ b/pydis_site/apps/api/models/bot/mailing_list.py
@@ -0,0 +1,13 @@
+from django.db import models
+
+from pydis_site.apps.api.models.mixins import ModelReprMixin
+
+
+class MailingList(ModelReprMixin, models.Model):
+    """A mailing list that the bot is following."""
+
+    name = models.CharField(
+        max_length=50,
+        help_text="A short identifier for the mailing list.",
+        unique=True
+    )
diff --git a/pydis_site/apps/api/models/bot/mailing_list_seen_item.py b/pydis_site/apps/api/models/bot/mailing_list_seen_item.py
new file mode 100644
index 00000000..d91cfbe6
--- /dev/null
+++ b/pydis_site/apps/api/models/bot/mailing_list_seen_item.py
@@ -0,0 +1,29 @@
+from django.db import models
+
+from pydis_site.apps.api.models.mixins import ModelReprMixin
+from .mailing_list import MailingList
+
+
+class MailingListSeenItem(ModelReprMixin, models.Model):
+    """An item in a mailing list that the bot has consumed and mirrored elsewhere."""
+
+    list = models.ForeignKey(
+        MailingList,
+        on_delete=models.CASCADE,
+        related_name='seen_items',
+        help_text="The mailing list from which this seen item originates."
+    )
+    hash = models.CharField(
+        max_length=100,
+        help_text="A hash, or similar identifier, of the content that was seen."
+    )
+
+    class Meta:
+        """Prevent adding the same hash to the same list multiple times."""
+
+        constraints = (
+            models.UniqueConstraint(
+                fields=('list', 'hash'),
+                name='unique_list_and_hash',
+            ),
+        )