repo.RepoObject_persistence - U

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

RepoObject_guid: 4690291C-9D61-EB11-84DC-A81E8446D5B0

Description

contains settings for persistence.

extra table is required to allow FK with

  • ON UPDATE CASCADE

  • ON DELETE CASCADE

Examples

Entity Diagram

entity-repo.repoobject_persistence

Columns

Table 1. Columns of repo.RepoObject_persistence - U
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

char(1)

NULL

nvarchar(128)

NULL

Default: DFRepoObjechas_h__29AC2CE0
((0))

bit

NOT NULL

Default: DFRepoObjechas_h__2AA05119
((0))

bit

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

Default: DF_RepoObject_persistence_is_persistence_check_for_empty_source1
((0))

bit

NOT NULL

Default: DFRepoObjecis_hi__2B947552
((0))

bit

NOT NULL

Default: DFRepoObjecis_pe__2C88998B
((0))

bit

NOT NULL

Default: DFRepoObjecis_pe__2D7CBDC4
((0))

bit

NOT NULL

Default: DFRepoObjecis_pe__2E70E1FD
((1))

bit

NOT NULL

Default: DF_RepoObject_persistence_is_persistence_merge_update_changed1
((0))

bit

NOT NULL

Default: DFRepoObjecis_pe__2F650636
((1))

bit

NOT NULL

Default: DFRepoObjecis_pe__30592A6F
((0))

bit

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

Definition
(CONVERT([bit],(1),(0)))

bit

NULL

Definition
(CONVERT([tinyint],case [has_history] when (1) then (2) else (0) end,(0)))

tinyint

NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobject_persistence

Indexes

PK_RepoObject_persistence

Column Details

_

ColumnListNoInsert

ColumnListNoInsert

nvarchar(4000)

NULL

ExecutionLogId_action

ExecutionLogId_action

char(1)

NULL

final_target_RepoObject_name

final_target_RepoObject_name

nvarchar(128)

NULL

is_persistence_check_duplicate_per_pk

is_persistence_check_duplicate_per_pk

Default: DF_RepoObject_persistence_is_persistence_check_for_empty_source1
((0))

bit

NOT NULL

is_persistence_persist_source

is_persistence_persist_source

Default: DF_RepoObject_persistence_is_persistence_merge_update_changed1
((0))

bit

NOT NULL

temporal_type

temporal_type

Definition
(CONVERT([tinyint],case [has_history] when (1) then (2) else (0) end,(0)))

tinyint

NULL

Description

(CONVERT([tinyint],case [has_history] when (1) then (2) else (0) end))