MARIProject Database Structure

Table Name:MPHotlineProduktVersion
View Name:MARISupportProductVersions
Group:Group: SupportProduct
Description:Support Module: Support Product: Master Data Versions
ClassID: 106. See Overview of ClassIDs by table.

Field View(engl.field)/Type Description Related
ProduktID ProductID

INT Primary

MPHotlineProdukt.ProduktID
ProduktVersionID ProductVersionID

INT Primary

ProduktVersionsTyp ProductVersionType

INT

0=Normal,1=Patch
ProduktVersion ProductVersion

NVARCHAR (50) Index

Reihenfolge VersionOrder

INT

Indent Indent

INT

ParentProduktVersionID ParentProductVersionID

INT Index

MPHotlineProduktVersion.ProduktVersionID
Released Released

SMALLINT (0=false,-1=true)

Beschreibung Description

NTEXT

VersionsDatum VersionDate

Datetime

AblaufDatum EndOfLifeDate

Datetime

Memo Memo

NTEXT

Erstanlage CreateDate

Datetime

ErstanlageID CreateUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung ChangeDate

Datetime

AenderungID ChangeUser

NVARCHAR (4)

MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
InAktiv Inactive

SMALLINT (0=false,-1=true)

Hide dataset
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MPHotlineAnfrageVersionen Support Module: Issue tracking: Issue linked versions
MPHotlineProduktKunde Support Module: Support Product: Customer Product Link
MPHotlineProduktVersion Support Module: Support Product: Master Data Versions


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany