tbl_Workflow [Workflow]

Terrasoft CRM 3.0 SDK > Basic Configuration > Tables > System > tbl_Workflow [Workflow]

Contents

Index

tbl_Workflow [Workflow]

Property	Value
Name	tbl_Workflow
Caption	Workflow
Module	System
USI	System\Workflow\tbl_Workflow
Table Group	tg_Workflow
Is administrated by field	No
Is administrated by record	No
Record change is logged	No

#	Name	Type	Name
1.	ID	Identifier	Workflow
2.	CreatedOn	Date/Time	Created On
3.	CreatedByID	Unique identifier GUID	Created By
4.	ModifiedOn	Date/Time	Modification Date
5.	ModifiedByID	Unique identifier GUID	Modified By
6.	ParentSubProcessItemID	Unique identifier GUID	Parent Sub Process Item
7.	OwnerID	Unique identifier GUID	Owner
8.	DiagramServiceID	Unique identifier GUID	Diagram Service
9.	Name	Unicode string [250]	Workflow
10.	StartDate	Date/Time	Start Date
11.	CompleteDate	Date/Time	End Date
12.	Parameters	Large binary object	Parameters

#	Relation name	Field	Table	Cascade relation
1.	FWorkf_OwnerID	OwnerID	tbl_Contact	No
2.	FWorkf_DiagramServiceID	DiagramServiceID	tbl_Service	No
3.	FWorkf_ParentSubProcessItemID	ParentSubProcessItemID	tbl_WorkflowItem	No

#	Name	Unique	Structure
1.	IWorkflow	No	ParentSubProcessItemID
2.	IWorkflow1	No	DiagramServiceID
3.	IWorkflow2	No	OwnerID

Copyright (с) Terrasoft 2002-2007.