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.

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.