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.
- Return to Area 5.
License: CC BY 4.0, Copyright Contributors to the ODPi Egeria project.