Entity Supplemental Service Information

DescriptionThe information that describes the supplemental service included in an appointment or the supplemental information associated with an appointment.

Attributes
Supplemental Service InformationSupplemental Service Information
Supplemental Service Information TypeSupplemental Service Information Type

Relationship
Filler Supplemental Service Information_Appointment Service _FKFiller Supplemental Service Information_Appointment Service _FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Supplemental Service Information
DescriptionSupplemental service information, logistical information, or both, about the appointment.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Supplemental Service Information Type
DescriptionIndicates whether it is filler or placer supplemental information.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Filler Supplemental Service Information_Appointment Service _FK
Is Identifying Relationshipfalse
Child TableSupplemental Service Information
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableSchedule Service
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE