Configuration Guide › Relational Database Management › How to Describe a Database in a Directory Configuration File › Managed Object Descriptions › Database Tables

Database Tables

Use the Table element in the directory configuration file to define the tables that store information about a managed object.

Each managed object must have one primary table that contains the unique identifier for the object. Additional information may be stored in secondary tables.

The following illustration shows a database that stores user information in a primary and secondary table:

If an object’s information is stored in multiple tables, create a Table element for each table. Use the Reference element in the Table element for a secondary table to define its relationship to the primary table.

For example, if basic information about a user is stored in tblUsers and address information is stored in tblUserAddress, the table definitions for the User managed object would resemble the following entries:

<Table name="tblUsers" primary="true" />
<Table name="tblUserAddress">
  <Reference childcol="userid" primarycol="id" />
</Table name>