annotations

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

Holds annotations (e.g. markings, stamps, notes) on individual pages of documents. One row per annotation with image and XML data.

1. Columns

Name Type Length Description

Name	Type	Length	Description
`annotation_id`	`int`	—	Annotation ID (primary key).
`object_id`	`int`	—	ID of the affected document. References `objectX.id`.
`page`	`int`	—	Page number in the document.
`user_id`	`int`	—	ID of the creator. References benutzer.id.
`flag`	`int`	—	Status flags (bitmask).
`zeitstempel`	`int`	—	Timestamp of the last change (UNIX time).
`timeout`	`int`	—	Expiry / timeout timestamp.
`annotation`	`image`	—	Annotation as image data (BLOB).
`pdfresolution`	`int`	—	PDF resolution in DPI (for vector-based / PDF annotations).
`annotationxml`	`image`	—	Annotation as XML representation (BLOB).

annotation_id

int

—

Annotation ID (primary key).

object_id

int

—

ID of the affected document. References objectX.id.

page

int

—

Page number in the document.

user_id

int

—

ID of the creator. References benutzer.id.

flag

int

—

Status flags (bitmask).

zeitstempel

int

—

Timestamp of the last change (UNIX time).

timeout

int

—

Expiry / timeout timestamp.

annotation

image

—

Annotation as image data (BLOB).

pdfresolution

int

—

PDF resolution in DPI (for vector-based / PDF annotations).

annotationxml

image

—

Annotation as XML representation (BLOB).

2. Related tables

ann_groups — assignment to user groups.

3. Usage by Server-API jobs

cnv.CreateSlide — creates slide annotations.
cnv.AddAnnotations — burns annotations into image files.