|
Configuring Siebel eBusiness Applications > Configuring Tables and Columns >
About Tables
Table object definitions are logical representations in the Siebel repository of the physical tables in the underlying database management system. You can extend the Siebel data model using extension tables and extension columns to base tables but you cannot add new base tables, delete base tables and columns, or modify the properties of base columns. NOTE: The term base table can refer to the table that an extension table extends, as specified in the Base Table property of the extension table's object definition. It can also refer to the table on which a business component is built, as specified in the Table property of the Business Component object definition.
Topics in This Section
Table Naming Conventions
Table Properties
Table Naming Conventions
Tables in the Siebel database use a three-part naming convention. The syntax is: PREFIX_NAME_SUFFIX.
PREFIX |
Table names in Siebel eBusiness Applications have a one- to three-letter prefix (EIM_, S_, W_, and so on) to distinguish them from other tables in your application. |
NAME |
A unique table name that is generally an abbreviation of the entity supertype name. |
SUFFIX |
A supertype name may be followed by the entity subtype. For example, the supertype EVT (event) has ACT (activity) as one of its subtypes. Thus, the name becomes S_EVT_ACT. |
The prefix indicates the part of the Siebel schema to which a table belongs. Table 11 provides some of the prefixes and their descriptions.
Table 11. Table Prefixes
|
|
EIM_ |
Interface tables for Enterprise Integration Manager. |
S_ |
Siebel base table. (Exception: Tables with names of the form S_<name>_IF are obsolete interface tables.) |
W_ |
Siebel eBusiness Data Warehouse table. |
The suffix indicates a table type. Table 12 provides some of the suffixes and their descriptions.
Table 12. Base Table Suffixes
|
|
_ATT |
File attachment table. |
_REL |
A table that supports a many-to-many relationship from an entity back to itself. |
_SS |
A table that stores Siebel-to-Siebel integration information. |
_X |
One-to-one extension table, available for customers to add attributes to the Siebel database. |
_XA |
A table that stores extended attributes associated with an object class. |
_XM |
One-to-many extension table, available for customers to add attributes to the Siebel database. |
Table Properties
The key properties of the table object type are listed below. For a complete list of Table properties, see Object Types Reference.
- Name. Provides the name of the table in the DBMS.
- Type. Defines the table type. See Table 13.
- Base Table. Identifies the base table if the table in the object definition is an extension table. If the table in the object definition is a base table, this property is blank. An extension table always identifies a base table.
- User Name. A longer, descriptive name that aids in identifying the table when used in configuration.
- Comments. Can be used to provide a long description of the table, such as the type of data that is stored in the table.
- Status. The current status of a table. States whether tables from previous versions of Siebel eBusiness applications can be used in the most recent version of the application.
Table 13 lists possible values for the Type property.
Table 13. Table Types
|
|
Data (Public) |
Public data tables are among the original set of tables implemented in Siebel applications. They hold data that is made available through business components to developers and users. Public data tables can be extended using extension tables and extension columns. |
Data (Private) |
Private data tables are similar to public data tables, but cannot have extension columns. |
Data (Intersection) |
Intersection data tables implement a many-to-many relationship between two data tables. |
Extension |
Tables of type extension are additional tables with implicit 1:1 relationships to its parent base table, the table it logically extends. They provide additional columns that you can use to store data. Tables with implicit 1:M relationships to base tables are also commonly referred to as extension tables. However, these tables have a type property of Data (Public) not Extension. |
Interface |
Interface tables are used by Siebel Enterprise Integration Manager (EIM) to import data for populating one or more base tables and subsequently to perform periodic batch updates between Siebel applications and other enterprise applications. Interface table names end in _IF or _XMIF. |
Database View |
Reserved for Siebel internal use. |
Dictionary |
Reserved for Siebel internal use. |
Journal |
Reserved for Siebel internal use. |
Log |
Reserved for Siebel internal use. |
Repository |
Reserved for Siebel internal use. |
Virtual Table |
Reserved for Siebel internal use. |
Warehouse Types |
Reserved for Siebel internal use. |
Extension (Siebel) |
These tables are reserved for Siebel use only. They are usually extensions from S_PARTY. |
|
