abarepositorymappings (ap_rma)

Name

abarepositorymappings

Code

ap_rma

Creation Date

21 november 2011 13:11:05

Modification Date

24 september 2012 09:42:45

Comment

Maps paths for a repository to a unique id.


Table description

This table maps a repository path to an ID which is unique for the repository. This solves the problem that different persons may access a repository in different ways. For instance, some may refer to a SourceSafe database by drive letter, while other use an UNC path. When AbaPerls checks whether a file is loaded from the same path as the current version in the database, AbaPerls replaces the repository path of the path with the unique id.

 

A certain path can only appears once in the table, whereas an ID can appear many times.

 

For legacy reasons, tha column repositoryid permits NULL. The table was added in version L1.0.0250 of AbaPerls, prior to which AbaPerls did not track repository ids. AbaPerls fills in the repository id for a path, on first time it gets the occasion.


Column list


Column


Domain

Data
Type

NOT
NULL

F
K


Comment

repositorypath

ap_path

nvarchar(250)

X

 

 

repositoryid

ap_repositoryid

varchar(36)

 

 

 


Keys

Name

Columns

Options

PK

pk_ap_rma

repositorypath clustered

X


Indexes

Name

Columns

ap_rma_id_ix

repositoryid

Tables referring to abarepositorymappings

Child Table

Foreign Key Columns

abahistsysobjects

vc_repository

abainstallhistory

vc_repository

abasysobjects

vc_repository