Data Model

Learn about the data model used by the Aurea.CRM database.

Click on Data Model in the icon bar to browse the data model used by the Aurea.CRM database. The data model consists of info areas, fields and catalogs.

When developing a base package on station 10,000, only those items are displayed that are common to all verticals, see Base Packages .

Note: If the data model is edited while CRM.cockpit is open, click on Refresh Data Model to refresh the data model in CRM.cockpit.

The info areas present in the data model are listed on the left and are sorted by info area number. The info area code (ID), info area name and the number of fields present in the info area are displayed. Click on a column header to sort the entries.

Click on the name of an info area in the list to display the fields in the info area and the info area relationships. Alternatively, enter the info area code in the Go to table field.

The number, name, length, type, and attributes of the fields in the selected info area are displayed, as well as the part of the data model the field is present in. The fixed field and info area names are displayed in parentheses in gray.

The following entries are possible in the Core column:

  • Core: Indicates that the field is part of the hard-coded core data model. These fields have a field ID < 4000.
  • VirtualCore: Indicates that the field is part of the hard-coded core data model. However, the field is a virtual field; i.e. the field does not correspond to a column in a database table, but the value in the field is taken from a special field or fields which encode this information. These fields have a field ID of 4200 - 4299.
  • UniqueCore: Indicates that the field is part of the hard-coded core data model and has a unique field ID > 3999 (e.g. Tenant, Currency).
  • GenericCore: Indicates that the field has been defined on a base station, see Base Packages .
  • GenericUpdate: Indicates that the field has been defined as part of the custom data model by update on a station with a station number >10,000.
  • GenericPartner: Indicates that the field has been defined as part of the custom data model on a partner station.
  • GenericCustomer: Indicates that the field has been defined as part of the custom data model by a customer.
  • WebCustomField: Indicates that the field is a custom field defined in CustomFields.xml.

Click on <Show legend> to display the legend. Different icons are used to indicate different field types.

The child and parent info areas of the selected info area are displayed above the list of fields. Click on one of the listed info areas to switch the display to that info area. Move the mouse cursor over an abbreviation to display information on the link between the info areas.

  • Click on the number of a field to display the info areas that contain a field with the same name. Note that fields with the same name do not necessarily have the same functionality in different info areas. Select one of the info areas from the list to switch the display to that info area.
  • Click on a catalog ID to display all other info areas that access the same catalog.