21 lines
511 B
JavaScript
21 lines
511 B
JavaScript
|
'use strict';
|
||
|
|
|
||
|
|
module.exports = (app) => {
|
||
|
|
const { INTEGER, CHAR, STRING, TEXT, DATE } = app.Sequelize;
|
||
|
|
|
||
|
|
const BSNMsg = app.model.define('bsn-msg', {
|
||
|
|
id: { type: INTEGER(8), primaryKey: true, autoIncrement: true },
|
||
|
|
user_uid: CHAR(15),
|
||
|
|
sn_number: STRING(8),
|
||
|
|
original_msg: TEXT,
|
||
|
|
msg_data: TEXT,
|
||
|
|
created_at: DATE
|
||
|
|
}, {
|
||
|
|
freezeTableName: true,
|
||
|
|
timestamp: true,
|
||
|
|
createdAt: true,
|
||
|
|
updatedAt: false
|
||
|
|
});
|
||
|
|
|
||
|
|
return BSNMsg;
|
||
|
|
};
|