Product Families tree nodes

The Schema Manager has two trees that show information about product families: and . Use the tree to add and edit personalized tables for your agency. Use the tree to view information about existing Infor tables. The trees have the same structure. This table describes each node in these trees:


Node	Description
Enhancement Product Families (root node)	Contains nodes for the personalized product families that your agency has defined.
Infor Product Families (root node)	Contains nodes for the built-in product families that Infor Public Sector uses.
	"Product Family" Node for a product family that your agency has purchased or defined, such as CDR or Inventory. When you click the node, the product family name and owner are displayed on the right. The node shows the name of the product family. It may contain one or more of each of the following nodes: "Product" and "Table Definition."
	"Product" Node for a product that your agency has purchased or defined, such as Building Permits or Inventory. This node shows the name of the product. It may contain one or more "Table Definition" nodes.
	"Table Definition" Node for a table definition for a product family or product. A table definition is not the table itself but the data that defines the table, including the table name, its columns, and other items, such as constraints and indexes. When you click the node, information about the table definition is displayed on the right. This node shows the common ID of a business object followed by the name of its table in the database. It contains these five nodes: Check Constraints, Columns, Constraints, Indices, and Referencing Tables.
Columns	Node for the columns for a table definition, including domains. When you click the node, a grid is displayed on the right listing the table's columns.
Constraints	Node for the foreign, primary, and unique key constraints for a table definition. Constraints are rules that check a column to ensure that the data the column contains is valid. When you click the node, a grid is displayed on the right listing the table's constraints.
Check Constraints	Node for the check constraints for a table definition. Table check constraints define which data values are acceptable for multiple columns in a table, such as requiring that only one column of a set of three columns has data. When you click the node, a grid is displayed on the right listing the check constraints.
Indices	Node for the indexes for a table definition. Indexes speed up searching and sorting. When you click the node, a grid is displayed on the right listing the table's indexes.
Referencing Tables	Node for the tables that reference the current table definition. A referencing table is a table containing a foreign key that references the primary key in the current table. When you click the node, a grid is displayed on the right listing all the tables that reference the table definition.
Filters	Node for the data filters for a table definition. You can use data filters to distill information to specific users, such as a filter that allows only employees in a transportation department to have access to roadway assets. When you click the node, a grid is displayed on the right listing the table's filters.
Domains	Node for the domains in your Infor Public Sector application. Domains are predefined columns that you can use in personalized tables. When you click the node, a grid is displayed on the right listing all the domains in Infor Public Sector.
Enumerations	Node for the enumerations in your Infor Public Sector application. An enumeration is a human-recognizable value that you can use in your formulas, such as the term varchar to represent a value of V for a variable character SQL type. When you click the node, the Enumerations Collections tree is displayed on the right.