1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

IDENTIFIER

3

ID

4

INTEGER

Identifier (not unique)

4

ORG_ID

4

INTEGER

Original object identifier

5

SEQ

2

SMALLINT

Sequence within entity type or subtype.

Use ORDER_BY_SEQ to return identifiers in the same order as specified in the toolset.

6

ROLE

1

CHAR

Role:

• A (Attribute Identifier)
• R (Relationship Identifier)

7

NAME

32

VARCHAR

Name of identifier

8

PRIMARY_KEY

1

CHAR

Primary identifier for entity type?

• Y (Yes)
• N (No)

9

ENTITY_ID

4

INTEGER

Entity type or subtype for which this attribute or relationship is identifier.

Join with:

• ENTITY_TYPE
• ENTITY_SUBTYP

10

ATTR_OR_REL_
ID

4

INTEGER

ID of attribute or relationship