rev_group_rule_cci_map should include a foreign key constraint

[csmig]

rev_group_rule_cci_map maps CCIs to rows in rev_group_rule_map using the field rgrId.

However, there is no foreign key constraint or CASCADE behavior defined. Therefore, when a STIG revision is removed and the records in rev_group_rule_map are cascade deleted, the rows in rev_group_rule_cci_map remain. This will create unnecessary bloat over time.

Suggested migration:

const MigrationHandler = require('./lib/MigrationHandler')

const upMigration = [
  `DELETE rgrcc FROM rev_group_rule_cci_map rgrcc left join rev_group_rule_map rgr using (rgrId) 
  where rgr.rgrId is null`,
  `ALTER TABLE rev_group_rule_cci_map ADD CONSTRAINT fk_rev_group_rule_cci_map_1 
  FOREIGN KEY (rgrId) REFERENCES rev_group_rule_map (rgrId) ON DELETE CASCADE ON UPDATE CASCADE`
]

const downMigration = [
]

const migrationHandler = new MigrationHandler(upMigration, downMigration)
module.exports = {
  up: async (pool) => {
    await migrationHandler.up(pool, __filename)
  },
  down: async (pool) => {
    await migrationHandler.down(pool, __filename)
  }
}