Bookshelf Home | Contents | Index | PDF |
Configuring Siebel Business Applications > About Tables and Columns > About Siebel Tables > About Columns and Indexes in a Siebel TableA column is a representation of the physical column that resides in the underlying database management system. The Siebel schema records the name, data type, length, primary key status, foreign key status, alias, and other properties of the database column as properties in the corresponding object definition of the column. The schema includes other properties that are internal to Siebel CRM in the object definition, such as the Changed status, Inactive status, and the Type. For more information, see the following topics: Data Columns of a Siebel TableA data column is a column that provides data for a field. It can serve as a foreign key that references a row in another table. Most columns in Siebel CRM are data columns. A data column is sometimes referred to as a base column. A data column can be public or private. You cannot modify the properties of a data column. Extension Columns of a Siebel TableAn extension column is a column that stores custom data. Siebel CRM supports the following types of extension columns:
System Columns of a Siebel TableA system column is a column that Siebel CRM displays in all tables, but it does not include the same set of system columns in every table. You can use the data in a system column for various reasons. For example, you can use the ROW_ID column to create a join. Most system columns are read-only. You typically must not modify the data in a system column. Some exceptions exist, such as using certain system columns in an interface table. For more information, see System Fields of a Business Component. Table 9 describes some of the system columns that Siebel CRM commonly uses.
Siebel CRM updates the following columns: The following columns store the date, time, and user values for the client. They do not store the date, time, and user values for the Siebel database: Indexes of a Siebel TableAn index is a logical representation of a physical index that resides in the underlying database management system. Siebel CRM includes a set of predefined indexes. The name for each index contains an S_ prefix. You must not modify or delete a predefined index. You can create a custom index. For more information, see Properties of an Index of a Siebel Table and Creating a Custom Index. Index Columns of an IndexAn index column is a child object of the index object. The object definition for an index column associates one column to the parent index. For more information, see Properties of an Index Column and Creating a Custom Index. |
Configuring Siebel Business Applications | Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |