/***************************************************
* SUBNETS
****************************************************/

resource "aws_subnet" "sn" {
  vpc_id            = "${var.vpc_id}"
  count             = "${var.nr_subnets}"

  cidr_block        = "${lookup(var.db_subnet_cidrs, count.index)}"
  availability_zone = "${element(data.aws_availability_zones.available.names,count.index)}"

  tags {
    Name            = "${var.stack_name}-db-private_${count.index}"
    managed_by      = "terraform"
  }
}

/***************************************************
* ASSOCIATE SUBNETS TO ROUTE TABLE
****************************************************/
resource "aws_route_table_association" "rta_public" {
  count             = "${var.nr_subnets}"
  subnet_id       = "${element(aws_subnet.sn.*.id,count.index)}"
  route_table_id  = "${var.public_route_table}"
}