Entity Room Equipment

DescriptionA piece of medical equipment or bedside device that is available for use within a room location.

For example:
Suction machine
Echocardiogram

Attributes
Room EquipmentRoom Equipment

Relationship
Room Medical Equipment_Room_FKRoom Medical Equipment_Room_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Room Equipment
DescriptionIndicates the type of medical equipment or bedside device available for use within a room location. It is available for use with multiple bed locations within the room.

For example:
Electro-encephalogram
Electro-cardiogram
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Room Medical Equipment_Room_FK
Is Identifying Relationshiptrue
Child TableRoom Equipment
Child Role Nameis used to equip
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableRoom
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE