RoomsTherapist


Description

Room therapist assignments linking healthcare providers to specific rooms for service delivery and scheduling coordination. This junction table manages the assignment of therapists and providers to specific rooms, supporting facility scheduling, resource allocation, and provider-room associations for healthcare service delivery and therapy session management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
RoomID int 4 √ null
Rooms.roomID FK__RoomsTher__RoomI__6576FE24 C

Room reference - Links to Rooms table for the assigned service room
userID int 4 √ null
AccessUser.UserID FK__RoomsTher__userI__666B225D C

User reference - Links to AccessUser table for the therapist or provider assigned to the room

Relationships

Close relationships within degrees of separation