special-dispatch-app/lib/database/workday.js

const Sequelize = require('sequelize')
const sequelize = require('./sequelize')

const Workday = sequelize.define('workday', {
  id: {
    type: Sequelize.UUID,
    defaultValue: Sequelize.UUIDV1,
    primaryKey: true
  },
  terminalId: Sequelize.UUID,
  date: Sequelize.DATEONLY,
  hours: Sequelize.DOUBLE,
  regularHours: Sequelize.DOUBLE,
  overtimeHours: Sequelize.DOUBLE,
  doubletimeHours: Sequelize.DOUBLE,
  laborCost: Sequelize.DECIMAL(19, 4),
  inbound: Sequelize.INTEGER,
  delivered: Sequelize.INTEGER

}, {
  paranoid: true,
  indexes: [
    {
      unique: true,
      fields: ['terminalId', 'date']
    }
  ]
})

Workday.keyField = 'date'
module.exports = Workday