Attribute Data Model In detailed

Attribute Data Model
The attribute data model shows the relationship between database tables that contain information about product attributes. Attributes can be one of the several types, identified by the ATTRTYPE column.

Catentry
Attrvalue
Attrtype
Attribute

catentry_id (Primary Key), Member_id, itemspc_id, catenttype_id, Partnumber, Mfpartnumber, Mfname.CATENTRY table’s information:

ATTRVALUE table’s information:

Attrvalue_id, Attribute_id, Attrtype_id, catentry_id.

ATTRVALUE_ID+LANGUAGE_ID (Primary Key).

ATTRIBUTE table’s information:

Attribute_id, Attrtype_id, Name, Description.

ATTRIBUTE_ID+LANGUAGE_ID (Primary Key).

ATTRTYPE table’s information:

Attribute_id (Primary Key), Description.

Leave a Reply