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).

Deprecated types

• The supertype of RelationalTableType has be changed to ComplexSchemaType rather than TabularColumnType since TabularColumnType is now deprecated.
• DerivedRelationalColumn has been replaced by CalculatedValueand DerivedSchemaTypeQueryTarget.
• RelationalView should be changed to has been replaced by CalculatedValue.