Table: W_Medium

ID

bigint

8

False

Unique identifier of the medium.

SiteId

int

4

False

Currently not used.

Rev

bigint

8

False

Revision number. For internal use.

Acl

varbinary(max)

max

False

For internal use only.

MAcl

varbinary(max)

max

False

For internal use only.

DocumentID

bigint

8

False

The ID of the related Document (ID in W_Document).

DocumentSiteId

int

4

False

Currently not used.

Name

nvarchar(255)

510

False

The name of the medium.

TypeID

int

4

False

The ID of the document type (ID in C_DocType).

Flags

int

4

False

Freely usable flags for the processing status of the medium.

FormatID

int

4

False

The ID of the medium format (ID in C_MediumFormat).

Item

int

4

False

The sequence number of the medium.

MetaData

varbinary(max)

max

False

The metadata of the medium.

Length

bigint

8

False

The length (in bytes) of the medium.

Description

nvarchar(255)

510

False

The (optional) description of the medium.

Identifier

nvarchar(255)

510

False

The unique identifier of the medium.

Deleted

int

4

False

Whether the medium is canceled.

BatchID

bigint

8

False

The ID of the root document (BatchID in W_Document).

BatchSiteId

int

4

False

Currently not used.

SheetID

int

4

False

The SheetID of the sheet (not the ID). (SheetID in W_Sheet.)

Rear

int

4

False

0 = front

1 = back (True if the medium belongs to a back page)

Empty

int

4

False

0 = page not blank

1 = page is blank (True if the medium belongs to an blank page)

TagInfo

nvarchar(255)

510

False

Optional tags in the medium.

UserFlags

int

4

False

Freely usable flags for the processing status of the medium.

NumberOfPages

int

4

False

Currently not used.

DeletedAt

datetime

8

True

The date when the data set was deleted from the XBOUND database (main database).

Available in XBOUND 3.8 and later.

FK_W_Medium_W_Document

DocumentID -> W_Document.ID

DocumentSiteId -> W_Document.SiteId