Table: Staff_Locator_Status
Tags: read-only Content:
1 | In the office
2 | Out of the office
3 | At Lunch
4 | Went Home
5 | At Clients
6 | In Meeting
7 | At Other Office
8 | On Vacation
9 | Sick Day
Columns
Name | Type | Constraints | Description
staff_locator_status_KEY | int | NOT NULL | Primary key for this table
description | nvarchar (30) | NOT NULL | User defined description (unique).

Primary key
Name | Columns | Description
PK_Staff_Locator_Status$staff_locator_status_KEY | staff_locator_status_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Locator_Status__description | description | Each description must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Staff_Locator__Staff_Locator_Status__staff_locator_status_KEY | staff_locator_status_KEY | Staff_Locator |