Database Properties for Category shape (Definition)

Use these options to define a category's discriminator attribute on a parent table. Using a category establishes a foreign key relationship from the parent table to the child tables connected to the Category shape.

Category tables are subtypes of a parent table. For example, an employee's record (the generic parent) might contain a job-type column (the category discriminator); category entities in this example might include engineer, technician, and administrator.

If a category table contains all possible subtypes, it is considered complete; if it contains only some possible subtypes, it is considered incomplete.

None

Select to set an available attribute as the category discriminator. By default, when a category is created, it does not have an attribute assigned to it as the category discriminator.

This attribute

By default, an attribute is not selected as the category discriminator. You must select an attribute, or the model will fail to validate when you build it.

Category is complete

Select this check box to indicate that the category (a subtype of its parent) is considered one of a finite set of children, all of which are represented in this model.

If you know that some branch of the parent leads to a child that you are not including in this model, clear this check box.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×