Product Advisor data model -- long description
The diagram shows the relationship between the tables in the Product Advisor data model.
A table may be one of three types:
- An independent entity. Instances of an independent entity can be uniquely identified without determining its relationship to other entities. The primary key to an instance of an independent entity does not contain any foreign keys.
- A strong dependent entity. Instances of a strong dependent entity cannot be uniquely identified without determining its relationship to other entities. The primary key to an instance of a strong dependent entity contains foreign keys, but does not consist entirely of foreign keys.
- A weak dependent entity. Instances of a weak dependent entity cannot be uniquely identified without determining its relationship to other entities. The primary key to an instance of a weak dependent entity consists entirely of foreign keys.
Each table in the model is related to the other tables. The references from the main table to the other tables in the model are described in the following list.
CATENTRY independent
ICDEWIDREG independent
ICCNCPTLNK independent
ICMETAPHOR independent
ICMETAPROP dependent
ICFEATPROP dependent
ICMETAFEAT dependent
ICROOTCAT independent
ICDATAREG independent
ICMERTREE independent
CATGROUP independent
ICMERDESC dependent
ICDEWIDREG independent
SETCURR independent
ICTPRICES
ICKNOWLEDG independent
ICEXPLFEAT independent
ICCONSTRNT independent
ICEXPLDESC dependent
ICMETAREG independent
ICCONSTVAL dependent
LANGUAGE independent
CATENTRY independent
ICKNOWDESC dependent
ICMREGDESC dependent