hyplnk

This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Holds hyperlinks (cross-references) between DMS objects. Each row is a directed relation from object 1 (obj_id1/obj_typ1) to object 2 (obj_id2/obj_typ2), including validity, audit fields and an external relation ID.

Note links are held here as well, not in remarks, which only keeps the text notes (see storage of notes). A note link produces no row in remarks.

Each link produces exactly one row, with obj_id1 as the source and obj_id2 as the target; the remaining columns stay empty. The opposite direction is not stored, it is flipped at runtime: the query delivers the link on both objects involved and tells them apart through the relationdirection attribute. Measured against enaio® server 12.0.

1. Columns

Name Type Length Description

obj_id1

int

—

ID of the source object.

obj_typ1

int

—

Object-type ID of the source object.

obj_id2

int

—

ID of the target object.

obj_typ2

int

—

Object-type ID of the target object.

medium

int

—

Medium identifier.

name

nvarchar

24

Short name of the hyperlink.

textid

nvarchar

32

Text ID / identifier.

flag

int

—

Status flags (bitmask).

valid_from

int

—

Valid from (UNIX time).

valid_to

int

—

Valid to (UNIX time).

ensured

int

—

"Ensured" flag (relation validated).

checked

int

—

"Checked" flag (relation verified).

osrelid

nvarchar

32

GUID of the relation.

osreltextid

nvarchar

32

GUID of the relation text.

osiobjid

int

—

Internal relation object ID.

osiobjtype

int

—

Internal relation object type.

created

int

—

Creation timestamp (UNIX time).

createdby

nvarchar

248

User name of the creator.

modifytime

int

—

Timestamp of the last change (UNIX time).

modifyuser

nvarchar

248

User name of the last modifier.

deleted

int

—

Delete marker.

osuser

int

—

User ID of the creator.