Database
Appraisal
EmployeeAppraisalMaster

EmployeeAppraisalMaster

Documentation for the EmployeeAppraisalMaster database schema.

Fields

FieldData TypeUsage
anyIdObjectIdUnique reference to any.
appraisalIdStringUnique reference to appraisal.
appraisalDateDateTimestamp/Date for appraisalDate.
financialYearIdObjectIdUnique reference to financial Year.
employeeIdObjectIdUnique reference to employee.
fileNameStringThe name or title of the employeeappraisalmaster.
contentTypeStringStores the content type data.
attachmentBuffer // Assuming image data will be stored as a Buffer (binary data)Timestamp/Date for attachment.
employeeCommentsStringStores the employee comments data.
headOfDepartmentCommentsStringStores the head of department comments data.
joiningDirectorCommentsStringStores the joining director comments data.
directorCommentsStringStores the director comments data.
otherCommentsStringStores the other comments data.
isDeletedBooleanStores the is deleted data.
insertedUserIdObjectIdUnique reference to inserted User.
updatedUserIdObjectIdUnique reference to updated User.
insertedDateIdObjectIdUnique reference to inserted Date.
updatedDateIdObjectIdUnique reference to updated Date.
timestampDateTimestamp/Date for timestamp.