Contract data model -- Long Description (Enterprise)

The diagram shows the relationship between the tables in the Contract data model.

A table may be one of three types:

1. 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.
2. 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.
3. 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.

TRDTYPEDSC dependent

TRDDESC dependent

TRDTYPE independent

PRODUCTSET independent

MEMBER independent

ATTACHUSG independent

TRADING independent

TCSUBTYPDS dependent

LANGUAGE independent

PLCYTYPDSC dependent

POLICYTYPE independent

PARTROLEDS dependent

PARTROLE independent

PLCYTYCMIF independent

TRADEPOSCN independent

TDPSCNCNTR dependent

TRDATTACH dependent

ATTACHMENT independent

TCSUBTYPE independent

TCDESC dependent

POLICYDESC dependent

POLICYTC dependent

TCTYPE independent

CNTRNAME

BUYSUPMAP dependent

CNTRDISPLY independent

CONTRACT independent

ACCOUNT independent

DEVICEFMT independent

STORECNTR dependent

CATCNTR dependent

STORE independent

STOREGRP independent

STOREENT independent

TERMCOND independent

POLICY independent

PARTICIPNT independent

POLICYCMD dependent

STORECGRY independent

(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.