'use strict';

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

    const BDCard = app.model3.define('bd-card', {
        id: { type: INTEGER(8), primaryKey: true, autoIncrement: true },
        card_id: CHAR(8),
        card_imsi: CHAR(18),
        type: INTEGER(3),
        status: INTEGER(3),
        created_at: DATE,
        updated_at: DATE,
      },{
        freezeTableName: true,
        timestamp: true,
        createdAt: true,
        updatedAt: true,
      });

    return BDCard;
};