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.


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.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.