| Business Data Model Data Model |
Description | A grouping of codes that associates codes to a specific version number. It also is used to identify the dates on which the code types were entered and became available for use, as well as when they are no longer available for current use. It references the publisher or "system of record" that defines the type of codes being named (for example, "diagnostic codes" may be published by the "World Health Organization"). |
Attributes | |
![]() |
|
![]() |
Relationship | |
![]() |
|
![]() |
|
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | The designation of a unique set of codes. |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The description or explanation of a code domain. This is to more fully describe the "Code Type" which may be an abbreviation or acronym. |
Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
Is Part Of PrimaryKey | false |
Is Required | true |
Is Derived | false |
Is Surrogate Key | false |
Relationship Details |
Is Identifying Relationship | false |
Child Table | Coding System Version |
Child Role Name | has domain |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Code Domain |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | false |
Child Table | Coding System Version |
Child Role Name | is created by |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Terminology Author |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | false |
Child Table | Coding System Version |
Child Role Name | has publisher |
Child Multiplicity | ZERO_TO_MANY |
Child Referential Integrity: On Delete | NONE |
Child Referential Integrity: On Insert | NONE |
Child Referential Integrity: On Update | NONE |
Parent Table | Standard Publisher |
Parent Multiplicity | ZERO_TO_ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |