This chapter describes how to configure extension schemas in order to extend the conceptual data model of the Adobe Campaign database.
For a better understanding of Campaign built-in tables and their interaction, refer to the Campaign Classic data model.
The physical and logical structure of the data carried in the application is described in XML. It obeys a grammar specific to Adobe Campaign, called a schema.
A schema is an XML document associated with a database table. It defines data structure and describes the SQL definition of the table:
It also describes the XML structure used to store data:
Schemas enable you to define an entity in the database. There is a schema for each entity.
The following illustration shows the location of schemas in the Adobe Campaign data system:
The root element of the schema is
<srcschema>. It contains the
<element> sub-element coincides with the root of the entity.
<srcSchema name="recipient" namespace="cus"> <element name="recipient"> <attribute name="lastName"/> <attribute name="email"/> <element name="location"> <attribute name="city"/> </element> </element> </srcSchema>
The root element of the entity has the same name as the schema.
<element> tags define the names of entity elements.
<attribute> tags of the schema define the names of the attributes in the
<element> tags which they have been linked to.
A data schema is identified by its name and its namespace.
A namespace lets you group a set of schemas by area of interest. For example, the cus namespace is used for customer-specific configuration (customers).
As a standard, the name of the namespace must be concise and must contain only authorized characters in accordance with XML naming rules.
Identifiers must not begin with numeric characters.
Certain namespaces are reserved for descriptions of the system entities required for the operation of the Adobe Campaign application:
The identification key of a schema is a string built using the namespace and the name separated by a colon; for example: cus:recipient.