Table template

[Joe.Ingle]

Hi all

This is my first post on these forum, so I hope I've got the right one for this subject.

I'm using EA 7.1 to model database schema and can't see an obvious way to create a template for base table elements. To illustrate, when designing dimension tables there are several columns that are common to all, mainly relating to audit/logging functions. See below for pseudo example:

CREATE TABLE [dbo].[Dim_Table]
(
      /*      Variable column attributes      */
      /*      Common column attributes      */
      [RowIsCurrent] [bit] NOT NULL,
      [RowStartDate] [datetime] NOT NULL,
      [RowEndDate] [datetime] NOT NULL CONSTRAINT [RowEndDate_DEF]  DEFAULT ('31/12/9999'),
      [RowChangeReason] [varchar](200) NULL,
      [Scd1Checksum] [int] NULL,
      [Scd2Checksum] [int] NULL,
      [LastModifiedDate] [datetime] NOT NULL,
      [LogKey] [int] NOT NULL
)

What I'd like to do is create a template based on the schema above as a stereotype and rather re define these attributes for each table in the schema, be able to pick a dimension table from the toolbox and have these attributes already set when I drag it on to the diagram.

Does this sound achievable?

Regards

Joe