workflow.Workflow_ProcedureDependency_T - U

type: U ( user table ), modify_date: 2022-09-05 18:18:09

RepoObject_guid: 84A67203-EAFA-EB11-850E-A81E8446D5B0

InheritanceType: 13

Description

per active Workflow all active ProcedureDependency, including redundant references

Example 1. redundant references

are to be preserved:

  • A ⇐ B

  • B ⇐ C

  • C ⇐ D

redundant:

  • A ⇐ C

  • A ⇐ D

  • B ⇐ C

Examples

Entity Diagram

entity-workflow.workflow_proceduredependency_t

Columns

Table 1. Columns of workflow.Workflow_ProcedureDependency_T - U
PK Column Name Data Type NULL? ID

1

int

NOT NULL

2

uniqueidentifier

NOT NULL

3

uniqueidentifier

NOT NULL

Default: DF_Workflow_ProcedureDependency_T_is_redundant
((0))

bit

NOT NULL

Persistence, History Table

  • persistence source: workflow.Workflow_ProcedureDependency - V

  • is_persistence: 1

  • is_persistence_check_duplicate_per_pk: 0

  • is_persistence_check_for_empty_source: 0

  • is_persistence_delete_changed: 0

  • is_persistence_delete_missing: 0

  • is_persistence_insert: 1

  • is_persistence_truncate: 1

  • is_persistence_update_changed: 0

  • has_history: 0

  • has_history_columns: 0

Foreign Key Diagram

entity_1_1_fk-workflow.workflow_proceduredependency_t

References

Object Reference Diagram - 1 1

entity_1_1_objectref-workflow.workflow_proceduredependency_t

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-workflow.workflow_proceduredependency_t

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-workflow.workflow_proceduredependency_t

Column Reference Diagram

entity_1_1_colref-workflow.workflow_proceduredependency_t

Indexes

PK_Workflow_ProcedureDependency_T

idx_Workflow_ProcedureDependency_T__1

idx_Workflow_ProcedureDependency_T__2

idx_Workflow_ProcedureDependency_T__3

idx_Workflow_ProcedureDependency_T__4

Column Details

_

is_redundant

is_redundant

Default: DF_Workflow_ProcedureDependency_T_is_redundant
((0))

bit

NOT NULL