Rooms


Description

Room and facility management storing information about service delivery locations, therapy rooms, and facility spaces used for healthcare services. This table manages room details including titles, addresses, and location information to support facility management, scheduling coordination, and service delivery location tracking for healthcare and early intervention services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
roomID int identity 4 √ null
AuthorizeRooms.RoomID FK__Authorize__RoomI__638EB5B2 C
RoomsTherapist.RoomID FK__RoomsTher__RoomI__6576FE24 C

Primary key - Unique identifier for each room or service location
title varchar 35 √ null

Room title - Descriptive name or title of the room (e.g., ‘Therapy Room A’, ‘Conference Room’)
address1 varchar 50 √ null

Address line 1 - Primary street address of the room location
address2 varchar 50 √ null

Address line 2 - Secondary address information (suite, unit, etc.)
city varchar 50 √ null

City - City where the room is located
state varchar 50 √ null

State - State or province where the room is located
zip varchar 10 √ null

ZIP code - Postal code for the room location

Indexes

Constraint Name Type Sort Column(s)
PK__Rooms__60B24907 Primary key Asc roomID

Relationships

Close relationships within degrees of separation