Entity Preference Selection Criteria

DescriptionA selection of preferred time slots and resources that should be referred to when scheduling appointments.

Attributes
Appointment Selection CriteriaAppointment Selection Criteria
DescrDescr

Relationship
Appointment Selection Criteria_Preference_FKAppointment Selection Criteria_Preference_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Appointment Selection Criteria
DescriptionIndicates the preferred start time, a preferred end time, and preferred days of the week, location and resource for the appointment.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Descr
DescriptionThe description of an appropriate time slot for an appointment, or appropriate resource for an appointment, or appropriate location for the appointment or override parameters for the appointment.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Appointment Selection Criteria_Preference_FK
Is Identifying Relationshipfalse
Child TablePreference Selection Criteria
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePreference
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE