Table: dbo.Staff_Locator
Columns
NameTypeConstraintsDescription
staff_locator_KEYint (4)NOT NULLDatabase assigned primary key for this table
staff_KEYint (4)NOT NULLKey to a Staff record
staff_locator_status_KEYint (4)Key to a Staff Locator Status row
returningsmalldatetime (4)Date and time the staff will return.
commentsnvarchar (-1)Any comments entered by the user.
Primary key
NameColumnsDescription
PK_Staff_Locatorstaff_locator_KEY
Unique constraints
NameColumnsDescription
UK_Staff_Locator$staff_KEYstaff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Locator__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
FK_Staff_Locator__Staff_Locator_Status__staff_locator_status_KEYstaff_locator_status_KEYStaff_Locator_Status (staff_locator_status_KEY)

Schema diagram