29 lines
739 B
JavaScript
29 lines
739 B
JavaScript
'use strict';
|
|
|
|
module.exports = (app) => {
|
|
const { INTEGER, CHAR, DATE } = app.Sequelize;
|
|
|
|
const Contest = app.model4.define('contest', {
|
|
id: { type: INTEGER(8), primaryKey: true, autoIncrement: true },
|
|
uid: CHAR(15),
|
|
contest_name: CHAR(50),
|
|
contest_organizers: CHAR(50),
|
|
contest_term: CHAR(5),
|
|
type: INTEGER(3),
|
|
status: INTEGER(3),
|
|
online_start: DATE,
|
|
online_end: DATE,
|
|
offline_start: DATE,
|
|
offline_end: DATE,
|
|
contest_start: DATE,
|
|
contest_end: DATE,
|
|
created_at: DATE,
|
|
},{
|
|
freezeTableName: true,
|
|
timestamp: true,
|
|
createdAt: true,
|
|
updatedAt: false,
|
|
});
|
|
|
|
return Contest;
|
|
}; |