1 Reply Latest reply on Mar 18, 2004 2:16 PM by Jerrold Eads

    CMR modeling

    Jerrold Eads Newbie

      I am trying to model a relationship for this type of table:

      LINK_TABLE
      PK ID Unique ID row identifier
      FK TABLE_NAME Some Table in the Schema
      FK TABLE_ID Unique ID for row in table name in TABLE_NAME
      ATTRIBUTES Variety of attributes like CREATION_DATE etc.

      Since the foreign key is a combination key made up of TABLE_NAME and TABLE_ID where TABLE_ID is a column but TABLE_NAME is a table in the catalog, I can't figure out how to model this for CMR.

      Any advice would be appreciated.