Table Columns Length - Intergraph Smart Materials - Version 10.2 - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.2

The changes in database table column length are listed in this section.

TABLE_NAME

COLUMN_NAME

CHANGE

DATA_TYPE

LENGTH

M_AI_CONFIGS

IS_MODEL_LATEST

NEW

VARCHAR2

1

M_AOP_TEMPLATES

ATP_ID

NEW

NUMBER

22

M_AOP_TEMPLATES

ATP_TYPE

NEW

VARCHAR2

200

M_AOP_TEMPLATES

DESCRIPTION

NEW

VARCHAR2

4000

M_AOP_TEMPLATES

INT_REV

NEW

NUMBER

22

M_AOP_TEMPLATES

LMOD

NEW

DATE

7

M_AOP_TEMPLATES

MIME_TYPE

NEW

VARCHAR2

200

M_AOP_TEMPLATES

STANDARD_IND

NEW

VARCHAR2

1

M_AOP_TEMPLATES

TEMPLATE_BLOB

NEW

BLOB

4000

M_AOP_TEMPLATES

TEMPLATE_NAME

NEW

VARCHAR2

200

M_AOP_TEMPLATES

TEMPLATE_TYPE

NEW

VARCHAR2

20

M_AOP_TEMPLATES

USR_ID

NEW

VARCHAR2

10

M_ATT_BONDS

BOND_STATUS

NEW

VARCHAR2

1

M_BIR_SESSIONS

EVENT_ID

NEW

VARCHAR2

255

M_BIR_SESSIONS

LIC_TRK_ID

NEW

VARCHAR2

255

M_BIR_SESSIONS

LOADED

NEW

TIMESTAMP(6)

11

M_BIR_SESSIONS

SESS_ID

NEW

VARCHAR2

255

M_BIR_SESSIONS

UNLOADED

NEW

TIMESTAMP(6)

11

M_BIR_SESSIONS

WIN_ID

NEW

VARCHAR2

255

M_EFR_PRELIM_PACKAGES

LAYDOWN_AREA

NEW

NUMBER

22

M_GEOM_BRANCH_VIEWS

DP_ID

NEW

NUMBER

22

M_GEOM_BRANCH_VIEWS

GBV_ID

NEW

NUMBER

22

M_GEOM_BRANCH_VIEWS

HEADER_AXIS

NEW

VARCHAR2

1

M_GEOM_BRANCH_VIEWS

INT_REV

NEW

NUMBER

22

M_GEOM_BRANCH_VIEWS

LEFT_AXIS_ORDER

NEW

VARCHAR2

5

M_GEOM_BRANCH_VIEWS

LMOD

NEW

DATE

7

M_GEOM_BRANCH_VIEWS

M_USR_ID

NEW

VARCHAR2

10

M_GEOM_BRANCH_VIEWS

PROJ_ID

NEW

VARCHAR2

10

M_GEOM_BRANCH_VIEWS

TOP_AXIS_ORDER

NEW

VARCHAR2

5

M_GEOM_BRANCH_VIEWS

USR_ID

NEW

VARCHAR2

10

M_IDENT_STRUCTURES

POS

NEW

VARCHAR2

5

M_IDENT_STRUCTURES

POS

U

VARCHAR2

4

M_INFERENCE_PROCESSES

AICFG_ID

NEW

NUMBER

22

M_INQ_SUPPLIERS

RFQ_SENT_IND

NEW

VARCHAR2

1

M_LIC_LOG_MESSAGES

SESS_ID

NEW

VARCHAR2

255

M_MATL_RECV_RPTS

MRR_PO_SUPP

NEW

NUMBER

22

M_PACKAGES

LAYDOWN_AREA

NEW

NUMBER

22

M_PRELIM_PACKAGES

LAYDOWN_AREA

NEW

NUMBER

22

M_QUESTIONS_KOP2

ACCEPTANCE_CRITERIA

NEW

VARCHAR2

2000

M_QUESTIONS_KOP2

ACCEPTANCE_REQUIRED_IND

NEW

VARCHAR2

1

M_QUESTIONS_KOP2

ACTIVE_IND

NEW

VARCHAR2

1

M_QUESTIONS_KOP2

ANSWER_TYPE

NEW

VARCHAR2

2

M_QUESTIONS_KOP2

ATPL_ID

NEW

NUMBER

22

M_QUESTIONS_KOP2

CT_ID

NEW

NUMBER

22

M_QUESTIONS_KOP2

DOCUMENT_DESCRIPTION

NEW

VARCHAR2

2000

M_QUESTIONS_KOP2

DOCUMENT_REQUIRED_IND

NEW

VARCHAR2

1

M_QUESTIONS_KOP2

INTERNAL_IND

NEW

VARCHAR2

1

M_QUESTIONS_KOP2

INT_REV

NEW

NUMBER

22

M_QUESTIONS_KOP2

LEVEL1

NEW

VARCHAR2

2

M_QUESTIONS_KOP2

LEVEL2

NEW

VARCHAR2

80

M_QUESTIONS_KOP2

LEVEL3

NEW

VARCHAR2

80

M_QUESTIONS_KOP2

LEVEL4

NEW

VARCHAR2

80

M_QUESTIONS_KOP2

LINEITEM_IND

NEW

VARCHAR2

1

M_QUESTIONS_KOP2

LMOD

NEW

DATE

7

M_QUESTIONS_KOP2

MANDATORY_IND

NEW

VARCHAR2

1

M_QUESTIONS_KOP2

MAPPED_TO_ID

NEW

NUMBER

22

M_QUESTIONS_KOP2

ORDER_SEQ

NEW

NUMBER

22

M_QUESTIONS_KOP2

PK_ID

NEW

NUMBER

22

M_QUESTIONS_KOP2

PK_TYPE

NEW

VARCHAR2

5

M_QUESTIONS_KOP2

QE_ID

NEW

NUMBER

22

M_QUESTIONS_KOP2

QUALIFICATION_STAGE

NEW

VARCHAR2

2

M_QUESTIONS_KOP2

USR_ID

NEW

VARCHAR2

10

M_SPEC_BRANCH_REP_DATA

DN_BRANCH

NEW

NUMBER

22

M_SPEC_BRANCH_REP_DATA

GB_ID

NEW

NUMBER

22

M_SPEC_BRANCH_REP_DATA

GB_PREF

NEW

NUMBER

22

M_SPEC_BRANCH_REP_DATA

PC1

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC10

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC11

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC12

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC13

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC14

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC15

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC16

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC17

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC18

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC19

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC2

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC20

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC21

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC22

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC23

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC24

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC25

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC26

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC27

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC28

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC29

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC3

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC30

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC4

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC5

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC6

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC7

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC8

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

PC9

NEW

VARCHAR2

20

M_SPEC_BRANCH_REP_DATA

SBRD_ID

NEW

NUMBER

22

M_SPEC_BRANCH_REP_DATA

SPEC_HEADER_ID

NEW

NUMBER

22

M_SPEC_RATING_DATA_REP

GN_ID

NEW

NUMBER

22

M_SPEC_RATING_DATA_REP

NPRESS

NEW

VARCHAR2

60

M_SPEC_RATING_DATA_REP

NTEMP

NEW

VARCHAR2

60

M_SPEC_RATING_DATA_REP

PRESS_VALUE

NEW

VARCHAR2

120

M_SPEC_RATING_DATA_REP

PT_FROM

NEW

VARCHAR2

60

M_SPEC_RATING_DATA_REP

PT_TO

NEW

VARCHAR2

60

M_SPEC_RATING_DATA_REP

SPEC_HEADER_ID

NEW

NUMBER

22

M_SPEC_RATING_DATA_REP

SRDR_ID

NEW

NUMBER

22

M_SPEC_RATING_DATA_REP

TEMP_VALUE

NEW

VARCHAR2

120

M_SPLM_LIC_REQUEST

SESS_ID

NEW

VARCHAR2

255

M_TMP_ADDED_SUPPS

SUP_ID

U

NUMBER

22

M_USER_LOGIN_DETAILS

CLIENT_HOSTNAME

NEW

VARCHAR2

253

M_USER_LOGIN_DETAILS

CLIENT_IP_ADDRESS

NEW

VARCHAR2

253

M_USER_LOGIN_DETAILS

CLIENT_TYPE

NEW

VARCHAR2

10

M_USER_LOGIN_DETAILS

INT_REV

NEW

NUMBER

22

M_USER_LOGIN_DETAILS

INVALID_TWO_FA_ATTEMPTS

NEW

NUMBER

22

M_USER_LOGIN_DETAILS

LAST_LOGIN_ATTEMPT

NEW

TIMESTAMP(6)

11

M_USER_LOGIN_DETAILS

LAST_TWO_FA_DATE

NEW

DATE

7

M_USER_LOGIN_DETAILS

LMOD

NEW

DATE

7

M_USER_LOGIN_DETAILS

LOGIN_COUNT

NEW

NUMBER

22

M_USER_LOGIN_DETAILS

M_USR_ID

NEW

VARCHAR2

10

M_USER_LOGIN_DETAILS

STATUS

NEW

VARCHAR2

253

M_USER_LOGIN_DETAILS

TWO_FA_IND

NEW

VARCHAR2

1

M_USER_LOGIN_DETAILS

TWO_FA_MODE

NEW

VARCHAR2

15

M_USER_LOGIN_DETAILS

TWO_FA_PIN

NEW

NUMBER

22

M_USER_LOGIN_DETAILS

TWO_FA_PIN_SENT_TIME

NEW

TIMESTAMP(6)

11

M_USER_LOGIN_DETAILS

ULD_ID

NEW

NUMBER

22

M_USER_LOGIN_DETAILS

USR_ID

NEW

VARCHAR2

10