You are here: ListManager Programmer's Guide > ListManager Tables > Message Archives > wordmessage_

Summary of the "wordmessage_" fields in ListManager

 

The wordmessage_ table creates a relationship betweens words in a message and the Message ID. This table is used for full text searching. When a message is received for a list that is set to keep message archives multiple entries are made into this table to keep the relationship of which words occur in which messages. When a message is deleted, this table is automatically cleaned of entries for that message.

 

Primary key: none

 

Field Name

Description

Version Added

Context_

Was the word found in the (H)eader, the (B)ody or in both (A)? (char(1), NOT NULL)

 

ListID_

What list did this message belong to? Reference into lists_ table. (int, NOT NULL)

 

MessageID_

What message ID was this message assigned to? References outmail_, but outmail_ records may be purged. (int, NOT NULL)

 

WordID_

Reference to the word in the uniquewords_ table. (int, NOT NULL)

 

   

Lyris, Inc.

6401 Hollis Street., # 125

Emeryville, CA 94608



Customer Support:

1-888-LYRIS-CS (1-888-597-4727)

or

1-571-730-5259



Hours:

Monday through Friday

6:00 a.m.--6:00 p.m. PST

Self-Serve Portal:

http://www.lyris.com/customer-service/contact-support/