text: module.exports = (sequelize, DataTypes) => {
      const ApplicablePhases = sequelize.define('applicablePhases', {
          id: {
              type: DataTypes.UUID,
              allowNull: false,
              defaultValue: DataTypes.UUIDV4,
              primaryKey: true,
              validate: { isUUID: 4 }
          },
          productId: {
              type: DataTypes.UUID,
              allowNull: false,
              validate: { isUUID: 4 }
          },
          phaseId: {
              type: DataTypes.INTEGER,
              allowNull: false
          },
          comment: {
              type: DataTypes.TEXT,
              allowNull: false
          },
          createdAt: {
              type: DataTypes.DATE,
              allowNull: false,
              defaultValue: DataTypes.NOW
          },
          createdBy: {
              type: DataTypes.UUID,
              allowNull: false,
              validate: { isUUID: 4 }
          },
          updatedAt: {
              type: DataTypes.DATE,
              allowNull: false,
              defaultValue: DataTypes.NOW
          },
          updatedBy: {
              type: DataTypes.UUID,
              allowNull: false,
              validate: { isUUID: 4 }
          },
          deletedAt: {
              type: DataTypes.DATE,
              allowNull: true
          },
          deletedBy: {
              type: DataTypes.UUID,
              allowNull: true,
              validate: { isUUID: 4 }
          }
      }, {
          name: {
              singular: 'applicablePhase',
              plural: 'applicablePhases'
          }
      });
      return ApplicablePhases;
  };
  
  /*
  import Sequelize from 'sequelize';
  import { sequelize } from '../../config/database.js';
  
  // 記錄工作品項預計進行的工作階段
  
  export const ApplicablePhases = sequelize.define('applicablePhases', {
      id: {
          type: Sequelize.UUID,
          allowNull: false,
          defaultValue: Sequelize.UUIDV4,
          primaryKey: true,
          validate: { isUUID: 4 }
      },
      productId: {
          type: Sequelize.STRING,
          allowNull: false,
          validate: { isUUID: 4 }
      },
      phaseId: {
          type: Sequelize.INTEGER,
          allowNull: false
      },
      comment: {
          type: Sequelize.TEXT,
          allowNull: false
      },
      createdAt: {
          type: Sequelize.DATE,
          allowNull: false,
          defaultValue: Sequelize.NOW
      },
      createdBy: {
          type: Sequelize.STRING,
          allowNull: false,
          validate: { isUUID: 4 }
      },
      updatedAt: {
          type: Sequelize.DATE,
          allowNull: false,
          defaultValue: Sequelize.NOW
      },
      updatedBy: {
          type: Sequelize.STRING,
          allowNull: false,
          validate: { isUUID: 4 }
      },
      deletedAt: {
          type: Sequelize.DATE,
          allowNull: true
      },
      deletedBy: {
          type: Sequelize.STRING,
          allowNull: true,
          validate: { isUUID: 4 }
      }
  });
  */
  