Skip Navigation
Expand
What does this table named "ac_..." relate to?
Answer ID 8763   |   Last Review Date 07/22/2019

What are the tables that start with two letters followed by an underscore? (ma_trans, ac_columns, etc)

Environment:

All Sites, Tables
Oracle B2C Service

Issue:

There are a number of tables with baffling names, such as ac_nodes. What do they relate to?

Resolution:

The table schema is consistently built with trunk tables, each of which may have a number of related branch tables. Each of the branch tables are named in such a manner that they can be identified and related to the trunk table using the following method: the name of the trunk table is abbreviated to a pair of letters followed by an underscore, followed by the remainder of the table name, which may contain further underscores.

For example, in an imaginary set of data, Dragon Families, the trunk table would be called dragon_families, and it might have branch tables such as df_crests, df_family_trees, or df_allegiances.

Partial list of tables, their uses, & abbreviations:
 Use  Trunk Table Abbreviation
 Analytics Core  analytics_core ac_
 Custom Fields
cf_
 Custom Objects
co_
 Knowledge Foundation
kf_
 Marketing Activities
ma_

And so on.

For information on accessing the Data Dictionary, where tables and fields are listed, refer to Answer ID 2611: Accessing the data dictionary.

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.