DatabaseDetails

Details of a logical database.

JSON representation 
{
  "databaseName": string,
  "parentDatabaseDeployment": {
    object (ParentDatabaseDeployment)
  },
  "allocatedStorageBytes": string,
  "schemas": [
    {
      object (DatabaseSchema)
    }
  ]
}
Fields
databaseName

string

The name of the database.
parentDatabaseDeployment

object (ParentDatabaseDeployment)

The parent database deployment that contains the logical database.
allocatedStorageBytes

string (int64 format)

The allocated storage for the database in bytes.
schemas[]

object (DatabaseSchema)

The database schemas.

ParentDatabaseDeployment

The identifiers of the parent database deployment.

JSON representation 
{
  "generatedId": string,
  "manualUniqueId": string
}
Fields
generatedId

string

The parent database deployment generated ID.
manualUniqueId

string

The parent database deployment optional manual unique ID set by the user.

DatabaseSchema

Details of a database schema.

JSON representation 
{
  "schemaName": string,
  "tablesSizeBytes": string,
  "objects": [
    {
      object (DatabaseObjects)
    }
  ],

  // Union field engine_details can be only one of the following:
  "sqlServer": {
    object (SqlServerSchemaDetails)
  },
  "mysql": {
    object (MySqlSchemaDetails)
  },
  "postgresql": {
    object (PostgreSqlSchemaDetails)
  }
  // End of list of possible types for union field engine_details.
}
Fields
schemaName

string

The name of the schema.
tablesSizeBytes

string (int64 format)

The total size of tables in bytes.
objects[]

object (DatabaseObjects)

List of details of objects by category.
Union field engine_details. Engine-specific details. engine_details can be only one of the following:
sqlServer

object (SqlServerSchemaDetails)

Details of a SqlServer schema.
mysql

object (MySqlSchemaDetails)

Details of a Mysql schema.
postgresql

object (PostgreSqlSchemaDetails)

Details of a PostgreSql schema.

DatabaseObjects

Details of a group of database objects.

JSON representation 
{
  "category": enum (Category),
  "count": string
}
Fields
category

enum (Category)

The category of the objects.
count

string (int64 format)

The number of objects.

Category

The category of a database object.

Enums
CATEGORY_UNSPECIFIED Unspecified type.
TABLE Table.
INDEX Index.
CONSTRAINTS Constraints.
VIEWS Views.
SOURCE_CODE Source code, e.g. procedures.
OTHER Uncategorized objects.

SqlServerSchemaDetails

Specific details for a SqlServer database.

JSON representation 
{
  "clrObjectCount": integer
}
Fields
clrObjectCount

integer

Optional. SqlServer number of CLR objects.

MySqlSchemaDetails

Specific details for a Mysql database.

JSON representation 
{
  "storageEngines": [
    {
      object (MySqlStorageEngineDetails)
    }
  ]
}
Fields
storageEngines[]

object (MySqlStorageEngineDetails)

Optional. Mysql storage engine tables.

MySqlStorageEngineDetails

Mysql storage engine tables.

JSON representation 
{
  "engine": enum (Engine),
  "tableCount": integer,
  "encryptedTableCount": integer
}
Fields
engine

enum (Engine)

Required. The storage engine.
tableCount

integer

Optional. The number of tables.
encryptedTableCount

integer

Optional. The number of encrypted tables.

Engine

Storage engines.

Enums
ENGINE_UNSPECIFIED Unspecified storage engine.
INNODB InnoDB.
MYISAM MyISAM.
MEMORY Memory.
CSV CSV.
ARCHIVE Archive.
BLACKHOLE Blackhole.
NDB NDB.
MERGE Merge.
FEDERATED Federated.
EXAMPLE Example.
OTHER Other.

PostgreSqlSchemaDetails

Specific details for a PostgreSql schema.

JSON representation 
{
  "foreignTablesCount": integer,
  "postgresqlExtensions": [
    {
      object (PostgreSqlExtension)
    }
  ]
}
Fields
foreignTablesCount

integer

Optional. PostgreSql foreign tables.
postgresqlExtensions[]

object (PostgreSqlExtension)

Optional. PostgreSql extensions.

PostgreSqlExtension

PostgreSql extension.

JSON representation 
{
  "extension": string,
  "version": string
}
Fields
extension

string

Required. The extension name.
version

string

Required. The extension version.