SQLite Web: db.sqlite3

id

Primary key. INTEGER NOT NULL

raingull_id

char(32) NOT NULL

status

varchar(20) NOT NULL

service_message_id

varchar(255)

subject

varchar(255)

sender

varchar(255)

timestamp

datetime

payload

{"content": "", "attachments": [], "metadata": {"subject": "Re: Rehearsal Scheduling", "date": "Sun, 5 Oct 2025 19:59:09 -0700", "headers": {"Return-Path": "<ptmurder+bncBC3K3L6FV4GBBCXBRTDQMGQE252YJLY@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple (24-113-167-77.wavecable.com. [24.113.167.77])\r\n        by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-339a701cbffsm14654285a91.21.2025.10.05.19.59.20\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Sun, 05 Oct 2025 19:59:20 -0700 (PDT)", "Return-path": "<ptmurder+bncBC3K3L6FV4GBBCXBRTDQMGQE252YJLY@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Mon, 06 Oct 2025 02:59:24 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1759719562; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=j/WA3dKl8OgZxhTLl5mbCH8kfcrzLR3nFHZ5Glsbi70cw7eSSfcI0JIsbgtMlVj0Lx\r\n         2b7gGa9daW/A6eWCZRofN1wDAQ2jz9muoGBzQNJCqncmk95PhetnYZcXhRu7t23TaTy/\r\n         BHnJJ812xtCxyZqvG332rBx8b4m6rVYUKUpby5F2VpFqz6i5hVgmQ8lk2bsYGWgsMhyF\r\n         RtbA6PqGdP4hWuhPqg+bIYf0x045eNQfzbCdkGo9r3pxJU2/otgiMJJVnaxbIQRRmtTZ\r\n         MSKWP65y+rHa4N1Dz1XjHP2lb/OlHRfK3H7ENFku3mKwjinJOuKOIp4jwUipLBz2UVXO\r\n         pwvg==", "ARC-Message-Signature": "i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605;\r\n        h=to:in-reply-to:references:message-id:date:subject:mime-version:from\r\n         :content-transfer-encoding:dkim-signature;\r\n        bh=yFyGTFn/KT4GSsKUfx1DlUKYaG8fWSYDqUYBhXP2vW8=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=XjKOxP/6NLd4hDrTciNbwuhDMzuzLp2mL2gQJfSwdLLXO2diZCvGtQ79y57c27kMPR\r\n         FlKllvAXagvXu47QZ514+ZPRcd5EjV9Cf6y4vWXU+X2jLdCTO/92pbmfblQR67/DRDDh\r\n         6b4m2izygo903IwXLlv56CmjokuixzImjML+8s5Hn3mZfq19WvkfQ+A/fn5Tlz5sQndr\r\n         A17fUH6tdkHGfVBgOJH87MH5xXgivvCYT/h/aokqQ9LdC+bgtr42xkrmd8WxIMqr+ewc\r\n         xLnevQvz9z885j0pHdwB5hspbbEatkPDyFi3YiDgGwPCyzgrLuTbU+uobTr1OKSofnZB\r\n         8lzQ==;\r\n        dara=google.com", "ARC-Authentication-Results": "i=1; gmr-mx.google.com;\r\n       dkim=pass header.i=@gmail.com header.s=20230601 header.b=NZ65XW70;\r\n       spf=pass (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::102c as permitted sender) smtp.mailfrom=megpixels@gmail.com;\r\n       dmarc=pass (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;\r\n       dara=pass header.i=@googlegroups.com", "DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=gmail.com; s=20230601; t=1759719563; x=1760324363; darn=raingull.org;\r\n        h=list-unsubscribe:list-archive:list-help:list-post:list-id\r\n         :mailing-list:precedence:reply-to:x-original-authentication-results\r\n         :x-original-sender:to:in-reply-to:references:message-id:date:subject\r\n         :mime-version:from:content-transfer-encoding:from:to:cc:subject:date\r\n         :message-id:reply-to;\r\n        bh=x6UlZ6ruLwrgjOI9vbcqQ44NgkhV2SGOWX0DVGd0St4=;\r\n        b=W6EGDAwz4rqV6WrZf5URfB4P7J172k/z3yWaWe2x4yio/hGsAiwn3pu8MNJQOtVWOQ\r\n         bDd25MeQBRA8ZYWEYhtG5TRt/IspWdBwei3I9Cs8w3CvylyhbP0jTnxqt5iO1H6D+w7y\r\n         2ZD2llvj5ULZafgUjhf6yeSwXxX0JVP6iKYozFfdhxXgnbVBqFQPwcIChQ2VjUlg9HP4\r\n         MAB4u/FN0OYA/Uqww30RPsrCtw5BhWSWDXuEQBWmPE6kDBgc2ahcB5HLJ8jAzM3J9oZ5\r\n         2csHW5eIS9vEHPIy2gcgljP4NjNFqfozSlTEKE/eWJBzziMo++U4DdubuezZWXLegbzx\r\n         RrFw==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1759719563; x=1760324363;\r\n        h=list-unsubscribe:list-archive:list-help:list-post\r\n         :x-spam-checked-in-group:list-id:mailing-list:precedence:reply-to\r\n         :x-original-authentication-results:x-original-sender:to:in-reply-to\r\n         :references:message-id:date:subject:mime-version:from\r\n         :content-transfer-encoding:x-beenthere:x-gm-message-state:sender\r\n         :from:to:cc:subject:date:message-id:reply-to;\r\n        bh=x6UlZ6ruLwrgjOI9vbcqQ44NgkhV2SGOWX0DVGd0St4=;\r\n        b=tuc21qw5qeBO5Qjgy1kUWM1BnTfKS+K7/7vWxASWeAYh6Vw3wR2v2eV99TNgcJ7XkQ\r\n         iS7MIgkJMiGK9dK26mDtSANMC38Snqgh0rX/TM8NVNvBPhj3V2Kq5H6Z8X8ABJYLTPxw\r\n         XSLmQ3Ee+jxvOCJNuebWmYJP/8bzGjcXur3C56bosNQ6Q1MfGaqqtl9F5v11krtVvNEq\r\n         P0AFszrsVg6+v/BhhRR17hV3IBA6jSzFtCDlqAlBHCqUgRKeEZjvW48bWPC8DsXQnjO4\r\n         H4dBkyOQ8gbDEf2lADge7DJgS5oNf+c9nkj1SnLEmrVIf+NZ01msqCqGLa15uQM7u3kq\r\n         IGEQ==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCW5czxyS1gjeCWhfENaOlPaucLnQ9Z9xBGyT9Kny1ldVi0vtW8o8zO7UeOIvGq8YXAcuik0@raingull.org", "X-Gm-Message-State": "AOJu0Yx4mrNwdhB3k+6KqSw6IozaAEXK1/1jYAjC3+J8su1m5n/BSNfh\r\n\tgl39b3uZNQNahUWGhdwMVeWJCtSbV+4G/3adpGJLjwSNMg32O42D86I=", "X-Google-Smtp-Source": "AGHT+IHBrHilY+lFPpNbZc8WTRUjstIMINult6w/Pc0gfra0km9ghujUaLBd2a9QejGaNyo7ZmWvNg==", "X-Received": "by 2002:a17:90b:28d0:b0:330:797a:f504 with SMTP id 98e67ed59e1d1-339c2706797mr13063706a91.3.1759719560955;\r\n        Sun, 05 Oct 2025 19:59:20 -0700 (PDT)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"ARHlJd4et55T8GEM26fXIXD+d/iEasT2EJjxhOsZJdFRuks9cQ==\"", "Received-SPF": "pass (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::102c as permitted sender) client-ip=2607:f8b0:4864:20::102c;", "X-Gm-Gg": "ASbGncux6SUCsVpIADRBcRQhtZXND/QDZzqWumE2IrOaRe7B2zb+WKjmt8ZFus7Uul1\r\n\tka0EIVD85Tn4RGzfn0ngAqvmZmfdHWpHVoChri1nL48B5bSVjb2yMC3r3nwiuYXk2ctol+yrWgs\r\n\tFl1oO0zMo1VJ+vb58vXcwZvaerO+57JmSTM/6+ngf6pPSQ87jbhhiM/bPKjmK10kzePdqRAQKpY\r\n\tTnOhzqzM4vlLv1KhhJSuOWw+0aGW4hDzekEoHEe5SzR3F8Dxs8fiaCH0j900UZ75Nj3Yxyv1smO\r\n\tvQsqtw4AD+pAXNKMdhrjrg0p3Xh+kM74wOLc4Zv2gh9uImW3sCiqvNXCmjmt7qhi9tJWo5ER6Xf\r\n\tFp2GoXtFSNBtPj96MdKaKDIPjggr3gBjCCsWIpHiBTyzT/q1eTCOiRZyxNj9oVHgbV2GgezRyIn\r\n\tvA4gnWYeHm03Dmy82ndXjA0xCs", "Content-Type": "multipart/alternative; boundary=Apple-Mail-A5A111BA-BBF2-4B13-A287-A8DE08B30E0A", "Content-Transfer-Encoding": "7bit", "From": "Megan DeVries <megpixels@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Rehearsal Scheduling", "Date": "Sun, 5 Oct 2025 19:59:09 -0700", "Message-Id": "<BE7717AF-D02C-4C43-9B0C-2969ABC2FFAA@gmail.com>", "References": "<CAPcF4QbBY2wYH+4CCTiAePGf0-tDnXytq+9_Zgp9xmUMro_dwg@mail.gmail.com>", "In-Reply-To": "<CAPcF4QbBY2wYH+4CCTiAePGf0-tDnXytq+9_Zgp9xmUMro_dwg@mail.gmail.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G86)", "X-Original-Sender": "megpixels@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=NZ65XW70;       spf=pass\r\n (google.com: domain of megpixels@gmail.com designates 2607:f8b0:4864:20::102c\r\n as permitted sender) smtp.mailfrom=megpixels@gmail.com;       dmarc=pass\r\n (p=NONE sp=QUARANTINE dis=NONE) header.from=gmail.com;       dara=pass header.i=@googlegroups.com", "Reply-To": "ptmurder@googlegroups.com", "Precedence": "list", "Mailing-list": "list ptmurder@googlegroups.com; contact ptmurder+owners@googlegroups.com", "List-ID": "<ptmurder.googlegroups.com>", "X-Spam-Checked-In-Group": "ptmurder@googlegroups.com", "X-Google-Group-Id": "27968096625", "List-Post": "<https://groups.google.com/group/ptmurder/post>, <mailto:ptmurder@googlegroups.com>", "List-Help": "<https://groups.google.com/support/>, <mailto:ptmurder+help@googlegroups.com>", "List-Archive": "<https://groups.google.com/group/ptmurder", "List-Unsubscribe": "<mailto:googlegroups-manage+27968096625+unsubscribe@googlegroups.com>,\r\n <https://groups.google.com/group/ptmurder/subscribe>", "X-DKIM": "signer='gmail.com' status='pass' reason=''", "DKIMCheck": "Server passes DKIM test, 0 Spam score", "X-Spam-Score": "4.5 (++++)", "X-Spam-Report": "Spam detection software, running on the system \"heracles.mxrouting.net\", has\r\n performed the tests listed below against this email.\r\n Information: https://mxroutedocs.com/directadmin/spamfilters/\r\n ---\r\n Content analysis details:   (4.5 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\r\n  0.0 URIBL_BLOCKED          ADMINISTRATOR NOTICE: The query to URIBL was blocked.\r\n                             See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#dnsbl-block\r\n                              for more information.\r\n                             [URI: googlegroups.com]\r\n  0.0 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\r\n  0.0 ARC_SIGNED             Message has a ARC signature\r\n -0.1 DKIM_VALID_EF          Message has a valid DKIM or DK signature from\r\n                             envelope-from domain\r\n  0.0 ARC_VALID              Message has a valid ARC signature\r\n -0.1 DKIM_VALID_AU          Message has a valid DKIM or DK signature from author's\r\n                             domain\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\r\n -0.1 DKIM_VALID             Message has at least one valid DKIM or DK signature\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [megpixels(at)gmail.com]\r\n  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\r\n  2.0 MIME_HTML_ONLY         BODY: Message only has text/html MIME parts\r\n  0.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\r\n  0.0 HTML_FONT_FACE_BAD     BODY: HTML font face is not a word\r\n  1.5 HTML_MESSAGE           BODY: HTML included in message\r\n  0.0 FREEMAIL_FORGED_FROMDOMAIN 2nd level domains in From and EnvelopeFrom\r\n                              freemail headers are different\r\n  0.0 MIME_HTML_ONLY_MULTI   Multipart message only has text/html MIME parts\r\n -1.0 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager\r\n  0.0 RCVD_IN_VALIDITY_SAFE_BLOCKED RBL: ADMINISTRATOR NOTICE: The query to\r\n                              Validity was blocked.  See\r\n                             https://knowledge.validity.com/hc/en-us/articles/20961730681243\r\n                              for more information.\r\n                             [74.125.224.62 listed in sa-accredit.habeas.com]\r\n  0.0 RCVD_IN_VALIDITY_RPBL_BLOCKED RBL: ADMINISTRATOR NOTICE: The query to\r\n                              Validity was blocked.  See\r\n                             https://knowledge.validity.com/hc/en-us/articles/20961730681243\r\n                              for more information.\r\n                             [74.125.224.62 listed in bl.score.senderscore.com]\r\n  0.0 RCVD_IN_VALIDITY_CERTIFIED_BLOCKED RBL: ADMINISTRATOR NOTICE: The\r\n                             query to Validity was blocked.  See\r\n                             https://knowledge.validity.com/hc/en-us/articles/20961730681243\r\n                              for more information.\r\n                          [74.125.224.62 listed in sa-trusted.bondedsender.org]\r\n  0.0 RCVD_IN_DNSWL_BLOCKED  RBL: ADMINISTRATOR NOTICE: The query to DNSWL\r\n                             was blocked.  See\r\n                             http://wiki.apache.org/spamassassin/DnsBlocklists#DnsBlocklists-dnsbl-block\r\n                              for more information.\r\n                             [74.125.224.62 listed in list.dnswl.org]", "SpamTally": "Final spam score: 45"}}}

TEXT NOT NULL

standardized_payload

TEXT

attachments

TEXT NOT NULL

is_urgent

bool NOT NULL

error_message

TEXT

created_at

datetime NOT NULL

updated_at

datetime NOT NULL

standardized_at

datetime

user_id

varchar(8)

service_id

bigint NOT NULL

db.sqlite3 — core_messages

Update row 11 in core_messages