Create
Query
db.sqlite3
—
core_messages
auth_group
auth_group_permissions
auth_permission
core_audit_log
core_formatted_messages
core_message_queue
core_messages
core_plugins
core_servicemessagete...
core_services
core_system_configuration
core_systemmessagetemplate
core_user_permissions
core_user_services
core_users
core_users_groups
django_content_type
django_migrations
django_session
sqlite_sequence
user_accounts
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 5 in core_messages
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": "SMS 23", "attachments": [], "metadata": {"from_number": "+13605311445", "to_number": "+13603822448", "num_media": 0, "media_urls": [], "from_city": "PT TOWNSEND", "from_state": "WA", "from_zip": "98368", "from_country": "US"}}
TEXT NOT NULL
standardized_payload
{"subject": "SMS Message", "sender": "+13605311445", "timestamp": "2025-10-03T22:44:38.570090+00:00", "body": "SMS 23", "attachments": [], "raingull_id": "6af8b9a1-dc77-4d37-bc17-bee92ec2d4b9"}
TEXT
attachments
[]
TEXT NOT NULL
is_urgent
bool NOT NULL
error_message
NULL
TEXT
created_at
datetime NOT NULL
updated_at
datetime NOT NULL
standardized_at
datetime
user_id
varchar(8)
service_id
bigint NOT NULL
Update
Cancel