ClassCode Modified TxtLot Number TxtProduct Expiration DateProduct TypeStability Duration Qty
| Business Data Model Data Model |
| Description | A material item that is produced and offered on a market. For example: Blood derivative products Dietary supplements Medication |
| Attributes | |
| Class |
|
| Code Modified Txt |
|
| Lot Number Txt |
|
| Product Expiration Date |
|
| Product Type |
|
| Stability Duration Qty |
|
| Relationship | |
 performingProduct |
|
| involvedProduct |
|
| Generalization | |
 Generalization1 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Class
| Description | Identifies a group of products that are homogeneous or generally considered as substitutes for each other. The class is considered as narrow or broad depending on how substitutable the various products are. For example: Stents Breakfast cereals Cox-2 inhibitors |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Code Modified Txt
| Description | A character string that is a revision of the original text of the product to enable the coding of the text. For example: If the original text is "aspriin", the CodeModifiedText could be set to "aspirin", so that the text can be successfully coded. In the context of BRIDG, text modification occurs a single time for a given instance of originalText. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Lot Number Txt
| Description | An alphanumeric string used to identify a particular batch of the product. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Product Expiration Date
| Description | The date assigned by the manufacturer on which the product should not be used. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Product Type
| Description | Indicates the kind of product. All members of a type share similar functions and general characteristics, especially the purpose for which they are used. For example: Veterinary medicine Diagnostic device |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Stability Duration Qty
| Description | The period of time during which the drug or other product or substance is considered usable after it is activated (opened). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
performingProduct
| Description | DESCRIPTION: Each Experimental Unit might be a function performed by one Product. Each Product might function as one or more Experimental Unit. |
| Is Identifying Relationship | false |
| Child Table | Product |
| Child Role Name | performedExperimentalUnit |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | SET_NULL |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | SET_NULL |
| Parent Table | Experimental Unit |
| Parent Role Name | performingProduct |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | SET_NULL |
| Parent Referential Integrity: On Update | SET_NULL |
involvedProduct
| Description | DESCRIPTION: Each Performed Product Problem Discovery always focuses on one Product. Each Product might be the focus of one or more Performed Product Problem Discovery. |
| Is Identifying Relationship | false |
| Child Table | Product |
| Child Role Name | involvingPerformedProductProblemDiscovery |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | SET_NULL |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | SET_NULL |
| Parent Table | Performed Product Problem Discovery |
| Parent Role Name | involvedProduct |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | SET_NULL |
| Parent Referential Integrity: On Update | SET_NULL |
| Generalization Details |
Generalization1
| Supertype | Material |
| Subtype | Product |
| Transform As | TABLE |
| Business Data Model Data Model |