MARIProject Database Structure

Table Name:MPSammelmappeIndexFelder
View Name:MARIFolderIndexFields
Group:Group: FolderDocuments
Description:Definition of document tags

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

INT Primary

internal code
IndexField IndexField

NVARCHAR (100) Index

UNIQUE NAME of the field
IndexFieldType IndexFieldType

INT Index

Content Type
IndexFieldSource IndexFieldSource

SMALLINT

Source of the field
IndexFieldDescription IndexFieldDescription

NVARCHAR (100)

Readable description of the field (Default for the label in the form)
IndexFieldDescriptionID IndexFieldDescriptionID

INT Index

translation id
IndexDBTable IndexDBTable

NVARCHAR (100) Index

(Optional) Autolink to table
IndexDBField IndexDBField

NVARCHAR (100)

(Optional) Autolink to table.field
IndexFieldOrder IndexFieldOrder

INT

Standard Order (for new forms)
IndexFieldSettings IndexFieldSettings

INT

ClassID ClassID

INT

ClassID
ClassFilter ClassFilter

NVARCHAR (255)

RowSourceType RowSourceType

INT

RowSourceConnection RowSourceConnection

INT

SourceField SourceField

NVARCHAR (100)

RowSource RowSource

NTEXT

ComboboxOptions ComboboxOptions

INT

HiddenField HiddenField

INT

Vorlage f�r Neuanlage eines Forms
CompareMethod CompareMethod

INT

CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MPSammelmappeIndex Document tagging
MPSammelmappeIndexFormFields Link of index fields to an index form
MPSammelmappeIndexValues Index Form Values for MARIDMS


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany