oswfprojects

This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Workflow projects — group workflow models thematically or organisationally.

The table contains no parent column. The project hierarchy lives exclusively in oswfprojectsrel. The same records are returned by wfm.GetProjectList as a flat list.

1. Columns

Name Type Length Description

id

nvarchar

32

ID of the project (primary key); corresponds to Id in wfm.GetProjectList.

org_id

nvarchar

32

ID of the organization the project belongs to.

name

nvarchar

255

Name of the project. Not unique — a project and a workflow family can carry the same name. The system project is named %SYSTEMPROJECT%.

description

nvarchar

255

Description of the project.

ostype

int

—

Kind of entry; corresponds to Type in wfm.GetProjectList: 1 = root project (exactly one per organization), 2 = workflow project, 3 = workflow family. Only a family holds workflow models, and families have no sub-projects.

creatorid

nvarchar

32

ID of the creator. Empty for server-owned entries.

creationtime

int

—

Creation time as a Unix timestamp. 0 means "not set", not 1970-01-01.

proccount

int

—

Appears in the export file of wfm.Export as attribute ProcCount; not retrievable through wfm.GetProjectList.

versioncount

int

—

Appears in the export file of wfm.Export as attribute VersionCount; not retrievable through wfm.GetProjectList.

priority

int

—

Appears in the export file of wfm.Export as attribute Priority; not retrievable through wfm.GetProjectList.

2. Related Tables