Entity Agreement Identifier

DescriptionA list of identifiers related to an agreement. The nature of each identifier is also recorded.
For example:
Contract Id
Purchaser Contract Id

Attributes
Agreement IdAgreement Id
Agreement Identifier TypeAgreement Identifier Type

Relationship
Agreement Identifier_Agreement_FKAgreement Identifier_Agreement_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Agreement Id
DescriptionIdentifies an instance of an Agreement
Data TypeStandards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Agreement Identifier Type
DescriptionDescribes the kind or nature of the Agreement Identifier.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Agreement Identifier_Agreement_FK
Is Identifying Relationshiptrue
Child TableAgreement Identifier
Child Role Nameidentifies
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAgreement
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE