Chapter 7 Working With Database Concepts : Database Concepts Extended Properties

Database Concepts Extended Properties
Database concepts have additional properties related to their database source. Individual concept properties also have extended properties. The extended properties for a concept are available on the Extended Properties tab in TIBCO Designer. The extended properties for a property are available using a pop-up window accessed from the Properties tab for the concept.
Do not modify any extended properties, except to manually keep the extended property definitions synchronized with their database source. For example, if the DBA changes the name of a column in a database, change the value of the COLUMN_NAME extended property to match. You don’t have to re-import the concept.
Extended Properties for a Concept
The following table describes the extended properties for a database concept.
Table 11 Database Concept —Extended Properties
PRIMARY_ KEY_PROPS
A comma separated list of names of primary key properties. Note that these should be set to the property names rather than column names.
Extended Properties for a Concept Property
A database concept property also has extended properties. These properties are of two types, primitive properties and concept relationship properties. To view the extended properties for a concept property, follow the steps provided in the section, To View the Extended Properties of a Database Concept Property.
The following tables describe the two types of extended properties.
Table 12 Database Concept Property—Extended Properties of Type Primitive
 
Table 13 Database Concept Property—Extended Properties of Type Concept Relationship
 
To View the Extended Properties of a Database Concept Property
1.
In the Properties tab, right-click in the row of the property whose extended properties you want to display. You see the Extended Properties button:
2.
Click the Extended Properties button. You see the Extended Properties dialog, showing the property’s extended properties. The example shows extended properties for a ConceptReference property:
 
As explained in the introduction, only make modifications to keep the properties synchronized with their database equivalents. Do not make any other changes.