MARIProject Database Structure

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

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

INT Primary

DeviceType DeviceType

INT

DeviceName DeviceName

NVARCHAR (250)

DatabaseName DatabaseName

NVARCHAR (50)

PathFileName PathFileName

NVARCHAR (250)

ProjectNumber Projektnummer

NVARCHAR (20) Index

MARIProjectMaster.ProjectNumber
PlanningVersion Planungsversion

INT

MARIProjectPlanningVersions.PlanningVersion
MethodType Methode

SMALLINT

FirstIndent FirstIndent

INT

LastIndent LastIndent

INT

LastImport LastImport

Datetime

LastImportID LastImportID

NVARCHAR (4) Index

MARIUser.LastImportID (WHERE BenutzerTyp=1)
LastExport LastExport

Datetime

LastExportID LastExportID

NVARCHAR (4) Index

MARIUser.LastExportID (WHERE BenutzerTyp=1)
LastMSPConnect LastMSPConnect

Datetime

LastMSPConnectID LastMSPConnectID

NVARCHAR (4) Index

MARIUser.LastMSPConnectID (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