special-dispatch-app/auto-crud/service.js

const { register, Sequelize } = require('@alancnet/material-framework/auto-crud')

register({
  camelName: 'service',
  iconAsset: 'userIcon',
  schema: {
    id: {
      type: Sequelize.UUID,
      defaultValue: Sequelize.UUIDV1,
      primaryKey: true
    },
    workdayId: Sequelize.UUID,
    clientId: Sequelize.UUID,
    date: Sequelize.DATEONLY, // Copy from Workday
    delivered: Sequelize.INTEGER,
    inbound: Sequelize.INTEGER
  },
  options: {
    paranoid: true,
    indexes: [
      {
        unique: true,
        fields: ['workdayId', 'clientId']
      }
    ]
  },
  columns: [
    { camelName: 'date', type: 'date' },
    { camelName: 'workdayId', titleName: 'Workday', type: 'autocomplete', source: '/api/workdays' },
    { camelName: 'clientId', titleName: 'Client', type: 'autocomplete', source: '/api/clients' },
    { camelName: 'delivered', type: 'number' },
    { camelName: 'scanned', type: 'number' }
  ],
  layout: [
    {
      section: 'Details',
      rows: [
        [ 'name', 'key' ],
        [ 'address' ]
        [ 'terminalId', 'distanceMiles' ]
      ]
    }
  ]
})