summaryrefslogtreecommitdiff
path: root/src/services/meal/meal-model.js
blob: ec32bfa068aa20c54e853b10dc6f623fd07bea8a (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
'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
    },
    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;
};