Table: Staff_Locator
Columns
NameTypeConstraintsDescription
staff_locator_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULLDate and time this record was last updated in UTC.
staff_KEYintNOT NULLKey to a Staff record
staff_locator_status_KEYintKey to a Staff Locator Status row
returning_utcdatetimeDate and time the staff will return in UTC.
commentsnvarchar (-1)NOT NULLAny comments entered by the user.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Staff_Locator$staff_locator_KEYstaff_locator_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Staff_Locator$staff_KEYstaff_KEY
Indexes
NameColumnsDescription
IX_Staff_Locator$staff_locator_status_KEYstaff_locator_status_KEYIndex supports foreign key FK_Staff_Locator__Staff_Locator_Status__staff_locator_status_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Staff_Locator__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram