AuthorizeRooms


Description

Authorization room assignments linking service authorizations to specific rooms where services will be delivered. This table manages room reservations and assignments for authorized services, supporting facility management, scheduling coordination, and resource allocation for healthcare service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
AuthID int 4 √ null
Authorize.AuthID FK__Authorize__AuthI__629A9179 C

Authorization reference - Links to Authorize table for the service authorization
RoomID int 4 √ null
Rooms.roomID FK__Authorize__RoomI__638EB5B2 C

Room reference - Links to Rooms table for the assigned service room

Indexes

Constraint Name Type Sort Column(s)
IX_AuthID Performance Asc AuthID

Relationships

Close relationships within degrees of separation