MARIProject Database Structure

Table Name:MPPeriodenKW
View Name:MARIPeriodsCalendarWeeks
Group:Group: Periods
Description:Calendar Management: CalendarWeeks by ISO

Field View(engl.field)/Type Description Related
KW CW

INT Primary

YYYYWW
Jahr PeriodYear

SMALLINT

YYYY
Woche PeriodWeek

SMALLINT

WW based on ISO
StartDatum StartDate

Datetime Index

EndDatum EndDate

Datetime Index

PeriodeMin PeriodMin

INT Index

MPPerioden.PeriodeJahr
PeriodeMax PeriodMax

INT Index

MPPerioden.PeriodeJahr
UpdateStamp UpdateStamp

INT


Linked by

Table Description
MPChefInfoDashboard Project Dash Board Settings
MPEquipmentSubjectBooking Time/Costbooking on Equipment data
MPKalenderTage Calendar Management: Calendar Day Definition
MPPersonenZeitenTage Attandence: Actions "in the door" (Day header)
MPProjektArbeitspaketerfassung Work Packages progress reporting by day
MPProjektArtikelerfassung Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf
MPProjektBuchungserfassung Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany