medien

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

Master-data table of storage media (archive media). Each row represents a physical or logical volume (disk, cloud bucket, optical medium) on which document files are archived. Referenced by objectX.medium_doc and objectX.medium_dia.

1. Columns

Name Type Length Description

Name	Type	Length	Description
`id`	`int`	—	Medium ID (primary key).
`name`	`nvarchar`	100	Display name / label of the medium.
`batch`	`int`	—	Batch ID (write operation).
`server_id`	`int`	—	Home server ID.
`set_id`	`int`	—	Set identifier (logical grouping).
`state`	`int`	—	Status code (e.g. active, full, archived).
`medorder`	`int`	—	Sort / order index.
`medsize`	`int`	—	Medium size (bytes — see also `medsize2`).
`written`	`int`	—	Bytes written / fill level.
`mirror_id`	`int`	—	ID of a mirrored medium (for mirror groups).
`autolocked`	`int`	—	Auto-lock flag.
`cluster_size`	`int`	—	Cluster size.
`medsize2`	`int`	—	Medium size (second value; extends `medsize` for large volumes).

id

int

—

Medium ID (primary key).

name

nvarchar

100

Display name / label of the medium.

batch

int

—

Batch ID (write operation).

server_id

int

—

Home server ID.

set_id

int

—

Set identifier (logical grouping).

state

int

—

Status code (e.g. active, full, archived).

medorder

int

—

Sort / order index.

medsize

int

—

Medium size (bytes — see also medsize2).

written

int

—

Bytes written / fill level.

mirror_id

int

—

ID of a mirrored medium (for mirror groups).

autolocked

int

—

Auto-lock flag.

cluster_size

int

—

Cluster size.

medsize2

int

—

Medium size (second value; extends medsize for large volumes).

2. Related tables

medrel — relations to media sets.
archex — mapping of document types to servers for archiving.