dbschema

Groups	Type	Length	Precision	Key	Nulls	Description
GroupID	int	4	10	PK	No	Primary Key. System-generated identifier assigned when a user creates a family.
GroupTypeID	int	4	10	--	Yes	Foreign Key. System-generated identifier assigned when a user creates a group type. For example, if "Boat" is a family (or group) then brand name could be a group type.
Name	nvarchar	50	0	--	No	Name of the product family. For example, "Land Vehicles," or "Motorcycles," or "Bicycles."
Description	nvarchar	255	0	--	Yes	Description of the product family. This is optional.
AppID	nvarvhar	50	0	--	No	Refers to an Associated ID, which represents a group of users, partners, or communities that a user selects in the Product Catalog management user interface. As a security measure, Product Catalog allows administrators to restrict access to certain products. This is accomplished by selecting a set of users and granting product access only to that group. For example, if your extranet includes partners who compete with each other in the marketplace, you will want to protect those competing product families.
ParentID	int	4	10	--	Yes	System-generated identifier that indicates whether the product family specified by the GroupID is a sub-family of another product family in the database. By pointing to a different GroupID, this is used to connect families and sub-families. For example, if you have a main family of "Watercraft," you may have one or more sub-families, i.e, "Jet Skis," and/or "Fishing Boats" If this value is null, it means the specified family is not itself a sub-family.
Meta	ntext	16	0	--	Yes	Free-form text field that can be used for any type of data, including family images and XML documents. For example, you could use this column to reference an XML document that controls certain features of the display.
RestrictedUID	nchar	39	0	--	Yes	Refers to an Associated ID, which represents a group of users, partners, or communities selected using the Product Catalog management user interface.

GroupPropertyValues	Type	Length	Precision	Key	Nulls	Description
PropertyValuesID	int	4	10	PK	No	Primary Key. System-generated identifier assigned when a user sets the value for a property.
PropertyID	int	4	10	FK	No	Foreign Key that points to the DMGroupProperty table. System-generated identifier assigned when a user creates or edits a property. Used by DMGroupPropertyValues table to identify the property to which a value is being assigned.
GroupID	int	4	10	FK	No	Foreign Key that points to the DMGroups table. System-generated identifier that is assigned when a user creates a family in the database. Used by DMGroupPropertyValues table to identify the group to which the property applies.
CharValue	nvarchar	100	0	--	Yes	Holds the value for properties of datatype "CharValue." Maximum size is 4000 characters.
NumValue	numeric	9	18	--	Yes	Holds the value for properties of datatype "NumValue." This column must contain calculable entries only. Maximum size is ± 1 18. If necessary, this can be increased.
TextValue	ntext	16	0	--	Yes

GroupDocument	Type	Length	Precision	Key	Nulls	Description
GroupID	int	4	10	FK	No	Foreign Key that points to the DMGroups table. System-generated identifier created when a user creates a family. Used by DMGroupDucument table to identify the family to which the product is being related.
DocumentID	int	4	10	FK	No	Foreign Key that points to the DMDocument table. System-generated identifier created when a user adds a product to the database. Used by DMGroupsDocument table to identify the product being related to a family.

GroupProperty	Type	Length	Precision	Key	Nulls	Description
PropertyID	int	4	10	PK	No	Primary Key. System-generated identifier assigned when a user creates or edits a property.
Name	nvarcha	50	0	--	No	Short name of a product property, i.e., color, size, wheel base. Products can share properties. For example, a sweatshirt in the product family would likely be assigned the properties "color" and "size," while a car would be assigned the properties of "color" and `wheelbase." The property "color" would be the same for both products
ValidationRule	nvarchar	512	0	--	Yes	This column is reserved for Commerce Co, Inc. Professional Services. ValidationRule allows for customization of this table at time of installation. For examples, a project team could make a property "read-only" or "required." That information would be stored in this column.
Description	nvarchar	100	0	--	Yes	Detailed description of the property. This is optional.
Type	nvarchar	50	0	--	Yes	Describes the datatype used for the Value in the DMGroupPropertyValue table. There are only two valid values in this column: · CharNum - The value will be a literal string. · NumValue - The value will be numeric. · TextValue - ??? These values are case-sensitive and must be entered exactly as shown above. This column does not support nulls.??
AppID	nvarchar	50	0	--	No	Product Catalog can be installed multiple times on a single extranet, as long as each installation (or "instance") has a unique name. The AppID parameter in these database tables identifies a particular installation of Product Catalog. AppID has a one-to-one relationship with "application name" and "application instance" as those terms are used in the Commerce Co, Inc. manuals. This column appears in all tables that are required to connect to a product family to fulfill a request.
Active	nchar	1	0	--	No	Boolean True/False switch. If set to True, the property is active for products in the on-line families. If set to False, the property remains in the database but is not accessible through the on-line families. Enter "1" for true, "0" for false.
meta	ntext	16	0	--	Yes	Free-form text field that can be used for any type of data, including images and XML documents. For example, you could use this column to reference an XML document that controls certain features of the display.

GroupFilter	Type	Length	Precision	Key	Nulls	Description
Name	nvarchar	50	0	--	Yes	Name of filter, for example "dual-engine."
GroupID	int	4	10	FK	No	Foreign Key that points to the DMGroups table. System-generated identifier assigned when a user creates a family. Used by DMGoupFilter table to determine the family being filtered.
PropertyId	int	4	10	FK	No	Foreign Key that points to the DMProperty table. System-generated identifier assigned when a user creates or edits a property. Used by the DMFilter table to identify the property used to filter the family.
Priority	int	4	10	--	No	Governs the order in which the group filter properties display in the interface.
AppID	nvarchar	50	0	--	No	Product Catalog can be installed multiple times on a single extranet, as long as each installation (or "instance") has a unique name. The AppID parameter in these database tables identifies a particular installation of Product Catalog. AppID has a one-to-one relationship with "application name" and "application instance" as those terms are used in the Commerce Co, Inc. manuals. This column appears in all tables that are required to connect to a product family to fulfill a request.

DocumentType	Type	Size	Precision	Key	Nulls	Description
DocumentTypeID	int	4	10	PK	No	Primary Key. System-generated identifier assigned when a user creates a product type.
DocumentTypeName	nvarchar	50	0	--	No	Actual name of the product type, i.e., hat, car, motorcycle, etc.
PropertyID	int	4	10	FK	No	Foreign Key that points to the DMProperty table. System-generated identifier assigned by the Product Catalog management user interface when a user creates or edits a property. Used by DMDocumentType table to identify the property associated with the product.
AppID	nvarchar	50	0	--	No	Product Catalog can be installed multiple times on a single extranet, as long as each installation (or "instance") has a unique name. The AppID parameter in these database tables identifies a particular installation of Product Catalog. AppID has a one-to-one relationship with "application name" and "application instance" as those terms are used in the Commerce Co, Inc. manuals. This column appears in all tables that are required to connect to a product family to fulfill a request.
Priority	int	4	10	--	Yes	The order in which the product types display in the interface.
RetrieveLevel	int	4	10	--	Yes	Specifies the logical levels of information to be retrieved, based on importance. For example, retrieve levels could be defined as follows: -1 returns all properties 0 returns header properties >0 returns some or all user-defined properties
Meta	text	16	0	--	Yes	Free-form text field that can be used for any type of data, including images and XML documents. For example, you could use this column to reference an XML document that controls certain features of the display.

Document	Type	Size	Precision	Key	Null	Description
DocumentID	int	4	10	PK	No	Primary key. System-generated identifier assigned when a user adds a product to the database.
DocumentTypeID	int	4	10	FK	No	System-generated identifier assigned when a user creates a product type.
Description	nvarchar	1024	0	--	Yes	Description of the product. This is optional.
DocumentNum	varchar	50	0	--	Yes	Client-driven product number. This is typically a product's item number in a product database.
RestrictedUID	nchar	39	0	--	Yes	Refers to an Associated ID, which represents a group of users, partners, or communities that a user selects in the Product Catalog management user interface. As a security measure, Product Catalog allows administrators to restrict access to certain products. This is accomplished by selecting a set of users and granting product access only to that group. For example, if your extranet includes partners who compete with each other in the marketplace, you will want to protect those competing product families.
Active	nchar	1	0	--	No	Boolean True/False switch. If set to True, the product is active in the on-line families. If set to False, the item remains in the database but is not accessible through the on-line families
AppID	varchar	50	0	--	No	Product Catalog can be installed multiple times on a single extranet, as long as each installation (or "instance") has a unique name. The AppID parameter in these database tables identifies a particular installation of Product Catalog. AppID has a one-to-one relationship with "application name" and "application instance" as those terms are used in the Commerce Co, Inc. manuals. This column appears in all tables that are required to connect to a product family to fulfill a request.
Name	nvarchar	50	0	--	No	Short name of a product. For example, SurfMaster Jet Ski. Limited to 50 characters or less.
meta	ntext	16	0	--	Yes	Free-form text field that can be used for any type of data, including images and XML documents. For example, you could use this column to reference an XML document that controls certain features of the display.
Owner	nvarchar	50	0	--	Yes	Name of the user who added the product to the database.