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: Video Recording", "date": "Sat, 15 Nov 2025 11:43:16 -0800", "headers": {"Return-Path": "<ptmurder+bncBDI33BGM54FBBYNP4PEAMGQEHDPISZI@googlegroups.com>", "Delivered-To": "list@raingull.org", "Received": "from smtpclient.apple (24-113-163-12.wavecable.com. [24.113.163.12])\r\n        by smtp.gmail.com with ESMTPSA id d9443c01a7336-2985c1800ebsm93634395ad.0.2025.11.15.11.43.26\r\n        for <ptmurder@googlegroups.com>\r\n        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);\r\n        Sat, 15 Nov 2025 11:43:26 -0800 (PST)", "Return-path": "<ptmurder+bncBDI33BGM54FBBYNP4PEAMGQEHDPISZI@googlegroups.com>", "Envelope-to": "list@raingull.org", "Delivery-date": "Sat, 15 Nov 2025 19:43:31 +0000", "ARC-Seal": "i=1; a=rsa-sha256; t=1763235808; cv=none;\r\n        d=google.com; s=arc-20240605;\r\n        b=HeIBYYc+UtKrI7C1+Q32ZUXNXPOnTBYaUTJBqXsBt0p0lJnjXONAPdAOSQC1YJq567\r\n         lfuod0MWBac9oHVuX+HLc2JXATO9Io/SS68Xm4PEpj6TSBA25Ni0mm9JElZbNhqdwP+S\r\n         H7OvyRK+W8VZblFvkbKOGKVlqiLqGJ68a2KbrKpUneXmCC7Dc/MUqhP0DPspzKWjQbOP\r\n         bob5RP8+ReqpMIAuDYBBF+uKDNxeRqh4RgsDgBSTPt9hy9V9dl26ctbWgqFUGoe5s9tO\r\n         lpN/Byk0Fon0iCmxydcqiR3I9w7jzBVvxXL7JBQPN6nvVTPlH7HUZWINeg4Fb3P5Lgmt\r\n         cjJg==", "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=7V9KOUFJHxxlEYS2WXeRia5Swliz5HD0P1tgx0l6XVY=;\r\n        fh=VWxd+4XoWuQBVy1nj5plb48j0FHRV0wF+W10pQiFjHI=;\r\n        b=VFHtslb6r2AwASkfBbYCSN2aKbkVHnQx7+gbH1HgXoRs02/60OUyvnAqkcs346v/Oh\r\n         WRCeOy2edhKyMceRatnRPur98TYdWq87+R5jfIftpHul693ypSuiiH2w1icbj9DcUSUN\r\n         J0i+aFuCuGUV5ZZTbD/+keIejzfFr8zr7oxCBSqjTJO8KMLPhsF4nJxQMm+LFRxBPtr7\r\n         LnA6/Hr4N7iTAIMSSS+t/Hal+tMo8kyjcIhpqKphSV5jhdbDJwhESd4b8E8za+a/2m/s\r\n         JkA0XkIsNeXHB4v9kAFhH8BtigjnNJy+zz0ugYc/FnHxun36drzP8iMa7eUYjRakE7kN\r\n         Y9MA==;\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=kaANq42U;\r\n       spf=pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::633 as permitted sender) smtp.mailfrom=jguthrie13@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=1763235810; x=1763840610; 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=uIa4iifkY54ve7l35W9IQTIZEp0icHhk8/ICMD4ei2w=;\r\n        b=Qu4rylvZ7jpfReKQGN+zKpchmdKs4ies7hlOlDFlxdmWeKSvtKKXzSlffeob4z3VBa\r\n         /S2+4k5v8ZtEqya6arjU+faV9lRTYqRVCmndoCTgvoHrhVkD1LXt7SXp75r6THC3ph3V\r\n         mH9t1zWP8TIRASg5XIKey1xGoaYZ9vEL43snlvQayH+J8FvSbyWpD2qkqlyDhAyjMi2H\r\n         tOdJPemK1fRetP7vvsh1Vi/SmuZz9lYtFOXVo0PXV2MaVYmfZb7asq1ij60JIQEsqx3j\r\n         nDIDxN+ABKVixsN7lxV3TuJ5nLOle8jcgCaHeOwFcJFMX3nYf9R2PFeg/GaOnSz6JeyF\r\n         Q9lw==", "X-Google-DKIM-Signature": "v=1; a=rsa-sha256; c=relaxed/relaxed;\r\n        d=1e100.net; s=20230601; t=1763235810; x=1763840610;\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-gm-gg:x-beenthere:x-gm-message-state\r\n         :sender:from:to:cc:subject:date:message-id:reply-to;\r\n        bh=uIa4iifkY54ve7l35W9IQTIZEp0icHhk8/ICMD4ei2w=;\r\n        b=MbjFDtjndT9H27RaztorVg57rhMl5U4yaz+KMVf0l7hR9iEZrvwyHHTh0asFxe06/e\r\n         bhGzJRLc2XdAGFIwHNovJgDW0UKsgrRCtS8KAg5Z2h+mhkco69yCmq1VVHTDO5G4ZrOH\r\n         YyNQizyCkfG4eGqD8S+6yWeC86HYDiPvKLJp7gtY6tJFs/4GYXt4OlPsh+dMilv17FIt\r\n         9uVANdDIx9mmaW8PPaAKlLa4/1H+HLSTQ5RixWLjrNvZWR35so5otfuvNJ+iYWMophZd\r\n         hfkC+oG+3brYRB3Vg/25bpYXP+9tE8RjK2LoyHcQim1YjIvJtf5XJK43IBZc4712zRz1\r\n         AnIA==", "Sender": "ptmurder@googlegroups.com", "X-Forwarded-Encrypted": "i=2; AJvYcCWGdHaQetF2o9ir7C/55sBdKMg6Cf1QdY+wdyIq+I31KyjiFJaATIbiYH+eCLZYUZOAb/0e@raingull.org", "X-Gm-Message-State": "AOJu0YzLT72K5+J9TdML7XSsUcsJZI7gfFrEZ3ZRmziN5nORciPvqiDD\r\n\t4YWRekhuZH1UQUL2zfez9/hba/+F0AVDXVMx+H+Qo+RJxKV2nG2GWI8=", "X-Google-Smtp-Source": "AGHT+IGD7BzzpF6nH/1U3qrUB+DkSBmW5voLgNR1SsrSrZnhmfxeF6+UX2YiTYAL6A+X1fevL495Ow==", "X-Received": "by 2002:a17:903:a8f:b0:295:7453:b58b with SMTP id d9443c01a7336-2986a6b56b4mr85211425ad.4.1763235807475;\r\n        Sat, 15 Nov 2025 11:43:27 -0800 (PST)", "X-BeenThere": "ptmurder@googlegroups.com; h=\"Ae8XA+aEKGu4ywIZ9K8/gyryvFeBsKH2NUlwM67dum2cLwci/Q==\"", "Received-SPF": "pass (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::633 as permitted sender) client-ip=2607:f8b0:4864:20::633;", "X-Gm-Gg": "ASbGnctV6sf91R3JpiYyS+ihCvp5SyC3kWqX1omRhxrk8IPk3WEVDG01yZK2YXgdUcH\r\n\tRUja6NGSTtSJLoMnym9oOaN4blTRJOnxCzdU7BWtU5RpTHMFw1WbcUw3NXZtz/0apnbnoKGQw68\r\n\tbDbhKpYXU9IEojjW1TAcmOa+kNx2buYPPNOUUolikb3q67PG0dBzclb3/zvSrIvLO473U7XMznD\r\n\tTiUdo+J7hmBrPwL4BdkabeozGlTX9tBIGMgDdMsXU9KvBizagpl8G0rLj4Mqrp2lVEFZpEzk0pr\r\n\tSUAp2sDzESOnPwSXZ1Np8/OoK6ZQIyVntvRvagv1EA008k865t40xwL5sANg2qdT//L+SF2QAcm\r\n\tZ20jX5ksGo27+axtVAwnWnTiMhX+M40Q0gb7kGQZF00pEoHbKe6l/Tfbb93235K/tsO7DQfcu22\r\n\tYqwe2jsjGGXFku/F2A5Q54Ka8LE0vpNFDgPf7W3S5jFcxx", "Content-Type": "multipart/alternative; boundary=Apple-Mail-EF85EAD6-4F0D-461E-A216-77854BDE13FF", "Content-Transfer-Encoding": "7bit", "From": "James Guthrie <jguthrie13@gmail.com>", "Mime-Version": "1.0 (1.0)", "Subject": "Re: Video Recording", "Date": "Sat, 15 Nov 2025 11:43:16 -0800", "Message-Id": "<D7B2114D-E439-4D41-98AD-7B0DF12526C4@gmail.com>", "References": "<CY5PR10MB6024FFDDA7D26330F08DE4E094CBA@CY5PR10MB6024.namprd10.prod.outlook.com>", "In-Reply-To": "<CY5PR10MB6024FFDDA7D26330F08DE4E094CBA@CY5PR10MB6024.namprd10.prod.outlook.com>", "To": "ptmurder@googlegroups.com", "X-Mailer": "iPhone Mail (22G100)", "X-Original-Sender": "jguthrie13@gmail.com", "X-Original-Authentication-Results": "gmr-mx.google.com;       dkim=pass\r\n header.i=@gmail.com header.s=20230601 header.b=kaANq42U;       spf=pass\r\n (google.com: domain of jguthrie13@gmail.com designates 2607:f8b0:4864:20::633\r\n as permitted sender) smtp.mailfrom=jguthrie13@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": "5.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:   (5.5 points)\r\n ---\r\n  pts rule name              description\r\n ---- ---------------------- -----------------------------------------\r\n -0.0 RCVD_IN_DNSWL_NONE     RBL: Sender listed at https://www.dnswl.org/, no\r\n                             trust\r\n                             [209.85.219.58 listed in list.dnswl.org]\r\n  0.0 SPF_HELO_NONE          SPF: HELO does not publish an SPF Record\r\n  0.1 DKIM_SIGNED            Message has a DKIM or DK signature, not necessarily valid\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_VALID             Message has at least one valid DKIM or DK signature\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  1.5 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail\r\n                             domains are different\r\n  0.0 FREEMAIL_FROM          Sender email is commonly abused enduser mail provider\r\n                             [jguthrie13(at)gmail.com]\r\n  1.5 HTML_MESSAGE           BODY: HTML included in message\r\n  2.0 MIME_HTML_ONLY         BODY: Message only has text/html MIME parts\r\n  1.0 HTML_FONT_LOW_CONTRAST BODY: HTML font color similar or identical to\r\n                             background\r\n  0.7 MPART_ALT_DIFF         BODY: HTML and text parts are different\r\n  0.0 MIME_HTML_ONLY_MULTI   Multipart message only has text/html MIME parts\r\n  0.0 FREEMAIL_FORGED_FROMDOMAIN 2nd level domains in From and EnvelopeFrom\r\n                              freemail headers are different\r\n -1.0 MAILING_LIST_MULTI     Multiple indicators imply a widely-seen list\r\n                             manager", "SpamTally": "Final spam score: 55"}}}

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 60 in core_messages