labor.js 631 B

12345678910111213141516171819202122232425262728
  1. const Sequelize = require('sequelize')
  2. const sequelize = require('./sequelize')
  3. const Labor = sequelize.define('labor', {
  4. id: {
  5. type: Sequelize.UUID,
  6. defaultValue: Sequelize.UUIDV1,
  7. primaryKey: true
  8. },
  9. staffMemberId: Sequelize.UUID,
  10. workdayId: Sequelize.UUID,
  11. laborCategoryId: Sequelize.UUID,
  12. hours: Sequelize.DOUBLE,
  13. regularHours: Sequelize.DOUBLE,
  14. overtimeHours: Sequelize.DOUBLE,
  15. doubletimeHours: Sequelize.DOUBLE,
  16. laborCost: Sequelize.DECIMAL(19, 4),
  17. }, {
  18. paranoid: true,
  19. indexes: [
  20. {
  21. unique: true,
  22. fields: ['staffMemberId', 'workdayId']
  23. }
  24. ]
  25. })
  26. module.exports = Labor