resource "aws_db_instance" "switchboard-db-prod" {
  #checkov:skip=CKV2_AWS_60: Ensure RDS instance with copy tags to snapshots is enabled
  #checkov:skip=CKV_AWS_157: Ensure that RDS instances have Multi-AZ enabled
  #checkov:skip=CKV_AWS_226: Ensure DB instance gets all minor upgrades automatically
  #checkov:skip=CKV_AWS_118: Ensure that enhanced monitoring is enabled for Amazon RDS instances
  #checkov:skip=CKV_AWS_293: Ensure that AWS database instances have deletion protection enabled
  allocated_storage                     = 1
  auto_minor_version_upgrade            = false
  availability_zone                     = "us-east-1c"
  backup_retention_period               = 10
  backup_window                         = "09:09-09:39"
  ca_cert_identifier                    = "rds-ca-rsa2048-g1"
  copy_tags_to_snapshot                 = false
  customer_owned_ip_enabled             = false
  db_subnet_group_name                  = "sme_switchboard_prod_rds"
  delete_automated_backups              = true
  deletion_protection                   = false
  enabled_cloudwatch_logs_exports       = ["audit", "error", "general", "slowquery"]
  engine                                = "aurora-mysql"
  #engine_version                        = "8.0.mysql_aurora.3.07.1"
  iam_database_authentication_enabled   = false
  identifier                            = "switchboard-db-prod"
  instance_class                        = "db.serverless"
  iops                                  = 0
  kms_key_id                            = "arn:aws:kms:us-east-1:019963779799:key/d9d0cc05-ec2f-44a7-908a-0235b02be6aa"
  license_model                         = "general-public-license"
  maintenance_window                    = "mon:07:50-mon:08:20"
  max_allocated_storage                 = 0
  monitoring_interval                   = 0
  multi_az                              = false
  network_type                          = "IPV4"
  option_group_name                     = "default:aurora-mysql-8-0"
  parameter_group_name                  = "default.aurora-mysql8.0"
  performance_insights_enabled          = true
  performance_insights_kms_key_id       = "arn:aws:kms:us-east-1:019963779799:key/d9d0cc05-ec2f-44a7-908a-0235b02be6aa"
  performance_insights_retention_period = 7
  port                                  = 3306
  publicly_accessible                   = false
  skip_final_snapshot                   = true
  storage_encrypted                     = true
  storage_throughput                    = 0
  storage_type                          = "aurora"
  tags                                  = {}
  tags_all                              = {}
  username                              = "Admin"
  vpc_security_group_ids                = ["sg-0d6fdb8d831ef4c04"]
  apply_immediately = true
  allow_major_version_upgrade = true
}