Entity Code Group

DescriptionA formal or ad hoc group that contains a collection of codes.

For example:
Orthopedic diagnosis codes
Cardiothoracic procedure codes

Attributes
Common CodeCommon Code

Relationship
Code Group_Common Code_FKCode Group_Common Code_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Common Code
DescriptionIndicates the code being grouped.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Code Group_Common Code_FK
Is Identifying Relationshipfalse
Child TableCode Group
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCommon Code
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypeGroup
SubtypeCode Group
Transform AsTABLE