Previous Topic: ENTITY_REC_IMPLNext Topic: ENTITY_TYPE


ENTITY_SUBTYP

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

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

ENTITY_SUBTYP

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Entity subtype name

6

DSD_NAME

32

VARCHAR

Data Structure Illustration name

7

MIN_OCCUR

4

INTEGER

Minimum number of occurrences

8

MAX_OCCUR

4

INTEGER

Maximum number of occurrences

9

AVG_OCCUR

4

INTEGER

Average number of occurrences

10

GROWTH_RATE

4

INTEGER

Growth rate (percent)

11

GROWTH_RATE_
PER

1

CHAR

Growth rate period:

  • Y (Year)
  • M (Month)
  • W (Week)
  • D (Day)

12

SEQ

4

INTEGER

Sequence number for presentation

13

PARTITIONING_
ID

4

INTEGER

ID of the partitioning on which the subtype appears

14

PERMIT_VALUE_
ID

4

INTEGER

ID of classifying permitted value for entity subtypes (zero if classifying permitted value does not exist).