MARIProject Database Structure

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

Field Table(Germ.field)/Type Description Related
ArchivePatternTreeID ArchivePatternTreeID

INT Primary

ArchivePatternID ArchivePatternID

INT Index

MARISysArchivePattern.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)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
Memo Memo

NTEXT


Linked by

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


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany