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).
Deprecation and updates to type
The supertype of RelationalTableType has be changed to ComplexSchemaType rather than TabularColumnType since TabularColumnType is now deprecated.
RelationalView should be changed to has been replaced by CalculatedValue.
License: CC BY 4.0, Copyright Contributors to the ODPi Egeria project.