You can modify the definitions of tables or add new tables to the database.
Consider the following guidelines when you extend the data model:
Check if you can use an existing child base object.
Do not add a root base object to store the person or organization information.
Do not define tables with names greater than 24 characters.
Do not delete existing base objects.
Do not delete existing columns.
Do not modify the physical names of existing base objects. However, you can modify the display names.
Do not modify the data type of an existing column.
Do not decrease the length of an existing column.
Prefix the names of the new base object tables to distinguish the tables from the existing tables. The prefix indicates the type of table. Use the following naming convention when you create a base object:
Prefix
Table
C_XO_
Root or child record base object.
C_XR_
Relationship base object.
C_XT_
Lookup base object.
If you add a column to an existing table, prefix the name of a column with
X_
.
For more information about adding tables and columns, see the