Previous Topic: RECORD_REFERENCENext Topic: REL_MUTL_EXCL


REL_IDENT

The following table details various column names along with their descriptions.

Col

Column Name

Len

Coltype

Description

1

ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

REL_IDENT

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 relationship identifiers in the same order as specified in the toolset.

6

NAME

32

VARCHAR

Name of identifier

7

PRIMARY_KEY

1

CHAR

Primary identifier for entity type?

Y (Yes)

N (No)

8

ENTITY_ID

4

INTEGER

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

Join with:

ENTITY_TYPE

ENTITY_SUBTYP

9

RELATIONSHIP_
ID

4

INTEGER

Relationship ID