• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

workflow Table (508)

•
Environment: onsite, online
Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

SuperOffice specific info about a workflow

Fields

Name Description Type Null
workflow_id Primary key PK
name Name of the workflow String(255) ●
description Description of the workflow String(4000) ●
status Status of the workflow definition Enum WorkflowDefinitionStatus ●
associate_id Associate who owns this workflow FK associate ●
group_id Group id of original owning associate, so that changes to owner's primary group do not influence group membership of this workflow. FK UserGroup ●
start_only_once A contact can start this flow only once Bool ●
jump_to_finish When a goal is reached, contact jumps directly to finished Bool ●
visible_for_all True if visible for all Bool ●
visible_for_associates Array of references to the visible for associates FKArray ●
visible_for_groups Array of references to the visible for groups FKArray ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

workflow table relationship diagram

Indexes

Fields Types Description
workflow_id PK Clustered, Unique
associate_id FK Index
visible_for_associates, visible_for_groups FKArray, FKArray Full text

Relationships

Table Description
associate Employees, resources and other users - except for External persons
email_flow A set of properties related to the email workflow.
UserGroup Secondary user groups
workflow_goal A set of goals related to a workflow. Some goals will have search criterias associated with it to determine if the goal has been reached.
workflow_instance A set of properties related to the workflow instance of one participant going through the flow
workflow_step A set of steps related to a workflow.
workflow_trigger A set of triggers related to a workflow.

Replication Flags

  • None

Security Flags

  • Sentry controls access to items in this table using user's Role and data rights matrix.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top