Catalog Data Model

Catalog Data Model
The catalog data model shows the relationship between database tables that contain information about a catalog.
Important Tables:

Store
Storeent
Storecat
Catentry
Catalog
Catalogdsc
Catgrprel
Cattogrp
Catgroup 
Catgpenrel
Catgpenrel
Catenttype
Catentdesc
Catreltype 
Catentattr

STORE table’s information:
store_id (Primary Key) – Generated unique key.
storegrp_id – The store group for this store.
status – Status of the store 1- open, 0 – close, -1 – suspended.

STOREENT table’s information:
storeent_id (Primary Key), Member_id.

STORECAT table’s information:
Catalog_id, Storeent_id, Mastercatalog.
CATALOG_ID + STOREENT_ID (Primary Key).

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

CATALOG table’s information:
Catalog_id (Primary Key), Member_id.

CATALOGDSC table’s information:
Catalog_id, Name, Shortdescription, Longdescription, Thumbnail, Fullimage.
LANGUAGE_ID+CATALOG_ID (Primary Key).

CATTOGRP table’s information:
Catalog_id, Catgroup_id.
CATALOG_ID+CATGROUP_ID (Primary Key).

CATGROUP table’s information:
Catgroup_id (Primary Key), Member_id.

CATGRPREL table’s information:
Catgroup_id_parent, Catgroup_id_child, Catalog_id.
CATGROUP_ID_CHILD+CATGROUP_ID_PARENT+CATALOG_ID (Primary Key).

CATGPENREL table’s information:
Catgroup_id, Catalog_id, Catentry_id.
CATGROUP_ID+CATENTRY_ID+CATALOG_ID (Primary Key).

CATENTTYPE table’s information:
Catenttype_id (Primary Key), Description.

CATENTDESC table’s information:
Catentry_id, Name, Shortdescription, Longdescription, Thumbnail, Fullimage.
CATENTRY_ID+LANGUAGE_ID (Primary Key).

CATRELTYPE table’s information:
Catreltype_id (Primary Key), Description.

CATENTATTR table’s information:
Catentattr_id (Primary Key), Catentry_id, Name, Value, Description.

Leave a Reply