Table: Staff_Locator
Columns
Name | Type | Constraints | Description
staff_locator_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
staff_KEY | int | NOT NULL | Key to a Staff record
staff_locator_status_KEY | int |  | Key to a Staff Locator Status row
returning | smalldatetime |  | Date and time the staff will return.
comments | nvarchar (-1) | NOT NULL | Any comments entered by the user.
create_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Staff_Locator$staff_locator_KEY | staff_locator_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Staff_Locator__staff_KEY | staff_KEY |
Indexes
Name | Columns | Description
IX_Staff_Locator$staff_locator_status_KEY | staff_locator_status_KEY | Index supports foreign key FK_Staff_Locator__Staff_Locator_Status__staff_locator_status_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Staff_Locator__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;
FK_Staff_Locator__Staff_Locator_Status__staff_locator_status_KEY | staff_locator_status_KEY | Staff_Locator_Status |