2021-08-11 17:17:55 +00:00
|
|
|
# Database
|
|
|
|
|
2021-08-16 16:28:10 +00:00
|
|
|
This schema defines the Database entity. A database also referred to as Database Catalog is a collection of tables.
|
2021-08-11 17:17:55 +00:00
|
|
|
|
2021-11-15 21:35:54 +05:30
|
|
|
**$id:**[**https://open-metadata.org/schema/entity/data/database.json**](https://open-metadata.org/schema/entity/data/database.json)
|
2021-08-11 17:17:55 +00:00
|
|
|
|
|
|
|
Type: `object`
|
|
|
|
|
|
|
|
## Properties
|
2021-11-15 21:35:54 +05:30
|
|
|
- **id**
|
|
|
|
- Unique identifier that identifies this database instance.
|
|
|
|
- $ref: [../../type/basic.json#/definitions/uuid](../types/basic.md#uuid)
|
|
|
|
- **name** `required`
|
|
|
|
- Name that identifies the database.
|
|
|
|
- $ref: [#/definitions/databaseName](#databasename)
|
|
|
|
- **fullyQualifiedName**
|
|
|
|
- Name that uniquely identifies a database in the format 'ServiceName.DatabaseName'.
|
|
|
|
- Type: `string`
|
|
|
|
- **displayName**
|
|
|
|
- Display Name that identifies this database.
|
|
|
|
- Type: `string`
|
|
|
|
- **description**
|
|
|
|
- Description of the database instance.
|
|
|
|
- Type: `string`
|
|
|
|
- **version**
|
|
|
|
- Metadata version of the entity.
|
|
|
|
- $ref: [../../type/entityHistory.json#/definitions/entityVersion](../types/entityhistory.md#entityversion)
|
|
|
|
- **updatedAt**
|
|
|
|
- Last update time corresponding to the new version of the entity.
|
|
|
|
- $ref: [../../type/basic.json#/definitions/dateTime](../types/basic.md#datetime)
|
|
|
|
- **updatedBy**
|
|
|
|
- User who made the update.
|
|
|
|
- Type: `string`
|
|
|
|
- **href**
|
|
|
|
- Link to the resource corresponding to this entity.
|
|
|
|
- $ref: [../../type/basic.json#/definitions/href](../types/basic.md#href)
|
|
|
|
- **owner**
|
|
|
|
- Owner of this database.
|
|
|
|
- $ref: [../../type/entityReference.json](../types/entityreference.md)
|
|
|
|
- **service** `required`
|
|
|
|
- Link to the database cluster/service where this database is hosted in.
|
|
|
|
- $ref: [../../type/entityReference.json](../types/entityreference.md)
|
|
|
|
- **location**
|
|
|
|
- Reference to the Location that contains this database.
|
|
|
|
- $ref: [../../type/entityReference.json](../types/entityreference.md)
|
|
|
|
- **usageSummary**
|
|
|
|
- Latest usage information for this database.
|
|
|
|
- $ref: [../../type/usageDetails.json](../types/usagedetails.md)
|
|
|
|
- **tables**
|
|
|
|
- References to tables in the database.
|
|
|
|
- $ref: [../../type/entityReference.json#/definitions/entityReferenceList](../types/entityreference.md#entityreferencelist)
|
|
|
|
- **changeDescription**
|
|
|
|
- Change that lead to this version of the entity.
|
|
|
|
- $ref: [../../type/entityHistory.json#/definitions/changeDescription](../types/entityhistory.md#changedescription)
|
2021-08-26 13:33:44 +05:30
|
|
|
|
|
|
|
|
|
|
|
## Type definitions in this schema
|
2021-09-19 08:43:31 +05:30
|
|
|
|
2021-11-13 23:03:20 +05:30
|
|
|
### databaseName
|
2021-08-26 13:33:44 +05:30
|
|
|
|
2021-11-15 21:35:54 +05:30
|
|
|
- Name that identifies the database.
|
|
|
|
- Type: `string`
|
|
|
|
- The value must match this pattern: `^[^.]*$`
|
|
|
|
- Length: between 1 and 64
|
2021-10-18 18:02:22 +05:30
|
|
|
|
2021-11-15 21:35:54 +05:30
|
|
|
|
|
|
|
_This document was updated on: Monday, November 15, 2021_
|