MARIProject Database Structure

View Name:MARITrainingParticipantGrades
Based on table:MPTrainingParticipantGrades
Group:Group: TrainingParticipant
Description:Training Module: Grades of participants
ClassID: 447. See Overview of ClassIDs by table.

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

INT Primary

ParticipantNumber ParticipantNumber

NVARCHAR (20) Index

MARITrainingParticipant.ParticipantNumber
GradeNumber GradeNumber

NVARCHAR (20) Index

MARITrainingGrade.GradeNumber
DateOfGrade DateOfGrade

Datetime

ValidationType ValidationType

INT

WorkItemID WorkItemID

INT

MARIWorkItem.WorkItemID
Memo Memo

NTEXT

Option1 Option1

INT

CreateDate CreateDate

Datetime

CreateUser CreateUser

NVARCHAR (4)

MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate ChangeDate

Datetime

ChangeUser ChangeUser

NVARCHAR (4)

MARIUser.ChangeUser (WHERE BenutzerTyp=1)
Description Description

NTEXT

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany