'use strict';

module.exports = (app) => {
    const { INTEGER, CHAR, STRING, DATE } = app.Sequelize;

    const Examination = app.model.define('examination', {
        id: { type: INTEGER(8), primaryKey: true, autoIncrement: true },
        uid: CHAR(10),
        exam_name: STRING(60),
        status: INTEGER(3),
        application_start: DATE,
        application_end: DATE,
        exam_start: DATE,
        exam_end: DATE,
      },{
        freezeTableName: true,
        timestamp: true,
        createdAt: false,
        updatedAt: false,
      });

    return Examination;
};