JDBC Backing Store Configuration : Backing Store Table Reference

Backing Store Table Reference
Each ontology type in the backing store has its own primary table and zero or more second-level tables. There are only two levels of tables, which makes the database easier to manage and easier to understand.
Primary Tables
Primary tables contain only primitive properties such as the following:
cacheId
time_created$
time_last_modified$
parent$_id$
id$
extId$
state$
And various Value fields
Secondary Tables
Secondary tables are used for complex properties, that is, arrays, properties with history, and concept relationship properties. Each array and history-enabled property has a separate table. Only primitive properties are stored in the primary table.
Reverse Reference Tables
Each concept also has a reverse reference table. This table’s name contains the concept name and ends with the characters _rrf$. It has these columns:
 
Class-to-Table Mapping
This table contains the mapping between class names and table names, and the mapping between complex property field names and secondary table names.
for example:
'be.gen.Ontology.DeleteVerifyEvent', 'D_DeleteVerifyEvent‘
'be.gen.Ontology.Treatment', 'D_Treatment‘
‘be.gen.Ontology.Treatment', 'rrf$', 'D_Treatment_rrf$‘
'be.gen.Ontology.BaseAlert', 'treatments', 'D_BaseAlert_treatments'