Table: Staff_Locator_Status
Tags: read-only

Content:
1In the office
2Out of the office
3At Lunch
4Went Home
5At Clients
6In Meeting
7At Other Office
8On Vacation
9Sick Day
Columns
NameTypeConstraintsDescription
staff_locator_status_KEYintNOT NULLPrimary key for this table
descriptionnvarchar (30)NOT NULLUser defined description (unique).
Primary key
NameColumnsDescription
PK_Staff_Locator_Status$staff_locator_status_KEYstaff_locator_status_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Locator_Status__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Staff_Locator__Staff_Locator_Status__staff_locator_status_KEYstaff_locator_status_KEYStaff_Locator

Schema diagram