variable "database_name" {
  type        = string
  description = "The name of the database (must be upper-case)."
  default     = "ORCHARD_APP_REPORTING_V2"
}

variable "schemas" {
  type = list(object({
    name                 = string
    is_managed           = optional(bool, true)
    create_roles         = optional(bool, true)
    read_role_name       = optional(string)
    read_write_role_name = optional(string)
  }))
  description = "A list of schemas to create in the database"
  default = [
    { name = "AIRTABLE___ORCHARD___NEW_ADVERTISING_APPUVXSTDAFAH8JZY", is_managed = false, create_roles = true },
    { name = "ALTAFONTE_ABO_ABO4_PRO_MAIN", is_managed = false, create_roles = true },
    { name = "ALTAFONTE_ABO_SYS", is_managed = false, create_roles = true },
    { name = "APOLLO_PROD_DBSONY_DBO", is_managed = false, create_roles = true },
    { name = "ART_RELATIONS_PROD_ART_RELATIONS", is_managed = false, create_roles = true },
    { name = "ART_RELATIONS_PROD_ART_RELATIONS_LOG", is_managed = false, create_roles = true },
    { name = "ART_RELATIONS_PROD_MAXWELL_NEO4J", is_managed = false, create_roles = true },
    { name = "ART_RELATIONS_PROD_MAXWELL_NEO4J_KINESIS", is_managed = false, create_roles = true },
    { name = "ART_RELATIONS_PROD_MAXWELL_SWITCHBOARD", is_managed = false, create_roles = true },
    { name = "ART_RELATIONS_PROD_PHYSICAL_DELIVERY", is_managed = false, create_roles = true },
    { name = "ART_RELATIONS_PROD_PUBLISHING", is_managed = false, create_roles = true },
    { name = "AWAL_SAX_UPDATES", is_managed = false, create_roles = true },
    { name = "CHARTMETRIC_ROLLBACK", is_managed = false, create_roles = true },
    { name = "DEV_INTEGRATIONS_BULK_UPLOAD", is_managed = false, create_roles = true },
    { name = "FAROUK_GDRIVE", is_managed = false, create_roles = true },
    { name = "FIVETRAN_DBT_TRANSFROMATIONS", is_managed = false, create_roles = true },
    { name = "FIVETRAN_GENTRY_INVITRO_STAGING", is_managed = false, create_roles = true },
    { name = "GOOGLE_SHEET", is_managed = false, create_roles = true },
    { name = "GOOGLE_SHEETS", is_managed = false, create_roles = true },
    { name = "GRPS_EXP", is_managed = false, create_roles = true },
    { name = "JDENNISS_TEST_DIRECT_DELIVERY", is_managed = false, create_roles = true },
    { name = "MRC_SFTP", is_managed = false, create_roles = true },
    { name = "ORCHARD_APP_REPORTING_V2", is_managed = false, create_roles = true },
    { name = "PPB_COLLECTIONS_PPB_COLLECTIONS", is_managed = false, create_roles = true },
    { name = "PROCEDURES", is_managed = false, create_roles = true },
    { name = "PROD_CONTENT_REVIEW_CONTENT_REVIEW", is_managed = false, create_roles = true },
    { name = "PROD_DDEX_INGESTER_DDEX_INGESTER", is_managed = false, create_roles = true },
    { name = "PROD_DIRECT_DELIVERY_MAXWELL_LOGGING", is_managed = false, create_roles = true },
    { name = "PROD_HIVE_MODEL_REPORTING", is_managed = false, create_roles = true },
    { name = "PROD_INSIGHTS_PLAYLIST_PAGES_GSHEETS_SYNC", is_managed = false, create_roles = true },
    { name = "PROD_INTEGRATIONS_BULK_UPLOAD", is_managed = false, create_roles = true },
    { name = "PROD_NR_OWNERSHIP_DELIVERY_NEIGHBOURING_RIGHTS_OWNERSHIP_DELIVERY", is_managed = false, create_roles = true },
    { name = "PROD_OWS01_OWS_TRACK", is_managed = false, create_roles = true },
    { name = "PROD_OWS01_SALESSHEETS", is_managed = false, create_roles = true },
    { name = "PROD_OWS01_SALES_GOALS", is_managed = false, create_roles = true },
    { name = "PROD_OWS01_SONY_METADATA", is_managed = false, create_roles = true },
    { name = "PROD_OWS01_SYS", is_managed = false, create_roles = true },
    { name = "PROD_OWS01_YOUTUBE_OWNERSHIP", is_managed = false, create_roles = true },
    { name = "PROD_OWS01_YOUTUBE_OWNERSHIP_SYS", is_managed = false, create_roles = true },
    { name = "PROD_OWS02_OWS_STORE_AVAILABILITY", is_managed = false, create_roles = true },
    { name = "PROD_OWS02_OWS_TIMED_RELEASE_SCHEDULE", is_managed = false, create_roles = true },
    { name = "PROD_OWS02_PAYMENT_HOLDS", is_managed = false, create_roles = true },
    { name = "PROD_OWS_ACCOUNTING_PAYMENT_HOLDS", is_managed = false, create_roles = true },
    { name = "PROD_OWS_ACCOUNTING_SYS", is_managed = false, create_roles = true },
    { name = "PROD_OWS_ASSETS_OWS_ASSETS", is_managed = false, create_roles = true },
    { name = "PROD_OWS_COLLABORATOR_OWS_COLLABORATOR", is_managed = false, create_roles = true },
    { name = "PROD_OWS_DELIVERY_HISTORY_DELIVERY_HISTORY", is_managed = false, create_roles = true },
    { name = "PROD_OWS_PODCAST_OWS_PODCAST", is_managed = false, create_roles = true },
    { name = "PROD_OWS_PRICING_FILM_TRANSPARENCY", is_managed = false, create_roles = true },
    { name = "PROD_OWS_PRICING_PRICING", is_managed = false, create_roles = true },
    { name = "PROD_OWS_PRICING_SYS", is_managed = false, create_roles = true },
    { name = "PROD_OWS_PRODUCT_STORE_MAPPING_OWS_PRODUCT_STORE_MAPPING", is_managed = false, create_roles = true },
    { name = "PROD_OWS_STORE_AVAILABILITY_OWS_STORE_AVAILABILITY", is_managed = false, create_roles = true },
    { name = "PROD_OWS_STORE_AVAILABILITY_SYS", is_managed = false, create_roles = true },
    { name = "PROD_OWS_TIMED_RELEASE_OWS_TIMED_RELEASE_SCHEDULE", is_managed = false, create_roles = true },
    { name = "PROD_OWS_TIMED_RELEASE_SYS", is_managed = false, create_roles = true },
    { name = "PROD_OWS_TRACK_OWS_TRACK", is_managed = false, create_roles = true },
    { name = "PROD_OWS_VIDEO_OWS_VIDEO", is_managed = false, create_roles = true },
    { name = "PROD_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY", is_managed = false, create_roles = true },
    { name = "PROD_PHYSICAL_REPORTING", is_managed = false, create_roles = true },
    { name = "PROD_PROMO_PLAYER_PROMO_PLAYER", is_managed = false, create_roles = true },
    { name = "PROD_ROYALTY_ACCOUNTING_CONTRACT_ROYALTY_ACCOUNTING", is_managed = false, create_roles = true },
    { name = "PROD_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING", is_managed = false, create_roles = true },
    { name = "PROD_ROYALTY_ACCOUNTING_SYS", is_managed = false, create_roles = true },
    { name = "PROD_SALESSHEETS_SALESSHEETS", is_managed = false, create_roles = true },
    { name = "PROD_SALESSHEETS_SYS", is_managed = false, create_roles = true },
    { name = "PROD_SALES_GOALS_SALES_GOALS", is_managed = false, create_roles = true },
    { name = "PROD_SONY_METADATA_SONY_METADATA", is_managed = false, create_roles = true },
    { name = "PROD_SONY_METADATA_SYS", is_managed = false, create_roles = true },
    { name = "PUBLIC", is_managed = false, create_roles = true },
    { name = "QA", is_managed = false, create_roles = true },
    { name = "QA_CONTENT_REVIEW_CONTENT_REVIEW", is_managed = false, create_roles = true },
    { name = "QA_DDEX_INGESTER_DDEX_INGESTER", is_managed = false, create_roles = true },
    { name = "QA_DIRECT_DELIVERY_MAXWELL_LOGGING", is_managed = false, create_roles = true },
    { name = "QA_FINGERPRINT_FINGERPRINT_CAPTURE", is_managed = false, create_roles = true },
    { name = "QA_INSIGHTS_PLAYLIST_PAGES_GSHEETS_SYNC", is_managed = false, create_roles = true },
    { name = "QA_INTEGRATIONS_BULK_UPLOAD", is_managed = false, create_roles = true },
    { name = "QA_INTEGRATIONS_INTEGRATIONS", is_managed = false, create_roles = true },
    { name = "QA_OWS_ASSETS_OWS_ASSETS", is_managed = false, create_roles = true },
    { name = "QA_OWS_ASSETS_SYS", is_managed = false, create_roles = true },
    { name = "QA_OWS_COLLABORATOR_OWS_COLLABORATOR", is_managed = false, create_roles = true },
    { name = "QA_OWS_PODCAST_OWS_PODCAST", is_managed = false, create_roles = true },
    { name = "QA_PERFORMANCE_NR_DELIVERY_NEIGHBOURING_RIGHTS_DELIVERY", is_managed = false, create_roles = true },
    { name = "QA_ROYALTY_ACCOUNTING_CONTRACT_ROYALTY_ACCOUNTING", is_managed = false, create_roles = true },
    { name = "QA_ROYALTY_ACCOUNTING_MAXWELL_ROYALTY_ACCOUNTING", is_managed = false, create_roles = true },
    { name = "QA_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING", is_managed = false, create_roles = true },
    { name = "QA_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING_TEST", is_managed = false, create_roles = true },
    { name = "QA_ROYALTY_ACCOUNTING_SYS", is_managed = false, create_roles = true },
    { name = "QA_ROYALTY_ACCOUNTING_TELEPORT_SYNC_ROYALTY_ACCOUNTING", is_managed = false, create_roles = true },
    { name = "REPORTSDD_DIRECT_DELIVERY", is_managed = false, create_roles = true },
    { name = "SONY_APOLLO_DBSONY_DBO", is_managed = false, create_roles = true },
    { name = "UAT_ROYALTY_ACCOUNTING_ROYALTY_ACCOUNTING", is_managed = false, create_roles = true },
    { name = "YT_VIDEO_REPORT", is_managed = false, create_roles = true },
  ]
}