The physical models contain all tables
and columns needed for the message templates and sample queries provided with RAP. Each table is used in at least one diagram. All tables
and columns have detailed descriptions.
-
All primary keys and foreign-key constraints use standard naming conventions, that is, PK_table
name and FKnn_table name for
a primary key and foreign-key constraint, respectively, where nn is
the constraint number.
-
Datatypes are assigned to table columns via
domains.
The multibyte RAPCache and RAPStore models include one more domain, SYB_LONGSTRING, than the single-byte models. Domain
names are defined as SYB_domain name.
- Model indexes are named as XKnn_table
name, where nn is the index number.
-
Only indexes needed to support the sample queries
are included in the model. You can add indexes to meet site-specific requirements
for data-load and query performance.