Business Data Model Data Model

Entity

Entity Diet Tray Instructions

Description

An instruction that is used to provide diet-specific information for the ordered dietary service.

For example:
Patient is allergic to shellfish
No fruit juices please

Attributes
Service Period Code
Text Instruction
Tray Type

Relationship
Diet Tray Instructions_Dietary Order_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Service Period Code

Description	Indicates the feeding period the order or modifications belongs to. Modifications might include dietary supplements. For example: service 1 is breakfast service 2 is mid-a.m. snack service 3 is lunch service 4 is mid-afternoon snack service 5 is dinner service 6 is bedtime snack
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

Text Instruction

Description	The descriptive free text notes associated with the dietary tray. For example: Plastic Cutlery
Data Type	Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tray Type

Description	Indicates the type of dietary tray for the patient. For example: Early Tray Late Tray Guest Tray No Tray
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

Relationship Details

Diet Tray Instructions_Dietary Order_FK

Is Identifying Relationship	true
Child Table	Diet Tray Instructions
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	Dietary Order
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model