MARIProject Database Structure

Table Name:MPSysMasterPropertyLink
View Name:MARISysMasterPropertyLink
Group:Group: SysMasterProperties
Description:Link between Dimension (ClassID) and a SysMasterProperty. See MPSysMasterProperty.UsageFlag for the used linked dimensions.

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

INT Primary

Link to a property id MPSysMasterProperties.PropertyID
ClassID ClassID

INT Primary

Dimension see enum ClassID
ClassKey ClassKey

NVARCHAR (20) Primary

Key value (OCPR.CntctCode, MARIEmployeeMaster.EmployeeNumber, MARIWorkItem.WorkItemID)
CompanyID CompanyID

SMALLINT Primary

For ContactPerson the id of the linked SBO database MPSysConnections.CompanyID (WHERE ConnectionType=6)
Selected Selected

SMALLINT Index

-1 for a selected property
CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)



Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany