Specifications
Crestron e-control Mail SW-MAIL
43 •• The e-Mail Database Tables Installation & Reference Guide — Doc. 5798
The Queries table
The Queries table is used by scroller signal blocks to form queries which
provide access to the data in the other tables. Using the Database | Queries Table…
command, you can view this table’s data. As supplied, the Queries table in the
sample database file is already set up for accessing the other tables. For more
information on the structure and use of the Queries table, refer to the SW-DBM
manual, Doc. 5823.
Tables for sending e-mail
The e-Mail Tables window (shown on the next page) provides access to all three
tables used by the e-mailer signal blocks for sending e-mail. However, in the figure,
which shows the contents of the supplied sample database file, you can see that a
number of records have already been added to each table. You may edit the fields
right in this window (see “Editing the Existing Database” on page 46).
All the fields visible in this window represent required fields which must not be
eliminated. Using other software, such as Microsoft Access, you may insert
additional fields into the tables for your own purposes. Such fields will be accessible
in the e-Mail Tables window. Although not used by the e-mailer signal block, these
fields can appear indirectly, as columns in touchscreen “scrollers” bound to the
e-Mailer signal block.
One thing to note about these three tables is the one field they share in common. The
ID field is used in all three tables a “primary key” for looking up data. As a primary
key, the value of this field must be unique for each record in a given table.
The “e-Mail Tables” window, showing contents of tables
from the supplied sample database file
The following subsections discuss the interesting features of each table shown above.
Note that all defined e-mailers will use the same three tables.
The eMail_Msg Table
Each record in the eMail_Msg table must contain at least the following fields:
ID, abbr, subj, body, and defaultAddr. The defaultAddr field can either be blank or
may contain a reference to a single default recipient, represented by the ID number
of a record in the eMail_Addr table.