Untitled :: IKAN ALM Documentation

Table Description

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER
	No	NAME	VARCHAR2(50)
	Yes	DESCRIPTION	VARCHAR2(255)
	Yes	USERID	VARCHAR2(50)
	Yes	PASSWORD	VARCHAR2(255)
	No	COMMANDPATH	VARCHAR2(255)
	No	TIMEOUT	NUMBER
	No	REPOSITORYURL	VARCHAR2(255)
	No	TAGSDIRECTORY	VARCHAR2(255)
	Yes	TRUNKDIRECTORY	VARCHAR2(255)
	No	REPOSITORYLAYOUT	NUMBER
	Yes	ARCHIVED	NUMBER(1)
	Yes	FETCHMETAPROPERTIES	NUMBER(1)
	Yes	ARCHIVEDDATETIME	DATE
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

Yes

DESCRIPTION

VARCHAR2(255)

Yes

USERID

VARCHAR2(50)

Yes

PASSWORD

VARCHAR2(255)

No

COMMANDPATH

VARCHAR2(255)

No

TIMEOUT

NUMBER

No

REPOSITORYURL

VARCHAR2(255)

No

TAGSDIRECTORY

VARCHAR2(255)

Yes

TRUNKDIRECTORY

VARCHAR2(255)

No

REPOSITORYLAYOUT

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

FETCHMETAPROPERTIES

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

Key	NULL	Column	Type (Size)
P	No	OID	NUMBER

NAME

Name of the Subversion Repository.

Key	NULL	Column	Type (Size)
	No	NAME	VARCHAR2(50)

Key

NULL

Column

Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the Subversion Repository.

Key	NULL	Column	Type (Size)
	Yes	DESCRIPTION	VARCHAR2(255)

Key

NULL

Column

Type (Size)

Yes

DESCRIPTION

VARCHAR2(255)

USERID

The User ID that IKAN ALM will use to access the Subversion Repository.

Key	NULL	Column	Type (Size)
	Yes	USERID	VARCHAR2(50)

Key

NULL

Column

Type (Size)

Yes

USERID

VARCHAR2(50)

PASSWORD

The Password that IKAN ALM will use to access the Subversion Repository.

Key	NULL	Column	Type (Size)
	Yes	PASSWORD	VARCHAR2(255)

Key

NULL

Column

Type (Size)

Yes

PASSWORD

VARCHAR2(255)

COMMANDPATH

The path to the Location where the Subversion Client command (svn.exe or svn) resides.

Key	NULL	Column	Type (Size)
	No	COMMANDPATH	VARCHAR2(255)

Key

NULL

Column

Type (Size)

No

COMMANDPATH

VARCHAR2(255)

TIMEOUT

The time-out value in seconds.

If IKAN ALM is not able to establish a connection with the Subversion Repository within the defined period, it will consider the Repository to be inaccessible.

Key	NULL	Column	Type (Size)
	No	TIMEOUT	NUMBER

Key

NULL

Column

Type (Size)

No

TIMEOUT

NUMBER

REPOSITORYURL

The URL of the machine hosting the Subversion Repository.

Key	NULL	Column	Type (Size)
	No	REPOSITORYURL	VARCHAR2(255)

Key

NULL

Column

Type (Size)

No

REPOSITORYURL

VARCHAR2(255)

TAGSDIRECTORY

The Tags Directory for the Subversion Repository.

Key	NULL	Column	Type (Size)
	No	TAGSDIRECTORY	VARCHAR2(255)

Key

NULL

Column

Type (Size)

No

TAGSDIRECTORY

VARCHAR2(255)

TRUNKDIRECTORY

The Trunk Directory for the Subversion Repository.

Key	NULL	Column	Type (Size)
	Yes	TRUNKDIRECTORY	VARCHAR2(255)

Key

NULL

Column

Type (Size)

Yes

TRUNKDIRECTORY

VARCHAR2(255)

REPOSITORYLAYOUT

The required Repository Layout.

Key	NULL	Column	Type (Size)
	No	REPOSITORYLAYOUT	NUMBER

Key

NULL

Column

Type (Size)

No

REPOSITORYLAYOUT

NUMBER

Value List

0 = Project-oriented

1 = Repository-oriented

2 = Single Project-oriented

ARCHIVED

For internal use only.

Key	NULL	Column	Type (Size)
	Yes	ARCHIVED	NUMBER(1)

Key

NULL

Column

Type (Size)

Yes

ARCHIVED

NUMBER(1)

Value List

0 = no

1 = yes

FETCHMETAPROPERTIES

Indication whether or not the Meta Properties set on source files in the Subversion VCR must be retrieved automatically during the Retrieve code phase. These Meta Properties can be used by the Build and Deploy Scripting Tool.

Key	NULL	Column	Type (Size)
	Yes	FETCHMETAPROPERTIES	NUMBER(1)

Key

NULL

Column

Type (Size)

Yes

FETCHMETAPROPERTIES

NUMBER(1)

Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key	NULL	Column	Type (Size)
	Yes	ARCHIVEDDATETIME	DATE

Key

NULL

Column

Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key	NULL	Column	Type (Size)
	No	VERSION	NUMBER

Key

NULL

Column

Type (Size)

No

VERSION

NUMBER

Indexes

Index	Primary	Unique	Column(s)	Source Table
SUBVERSION_PK	Yes	Yes	OID

Index

Primary

Unique

Column(s)

Source Table

SUBVERSION_PK

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

No referencing tables available.

Report Labels

SUBVERSION_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SUBVERSION_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SUBVERSION_COMMANDPATH_LABEL

English:

Command Path

French:

Chemin de commande

German:

Befehlsverzeichnis

SUBVERSION_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

SUBVERSION_FETCHMETAPROPERTIES_LABEL

English:

Fetch Meta Properties

French:

Collecte des métapropriétés

German:

Meta-Eigenschaften abrufen

SUBVERSION_NAME_LABEL

English:

Name

French:

Nom

German:

Name

SUBVERSION_OID_LABEL

English:

OID

French:

OID

German:

OID

SUBVERSION_PASSWORD_LABEL

English:

Password

French:

Mot de passe

German:

Passwort

SUBVERSION_REPOSITORYLAYOUT_LABEL

English:

Repository Layout

French:

Structure du Référentiel

German:

Struktur des Repository

SUBVERSION_REPOSITORYURL_LABEL

English:

Repository URL

French:

URL du Référentiel Subversion

German:

URL des Repository

SUBVERSION_TAGSDIRECTORY_LABEL

English:

Tags Directory

French:

Répertoire des versions (tags)

German:

Tagverzeichnis

SUBVERSION_TIMEOUT_LABEL

English:

Time-Out (s)

French:

Délai d’expiration (s)

German:

Zeitlimit (s)

SUBVERSION_TRUNKDIRECTORY_LABEL

English:

Trunk Directory

French:

Répertoire de projets (trunk)

German:

Trunkverzeichnis

SUBVERSION_USERID_LABEL

English:

User ID

French:

ID Utilisateur

German:

Benutzer-ID

SUBVERSION_VERSION_LABEL

English:

Version

French:

Version

German:

Version