The `message` table schema from chat.db

message.sql

CREATE TABLE message (
  ROWID INTEGER PRIMARY KEY AUTOINCREMENT, 
  guid TEXT UNIQUE NOT NULL, 
  text TEXT, 
  replace INTEGER DEFAULT 0, 
  service_center TEXT, 
  handle_id INTEGER DEFAULT 0, 
  subject TEXT, 
  country TEXT, 
  attributedBody BLOB, 
  version INTEGER DEFAULT 0, 
  type INTEGER DEFAULT 0, 
  service TEXT, 
  account TEXT, 
  account_guid TEXT, 
  error INTEGER DEFAULT 0, 
  date INTEGER, 
  date_read INTEGER, 
  date_delivered INTEGER, 
  is_delivered INTEGER DEFAULT 0, 
  is_finished INTEGER DEFAULT 0, 
  is_emote INTEGER DEFAULT 0, 
  is_from_me INTEGER DEFAULT 0, 
  is_empty INTEGER DEFAULT 0, 
  is_delayed INTEGER DEFAULT 0, 
  is_auto_reply INTEGER DEFAULT 0, 
  is_prepared INTEGER DEFAULT 0, 
  is_read INTEGER DEFAULT 0, 
  is_system_message INTEGER DEFAULT 0, 
  is_sent INTEGER DEFAULT 0, 
  has_dd_results INTEGER DEFAULT 0, 
  is_service_message INTEGER DEFAULT 0, 
  is_forward INTEGER DEFAULT 0,
  was_downgraded INTEGER DEFAULT 0, 
  is_archive INTEGER DEFAULT 0, 
  cache_has_attachments INTEGER DEFAULT 0, 
  cache_roomnames TEXT, 
  was_data_detected INTEGER DEFAULT 0, 
  was_deduplicated INTEGER DEFAULT 0
);