Entity Product Specification Entry

DescriptionDetails describing a product that is used in conjunction with a point of care device.

Attributes
Component IDComponent ID
Product SpecificationProduct Specification
Product Specification SeqProduct Specification Seq
Specification TypeSpecification Type

Relationship
Product Specification Entry_Point Of Care Device_FKProduct Specification Entry_Point Of Care Device_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Component ID
DescriptionA component identifier such as a manufacturer's ID.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Product Specification
DescriptionThe text describing a product specification.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Very Large [VARCHAR(2048)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Product Specification Seq
DescriptionThe relative order or importance of this row in the list of product specifications.
Data TypeStandards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Specification Type
DescriptionIdentifies the type of specification being recorded.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Product Specification Entry_Point Of Care Device_FK
Is Identifying Relationshipfalse
Child TableProduct Specification Entry
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePoint Of Care Device
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE