Repository items correspond to business objects, like customers, and elements of business objects, like a customer’s shipping address. An item descriptor in an SQL repository defines a repository item type. It specifies repository item properties and the database tables and columns that store the data of those properties. This chapter describes how to define item descriptors and how to represent the relationships between item descriptors in an SQL repository definition.

Note that an SQL repository cannot necessarily work with any arbitrary SQL database model. The basic data model patterns are described in the Sample SQL Repository Definition Files section of the SQL Repository Reference chapter.