variable "database_name" {
  description = "The name of the database."
  default     = "AWAL"
}

variable "read_role_name" {
  description = "The name of the read only database role."
  default     = "AWAL_DB_READ"
}

variable "read_write_role_name" {
  description = "The name of the read write database role."
  default     = "AWAL_DB_READWRITE"
}

variable "db_data_retention_time_in_days" {
  default = 1
}

variable "schemas" {
  type = list(object({
    name                 = string
    data_retention_days  = optional(number, 1)
    is_managed           = optional(bool, false)
    read_role_name       = optional(string)
    read_write_role_name = optional(string)
  }))
  description = "A list of schemas to create in the database"
  default = [
    {
      name = "AWAL_AR"
    },
    {
      name = "AWAL_BI"
    },
    {
      name = "AWAL_BI_DEV"
    },
    {
      name = "AWAL_FINANCE"
    },
    {
      name = "AWAL_FINANCE_DEV"
    },
    {
      name = "AWAL_TRUST_AND_SAFETY"
    },
    {
      name = "KNR"
    },
    {
      name = "KNR_DEV"
    },

  ]
}