MARIProject Database Structure

Table Name:MPMSPDatabases
View Name:MARIMSProjectDatabases
Group:Group: MSProjectDatabases
Description:MS Project Interface: Database Link (MSP Server)
ClassID: 30. See Overview of ClassIDs by table.

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

INT Primary

DeviceType DeviceType

INT

DeviceName DeviceName

NVARCHAR (250)

DatabaseName DatabaseName

NVARCHAR (50)

PathFileName PathFileName

NVARCHAR (250)

Projektnummer ProjectNumber

NVARCHAR (20) Index

MPProjektstamm.Projektnummer
Planungsversion PlanningVersion

INT

MPProjektPlanungsversion.Planungsversion
Methode MethodType

SMALLINT

FirstIndent FirstIndent

INT

LastIndent LastIndent

INT

LastImport LastImport

Datetime

LastImportID LastImportID

NVARCHAR (4) Index

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
LastExport LastExport

Datetime

LastExportID LastExportID

NVARCHAR (4) Index

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
LastMSPConnect LastMSPConnect

Datetime

LastMSPConnectID LastMSPConnectID

NVARCHAR (4) Index

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ExportGruppe ExportGruppe

INT

TemplatePathFileName TemplatePathFileName

NVARCHAR (250)

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany