summaryrefslogtreecommitdiff
path: root/src/services/meal/meal-model.js
blob: ea0e7db6b0439762041d0dfe4cb2a65077c0ad8d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
'use strict';

// meal-model.js - A sequelize model
//
// See http://docs.sequelizejs.com/en/latest/docs/models-definition/
// for more of what you can do here.

const Sequelize = require('sequelize');

module.exports = function(sequelize) {
  const meal = sequelize.define('meals', {
    name: {
      type: Sequelize.STRING,
      allowNull: false
    },
    date: {
      type: Sequelize.DATE,
      allowNull: false,
      defaultValue: Sequelize.NOW,
    },
    calories: {
      type: Sequelize.INTEGER,
      allowNull: false
    },
    userid: {
      type: Sequelize.INTEGER,
      allowNull: false,
      references: {
        model: sequelize.model('users'),
        key: 'id',
      }
    },
  }, {
    freezeTableName: true
  });

  meal.sync();

  return meal;
};