Business Data Model Data Model

Entity

Entity Appointment Resource Annotation

Description

A note that is linked to an appointment resource. This type of note may include information on the scheduling and use of the resource.

Relationship
Appointment Resource Annotation_Appointment Resource_FK

Dependencies
NONE

Reverse Dependencies

Description	The textual notes or instructions associated with an appointment.
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Description	Identifies the type of appointment annotation.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Description	Identifies the source of a comment. For example: Ancillary (filler) department Orderer (placer) Other system (L, O, P)
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

Description	Indicates the relative order or importance of this row in the set of annotations.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Is Identifying Relationship	true
Child Table	Appointment Resource Annotation
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	Appointment Resource
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Entity

Business Data Model Data Model