3.3.2 Steps to Create Custom Instrument Table

The following are the steps involved in creating a custom instrument table:
  1. Create a new subject area within the ERwin model.
  2. Move the required super-class tables as part of the subject area.
  3. Create the custom instrument table in ERwin. Specify logical name, physical name and description for the table. Define any columns that do not come from any of the standard super-class tables as part of the custom instrument table. Specify logical, physical names, domain and other column properties for each column.
  4. Create subtype relationship between the custom instrument table and various super-class entities.

    Note:

    User defined tables ( custom ) tables should not have "PORTFOLIO" keyword in the name of the table.