Entity Order Annotation

DescriptionA note that is associated with an order.

For example:
Special instruction notes
Reason for order notes

Attributes
Annotation TxtAnnotation Txt
Annotation TypeAnnotation Type
Priority SeqPriority Seq

Relationship
Order Annotation_Order_FKOrder Annotation_Order_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Annotation Txt
DescriptionThe descriptive free text notes associated with the order.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Annotation Type
DescriptionIdentifies the type of the Annotation associated with the order.

For example:
Medication Indication
Patient Condition
Clinical Note
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Priority Seq
DescriptionIndicates the order or importance of this row in the set of annotations.
Data TypeStandards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Order Annotation_Order_FK
Is Identifying Relationshiptrue
Child TableOrder Annotation
Child Role Namenotes
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrder
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE