sptasksemaphore

Table info.

Title Sp Task Semaphore
Description Sp Task Semaphore

Fields

Name Type Required Index Hidden On form Title Pick list Description
TaskSemaphoreID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Context varchar(32) Context context
IsLocked bit(1) Is Locked isLocked
LockedTime datetime Locked Time lockedTime
MachineName varchar(64) Machine Name machineName
Scope tinyint(4) Scope scope
TaskName varchar(32) Task Name taskName
UsageCount int(11) Usage Count usageCount
DisciplineID int(11) MUL
OwnerID int(11) MUL
CollectionID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKF2333F224CE675DE DisciplineID
FKF2333F2251039657 OwnerID
FKF2333F225327F942 ModifiedByAgentID
FKF2333F227699B003 CreatedByAgentID
FKF2333F228C2288BA CollectionID
PRIMARY TaskSemaphoreID

Many-to-one relationships

Name Field Related table Related field
FKF2333F224CE675DE DisciplineID discipline UserGroupScopeId
FKF2333F2251039657 OwnerID specifyuser SpecifyUserID
FKF2333F225327F942 ModifiedByAgentID agent AgentID
FKF2333F227699B003 CreatedByAgentID agent AgentID
FKF2333F228C2288BA CollectionID collection UserGroupScopeId