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

CREATE TABLE "core_messages"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "raingull_id" char(32) NOT NULL UNIQUE,
  "status" varchar(20) NOT NULL,
  "service_message_id" varchar(255) NULL,
  "subject" varchar(255) NULL,
  "sender" varchar(255) NULL,
  "timestamp" datetime NULL,
  "payload" text NOT NULL CHECK ((JSON_VALID("payload") OR "payload" IS NULL)),
  "standardized_payload" text NULL CHECK ((JSON_VALID("standardized_payload") OR "standardized_payload" IS NULL)),
  "attachments" text NOT NULL CHECK ((JSON_VALID("attachments") OR "attachments" IS NULL)),
  "is_urgent" bool NOT NULL,
  "error_message" text NULL,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL,
  "standardized_at" datetime NULL,
  "user_id" varchar(8) NULL REFERENCES "core_users" ("uuid") DEFERRABLE INITIALLY DEFERRED,
  "service_id" bigint NOT NULL REFERENCES "core_services" ("id") DEFERRABLE INITIALLY DEFERRED
)

CREATE INDEX "core_messag_raingul_d1952f_idx"
ON "core_messages" ("raingull_id")

CREATE INDEX "core_messag_service_3d9926_idx"
ON "core_messages" ("service_message_id")

CREATE INDEX "core_messag_service_db01e1_idx"
ON "core_messages" ("service_id", "status")

CREATE INDEX "core_messag_timesta_858a17_idx"
ON "core_messages" ("timestamp")

CREATE INDEX "core_messages_created_at_af5ea1bd"
ON "core_messages" ("created_at")

CREATE INDEX "core_messages_sender_9afaa9c6"
ON "core_messages" ("sender")

CREATE INDEX "core_messages_service_id_c1ff706b"
ON "core_messages" ("service_id")

CREATE INDEX "core_messages_service_message_id_81abb39d"
ON "core_messages" ("service_message_id")

CREATE INDEX "core_messages_status_12ebd9c4"
ON "core_messages" ("status")

CREATE INDEX "core_messages_subject_472e9249"
ON "core_messages" ("subject")

CREATE INDEX "core_messages_timestamp_15ed5f4c"
ON "core_messages" ("timestamp")

CREATE INDEX "core_messages_user_id_42fcd114"
ON "core_messages" ("user_id")