Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Excerpt

Filesystem structure

KGS Store will create a directory tree which depends on the parameter FolderDepth. In the lowest subfolder the document data file will be saved.

Image Modified

Database structure

KGS Store uses three tables for storing all needed component and document information

Table: <Prefix_>DOCUMENT

Field name

Field value

Type

Description

CSREPID (Index)


VARCHAR(40)

SAP ContentRepositoryID

DOCID (Index)


VARCHAR(40)

SAP DocumentID

ALVERS

4500

VARCHAR(4)

ArchiveLink-Version

0031 / 0045

PROTECTION


VARCHAR(4)

SAP ProtectionFlag

CREDATETIME


DATE

SAP creation timestamp

MODDATETIME


DATE

SAP modification timestamp

RETDATE


CHAR(8)

Retention Date

BARCODE


CHAR(40)

SAP barcode (for future use)

Table: <Prefix_>COMPONENT

Field name

Field value

Type

Description

CSREPID (Index)


VARCHAR(40)

SAP ContentrepositoryID

DOCID (Index)


VARCHAR(40)

SAP DocumentID

COMPID (Index)


VARCHAR(512)

SAP CompID

ALVERS

4500

VARCHAR(4)

ArchiveLink-Version

0031 / 0045

CREDATETIME


DATE

SAP creation timestamp

MODDATETIME


DATE

SAP modification timestamp

RETDATE


DATE

Retentiondate

APPVERS


VARCHAR(80)

SAP Application Version

COMPTYPE


VARCHAR(80)

SAP Mimetype

CHARSET


VARCHAR(80)

SAP Charset

FILESIZE


NUMBER


FILEN


VARCHAR(512)

Filename in file system (if CONTAINERFILE is not empty,

Filename of a ZIP Container)

ORGFILEN


VARCHAR(512)

Original filename

CONTAINERFILE


VARCHAR(255)

Filename in container (if container

HASHALG


VARCHAR(10)

Hash algorithm

HASKEY


VARCHAR(128)

Hash key

HASHALGCONTFILE


VARCHAR(10)

Hash algorithm container file

HASHKEYCONTFILE


VARCHAR(128)

Hash key container file

Table: DOCUMENT_KEYS

Field name

Field value

Type

Description

NAME (Index)


VARCHAR(40)

Key name

VALUE (Index)


VARCHAR(255)

Key value

CSREPID (Index)


VARCHAR(40)

SAP ContentrepositoryID

DOCID (Index)


VARCHAR(40)

SAP DocumentID



...

→ Configuration (Store) - STORAGEFSDB (3) | Configuration (Store) - StorageTypes - ArchiveLink