0534 Relational Schemas

Model 0534 describes the parts of a relational database schema. These are used in relational databases. There are multiple tables and views defined within the relational schema. The columns are within both the tables and views.

Note that the type information for each column can be directly embedded on the RelationalColumn through the TypeEmbeddedAttribute classification, as both TabularColumn and DerivedSchemaAttribute extend SchemaAttribute.

Also recall that the NestedSchemaAttribute relationship can be used to link directly between RelationalTable (or RelationalView) and the RelationalColumns contained within the table (or view).

UML

Deprecation and updates to type



License: CC BY 4.0, Copyright Contributors to the ODPi Egeria project.