Create
Query
db.sqlite3
—
core_plugins
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 3 in core_plugins
id
Primary key.
INTEGER NOT NULL
name
varchar(100) NOT NULL
friendly_name
varchar(100) NOT NULL
version
varchar(20) NOT NULL
manifest
{"name": "twilio", "friendly_name": "Twilio SMS", "version": "1.0", "description": "Twilio SMS integration for sending and receiving text messages", "capabilities": {"incoming": true, "outgoing": true}, "formatting": {"header_template": "\ud83d\udcf1 SMS from {{ from }}", "message_format": "text"}, "webhook": {"enabled": true, "path": "/webhook/", "method": "POST", "description": "Configure this webhook URL in your Twilio phone number settings"}, "config_schema": {"account_sid": {"type": "string", "required": true, "label": "Account SID", "help_text": "Your Twilio Account SID from the Twilio Console"}, "auth_token": {"type": "password", "required": true, "label": "Auth Token", "help_text": "Your Twilio Auth Token from the Twilio Console"}, "phone_number": {"type": "string", "required": true, "label": "Twilio Phone Number", "help_text": "Your Twilio phone number (format: +1234567890)", "placeholder": "+1234567890"}}, "user_config_schema": {"phone_number": {"type": "string", "required": true, "label": "Phone Number", "help_text": "Your mobile phone number to receive SMS (format: +1234567890)", "placeholder": "+1234567890"}}, "message_schemas": {"incoming": {"raingull_id": {"type": "UUIDField", "required": true, "unique": true}, "message_sid": {"type": "CharField", "max_length": 255, "required": true, "unique": true}, "from_number": {"type": "CharField", "max_length": 20, "required": true}, "to_number": {"type": "CharField", "max_length": 20, "required": true}, "body": {"type": "TextField", "required": true}, "status": {"type": "CharField", "max_length": 20, "choices": ["new", "processed"], "default": "new"}, "num_media": {"type": "IntegerField", "default": 0}, "media_urls": {"type": "JSONField", "required": false}, "created_at": {"type": "DateTimeField", "auto_now_add": true}, "processed_at": {"type": "DateTimeField", "required": false}}, "outgoing": {"raingull_id": {"type": "UUIDField", "required": true, "unique": true}, "message_sid": {"type": "CharField", "max_length": 255, "required": false}, "to_number": {"type": "CharField", "max_length": 20, "required": true}, "from_number": {"type": "CharField", "max_length": 20, "required": true}, "body": {"type": "TextField", "required": true}, "status": {"type": "CharField", "max_length": 20, "choices": ["formatted", "queued", "sending", "sent", "failed"], "default": "formatted"}, "created_at": {"type": "DateTimeField", "auto_now_add": true}, "sent_at": {"type": "DateTimeField", "required": false}, "error_message": {"type": "TextField", "required": false}}}, "translation_rules": {"from_raingull": {"to_number": "recipient", "body": "content", "from_number": "sender"}, "to_raingull": {"sender": "from_number", "recipient": "to_number", "content": "body", "subject": "'SMS Message'"}}}
TEXT NOT NULL
enabled
bool NOT NULL
created_at
datetime NOT NULL
updated_at
datetime NOT NULL
Update
Cancel