starr-philproperties/apps/api/database/migrations/20270101000062-create-pending-certificates.js

'use strict';

module.exports = {
  async up(queryInterface, Sequelize) {
    await queryInterface.createTable('pending_certificates', {
      pending_id:   { type: Sequelize.BIGINT,      primaryKey: true, autoIncrement: true },
      user_id:      { type: Sequelize.BIGINT,      allowNull: false, references: { model: 'users', key: 'user_id' }, onDelete: 'CASCADE' },
      course_id:    { type: Sequelize.BIGINT,      allowNull: false },
      course_uuid:  { type: Sequelize.STRING(36),  allowNull: false },
      course_title: { type: Sequelize.TEXT,        allowNull: true  },
      passed_at:    { type: Sequelize.DATE,        allowNull: false },
      issue_at:     { type: Sequelize.DATE,        allowNull: false },
      processed_at: { type: Sequelize.DATE,        allowNull: true  },
      createdAt:    { type: Sequelize.DATE,        allowNull: false },
      updatedAt:    { type: Sequelize.DATE,        allowNull: false },
    });

    await queryInterface.addIndex('pending_certificates', ['user_id'],                { name: 'idx_pc_user_id'     });
    await queryInterface.addIndex('pending_certificates', ['issue_at'],               { name: 'idx_pc_issue_at'    });
    await queryInterface.addIndex('pending_certificates', ['processed_at'],           { name: 'idx_pc_processed_at' });
    await queryInterface.addIndex('pending_certificates', ['user_id', 'course_id'],   { name: 'idx_pc_user_course', unique: true });
  },

  async down(queryInterface) {
    await queryInterface.dropTable('pending_certificates');
  },
};