InstanceEnvironment Table

InstanceEnvironment is a static table listing the possible environments in which database instances may be deployed. For some vendors, the environment affects the costs of licensing the database instance.

Table 1. Database columns for InstanceEnvironment table

Database Column

Details
InstanceEnvironmentID

Type: integer. Key. Generated ID

A unique identifier for an InstanceEnvironment. Possible values and the corresponding default names are:

  • 1 = Development
  • 2 = Test
  • 3 = Staging
  • 4 = Production
  • 5 = Other.
ResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an instance environment. Foreign key to the ComplianceResourceString table.
DefaultValue

Type: text (max 100 characters)

The text to display if the environment resource string has no translation.