Entity Appointment Annotation

DescriptionA note that relates to an appointment.

For example:
Nursing preparation note
Billing note
Scheduled resource note

Attributes
Annotation TxtAnnotation Txt
Annotation TypeAnnotation Type
Comment SourceComment Source
Priority SeqPriority Seq

Relationship
Appointment Annotation_Appointment_FKAppointment Annotation_Appointment_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Annotation Txt
DescriptionIndicates the notes or instructions of the appointment.
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 appointment annotation.

Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Comment Source
DescriptionIdentifies the source of comment.

For example:
Ancillary (filler) department
Orderer (placer)
Other system (L, O, P)
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Priority Seq
DescriptionIndicates the relative 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

 Appointment Annotation_Appointment_FK
Is Identifying Relationshiptrue
Child TableAppointment Annotation
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAppointment
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE