1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

FIELD

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Field name

6

MACRO_NAME

32

VARCHAR

Macro name (column name)

7

SEQ

2

SMALLINT

Sequence within record

8

ROLE

1

CHAR

Role:

• P (Data)
• F (Foreign key)
• D (Denormalized)

9

FORMAT

1

CHAR

Format:

• P (Packed)
• X (Text)
• D (Date)
• F (Float)
• S (Small)
• I (Integer)
• V (Varchar)
• Q (Timestamp)
• G (Graphic)
• U (Vargraphic)
• M (Long Vargraphic)
• L (Longvarchar)
• B (BLOB)

10

OCCURS

4

INTEGER

Number of occurrences, if repeating.

Not used.

11

LENGTH

4

INTEGER

Length

12

DEC_PLACES

4

INTEGER

Number of decimal places

13

OPT

1

CHAR

DB2 optionality

(Optional)

M (Mandatory)

14

UNITS

1

CHAR

Units (for BLOB only):

• K (KB)
• M (MB)
• G (GB)
• Space (Bytes)

15

FIELDPROC_
NAME

8

VARCHAR

Fieldproc routine name

16

RECORD_IS_IN_
ID

4

INTEGER

ID of the record that contains this field. Join with RECORD.

17

ATTRIBUTE_ID

4

INTEGER

ID of the attribute that this field implements

18

REL_DENORM_ID

4

INTEGER

If this is a denormalized field, ID of the relationship this is denormalized along. Otherwise, zero.

Join with RELATIONSHIP.