Schema asset type

A Schema is the highest level of physical structure in a Database. It defines, in a formal language, the structure of the tables and columns in the database.

Schema assets are part of the physical data layer.

Note The physical data layer asset types, Schema, Table, and Column, are available with Data Catalog. The Guided Stewardship operating model specifically includes the logical data layer and conceptual data layer asset types, such as Data Concept, Data Domain, Data Attribute, Data Entity, and Data Model.

Key relation types

Schema assets are:

Related to...

Via the relation type...

Description

Database assets Database has / belongs to Schema

One-to-many relation, whereby:

  • A Database asset can have many Schema assets.
  • A Schema asset can belong to only one Database asset.
Table assets Schema contains / is part of Table

One-to-many relation, whereby:

  • A Schema assert can contain many Table assets.
  • A Table asset can be part of only one Schema asset.