1

ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

RELATIONSHIP

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Relationship name

6

NAME_INVERSE

32

VARCHAR

Inverse relationship name

7

TYPE

1

CHAR

Relationship type:

S (Source)

D (Destination)

8

TRANSFERABLE

1

CHAR

Transferable?

Y (Yes)

N (No)

9

OPT

1

CHAR

Optionality:

M (Always)

O (Sometimes)

10

OPT_EXPECTED_
PCT

4

INTEGER

Expected optionality (percent)

11

CARD

1

CHAR

Cardinality:

1 (One)

M (One or many)

12

MIN_CARD

4

INTEGER

Cardinality - at least

13

MAX_CARD

4

INTEGER

Cardinality - at most

14

AVG_CARD

4

INTEGER

Cardinality - on average

15

CARD_MIN_ABS_
EST

1

CHAR

Absolute or estimated minimum cardinality:

E (Estimated)

A (Absolute)

16

CARD_MAX_ABS_
EST

1

CHAR

Absolute or estimated maximum cardinality:

E (Estimated)

A (Absolute)

17

CASCADE_OPTION

1

CHAR

Cascade option (Deletion Rule) for second entity type:

D (Cascade delete)

R (Restrict (disallow))

N (Nullify (disassociate))

C (Deletion rule not set)

18

MOD_OR_REF

1

CHAR

Associate option:

M (Modifying)

R (Referencing)

19

DISPLAY_NAME

1

CHAR

Display relationship name?

Y (Yes)

N (No)

20

SOURCE_ENTITY_
ID

4

INTEGER

Entity type or subtype from which this relationship comes.

Join with:

ENTITY_TYPE

ENTITY_SUBTYP

21

DEST_ENTITY_ID

4

INTEGER

Entity type or subtype to which this relationship goes.

Join with:

ENTITY_TYPE

ENTITY_SUBTYP

22

INVERSE_REL_ID

4

INTEGER

ID of inverse relationship. Join with RELATIONSHIP.

23

TYPE_PERS_TRAN

1

CHAR

Type of relationship:

B (Persistent)

D (Transient)

24

ENCAP_LEVEL

1

CHAR

Level of encapsulation:

space (Public)

P (Protected)

E (Encapsulated)