Database Table SurveyEmployee

[This is preliminary documentation and is subject to change.]

This table implements N:M relation between SurveyIterationBody (and hence indirectly to Survey) and Employee - that is, which employees / users are taking part in a survey phase (a survey has same number of phases as the number of accreditation bodies).

Accreditation body number 1 is usually for surveyors. Employees related to a given survey, where body number is 1, are therefore the surveyors taking part in the survey.

The last of the accreditation body numbers (currently 3) is for the accreditation board. Employees related to a given survey, where body number is 3, are therefore the accreditation board members taking part in the survey.

Note that the relation hold a profile name (reference to Profile. This makes it possible that an employee may have different profiles (and hence different permissions) in different surveys. Example: a given surveyor may be "ordinary" survoyer in one survey, but leading surveyor in a different survey.

Fields

Field Name

Type

Note

Description

SurveyId

INT

Primary key

Reference to Survey (field Id)

EmployeeId

INT

Primary key

Reference to Employee (field Id)

BodyNumber

INT

Primary key

Reference to AccreditationBody (field Id)

ProfileName

VARCHAR(255)

Reference to Profile (field ProfileName) - the profile the employee has in survey