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.

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.