MARIProject Database Structure

Table Name:MPSysArchivePatternTree
View Name:MARISysArchivePatternTree
Group:
Description:Definition to tag and place documents into DMS-Trees

Field View(engl.field)/Type Description Related
ArchivePatternTreeID ArchivePatternTreeID

INT Primary

ArchivePatternID ArchivePatternID

INT Index

MPSysArchivePattern.ArchivePatternID
TreeName TreeName

NVARCHAR (100)

TreeOrder TreeOrder

INT Index

TreeOptions TreeOptions

INT

ArchiveOptions ArchiveOptions

INT

AccessMode AccessMode

INT

AccessRead AccessRead

BIGINT

AccessChange AccessChange

BIGINT

AccessInsert AccessInsert

BIGINT

AccessDelete AccessDelete

BIGINT

AccessAll AccessAll

BIGINT

CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Memo Memo

NTEXT


Linked by

Table Description
MPSysArchivePatternTreeLine Definition to tag and place documents into DMS-Trees details


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany