UserPhone


Description

User phone number management storing multiple phone numbers and contact information for healthcare staff. This table manages various phone numbers for users including work, mobile, home, and emergency contacts, supporting comprehensive contact management and communication workflows for healthcare staff coordination and emergency notifications.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
userPhoneID int identity 4 √ null

Primary key - Unique identifier for each user phone record
userid int 4 √ null
AccessUser.UserID FK__UserPhone__useri__6DAD1CC9 C

User reference - Links to the user account (AccessUser.UserID)
number varchar 20 √ null

Phone number - Phone number in standard format
ext int 4 √ null

Extension - Phone extension number if applicable
phoneType int 4 √ null

Phone type - Type of phone (Work, Mobile, Home, Emergency, etc.)
Comments varchar 100 √ null

Phone comments - Additional comments or notes about this phone number
callOrder int 4 √ null

Call order priority - Priority order for calling this phone number (1=primary, 2=secondary, etc.)

Indexes

Constraint Name Type Sort Column(s)
PK__UserPhone__6CB8F890 Primary key Asc userPhoneID
IX_UserId Performance Asc userid

Relationships

Close relationships within degrees of separation