31 lines
807 B
JavaScript
31 lines
807 B
JavaScript
'use strict';
|
|
|
|
module.exports = (app) => {
|
|
const { INTEGER, CHAR, STRING, DATE } = app.Sequelize;
|
|
|
|
const Examinee = app.model.define('examinee', {
|
|
id: { type: INTEGER(8), primaryKey: true, autoIncrement: true },
|
|
uid: CHAR(15),
|
|
salt: CHAR(24),
|
|
password: CHAR(64),
|
|
user_name: STRING(10),
|
|
identity_card: CHAR(18),
|
|
real_check: INTEGER(3),
|
|
workplace: STRING(60),
|
|
address: STRING(120),
|
|
phone: CHAR(11),
|
|
email: STRING(60),
|
|
referrers: STRING(60),
|
|
status: INTEGER(3),
|
|
created_at: DATE,
|
|
updated_at: DATE,
|
|
login_status: INTEGER(3),
|
|
},{
|
|
freezeTableName: true,
|
|
timestamp: true,
|
|
createdAt: true,
|
|
updatedAt: true,
|
|
});
|
|
|
|
return Examinee;
|
|
}; |