Column Groups

ModelRight 3.7 allows you to add Columns as children of a Column Domain.  Any Column that then "inherits" from it will also inherit these sub-Columns.  This allows you to define a group of commonly used Column once and consistently reuse them throughout your Model.

Column Domain Address is used to define sub-columns Street, City, Zip.

ModelRight 3.7 also added a Column display option that lets you choose whether to view the Sub-Columns or the Top-Level Columns on the Diagram.  This option is found under Content Display options for Columns.

Table Domain Columns

You can also add child Columns to a Table Domain.  Any table that then inherits from the Table Domain will also contain those columns.  For example, if you wanted every Table in your Model to contain a Create_Date and a Modify_Date Column.  You could accomplish this by simply adding these Columns to the <default> Table Domain.

Table Domain with create_date and modiy_date sub-Columns.">

The <default> Table Domain with create_date and modiy_date sub-Columns.

Table Inheritance

A Table can now inherit from another Table as well as a Table Domain.  Inheritence relations are displayed on Diagram with an arrow Relation.  All Columns and Table Check Constraints are inherited by the Table.

ModelRight 3.7 also adds a corresponding Column display option that allows you to specify whether inherited Columns are displayed on the Diagram or not.   This option is found under Content Display Options for Columns.

SQL Server Table Type

Support for SQL Server 2008 Table Types like the following has been added:

 

/* Create a user-defined table type */

CREATE TYPE LocationTableType AS TABLE

( LocationName VARCHAR(50)

, CostRate INT );

GO

 

 

 

Page url: https://www.modelright.com