Sybase · Schema

Sybase ASE Database

Schema for a SAP Adaptive Server Enterprise database resource

DatabaseEnterpriseSAPSQL

Properties

Name Type Description
name string Database name
dbId integer Numeric database identifier
owner string Login name of the database owner
status string Current database status
sizeMB number Total allocated size in megabytes
dataUsedMB number Space used by data in megabytes
logUsedMB number Space used by transaction log in megabytes
created string Database creation timestamp
View JSON Schema on GitHub

JSON Schema

sybase-database-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/sybase/refs/heads/main/json-schema/sybase-database-schema.json",
  "title": "Sybase ASE Database",
  "description": "Schema for a SAP Adaptive Server Enterprise database resource",
  "type": "object",
  "properties": {
    "name": {
      "type": "string",
      "maxLength": 30,
      "description": "Database name"
    },
    "dbId": {
      "type": "integer",
      "description": "Numeric database identifier"
    },
    "owner": {
      "type": "string",
      "description": "Login name of the database owner"
    },
    "status": {
      "type": "string",
      "enum": ["online", "offline", "suspect", "loading", "recovering"],
      "description": "Current database status"
    },
    "sizeMB": {
      "type": "number",
      "description": "Total allocated size in megabytes"
    },
    "dataUsedMB": {
      "type": "number",
      "description": "Space used by data in megabytes"
    },
    "logUsedMB": {
      "type": "number",
      "description": "Space used by transaction log in megabytes"
    },
    "created": {
      "type": "string",
      "format": "date-time",
      "description": "Database creation timestamp"
    }
  },
  "required": ["name", "status"]
}