Table Index - 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 index are listed in this section.

TABLE_NAME

INDEX_NAME

CHANGE

TABLE_TYPE

UNIQUENESS

TABLESPACE_NAME

STATUS

M_AI_CONFIGS

AICFG_IDSA_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_AI_CONFIGS

AICFG_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_AI_CONFIGS

AICFG_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_AI_CONFIGS

AICFG_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_APPL_HOME_PAGE_DETAILS

AHPD_DP_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_HOME_PAGE_DETAILS

AHPD_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_APPL_HOME_PAGE_DETAILS

AHPD_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_HOME_PAGE_DETAILS

AHPD_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_APPL_LANGUAGES

AL_NLS_FK_I

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_LANGUAGES

AL_UK2

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_APPL_MENU_DETAILS

AMD_AMS_DESC_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_MENU_DETAILS

AMD_AMS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_MENU_DETAILS

AMD_AUPT_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_MENU_DETAILS

AMD_MENUITEM_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_MENU_DETAILS

AMD_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_APPL_SEARCH_FEED_NLS

ASFN_ASF_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_SEARCH_FEED_NLS

ASFN_NLS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_APPL_SEARCH_FEED_NLS

ASFN_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_APPL_SEARCH_FEEDS

ASF_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_APPL_SEARCH_FEEDS

ASF_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_APPL_SEARCH_FEEDS

ASF_USR_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_BF_LIC_MODULES

BLM_BF_FK_I

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_BF_LIC_MODULES

BLM_LM_FK_I

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_BF_LIC_MODULES

BLM_PK

U

TABLE

UNIQUE

M_INDEX

VALID

M_BUSINESS_FUNCTIONS

BF_BF_UK_UK

U

TABLE

UNIQUE

M_INDEX

VALID

M_BUSINESS_FUNCTIONS

BF_PK

U

TABLE

UNIQUE

M_INDEX

VALID

M_CLASS_SYSTEMS

CLS_P_FK_I

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_CLASS_SYSTEMS

CLS_UK1

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_CLIENT_CERTIFICATES

MCC_PK

U

TABLE

UNIQUE

M_INDEX

VALID

M_CLIENT_CERTIFICATES

MCC_UK

U

TABLE

UNIQUE

M_INDEX

VALID

M_CMS_COMMTEMPLT_DTLS

CCDL_CC_FK_I

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_CMS_COMMTEMPLT_DTLS

CCDL_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_CMS_IMP_JOB_FILES

CIJF_UK

U

TABLE

UNIQUE

M_INDEX

VALID

M_CMSXML_MAP_CONFIGS

CMCF_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_CMSXML_MAP_CONFIGS

CMCF_UK

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_COMMODITY_CODE_INTERFACES

CCI_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_COMMODITY_CODE_INTERFACES

CCI_UK

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_COMPANY_PRICE_TYPES

CPRT_UK

U

TABLE

UNIQUE

M_INDEX

VALID

M_COMPANY_PRICE_TYPES

CPRT_UK1

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_DASHBOARD_NLS

DN_DBRD_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_DASHBOARD_NLS

DN_NLS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_DASHBOARD_NLS

DN_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_DASHBOARDS

DBRD_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_DASHBOARDS

DBRD_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_DASHBOARDS

DBRD_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_DASHBOARD_WIDGETS

DW_DBRD_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_DASHBOARD_WIDGETS

DW_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_DASHBOARD_WIDGETS

DW_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_DASHBOARD_WIDGETS

DW_UK1

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_DASHBOARD_WIDGETS

DW_WGT_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ECO_ACT_STAGING_RAW

ECOACTRAW_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_ECO_ACT_STAGING_RAW

ECOACTRAW_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ECO_ACT_STAGINGS

ECOAST_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_ECO_ACT_STAGINGS

ECOAST_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ECO_IVC_STAGINGS

ECOIVC_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_ECO_IVC_STAGINGS

ECOIVC_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ECO_PO_HEADER_STAGINGS

ECOPOHDR_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_ECO_PO_HEADER_STAGINGS

ECOPOHDR_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ECO_PO_LI_STAGINGS

ECOPOLI_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_ECO_PO_LI_STAGINGS

ECOPOLI_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ECO_REQ_HEADER_STAGINGS

ECOREQHDR_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_ECO_REQ_HEADER_STAGINGS

ECOREQHDR_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ECO_REQ_LI_STAGINGS

ECOREQLI_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_ECO_REQ_LI_STAGINGS

ECOREQLI_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ESUP_2FAS

E2FA_CCP_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_ESUP_2FAS

E2FA_LRC_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_FILE_UPLOAD_HISTORIES

FUH_DO_1_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_FILE_UPLOAD_HISTORIES

FUH_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_FILE_UPLOAD_HISTORIES

FUH_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_GEOM_DETAILS

GD_IND2

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_GEOM_DETAILS

GD_IND3

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_INV_ISSUES

IIS_HC_FOR_IIS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_INV_ISSUES

IIS_SRS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_INV_ITEMS_SUMS

IVIS_IVI_FK_I

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_INV_ITEMS_SUMS

IVIS_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_INV_TRANSFERS

ITR_APOLI_FK

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_INV_TRANSFERS

ITR_APOLI_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_KEYBOARD_SHORTCUT_NLS

KSN_KS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_KEYBOARD_SHORTCUT_NLS

KSN_NLS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_KEYBOARD_SHORTCUTS

KS_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_KEYBOARD_SHORTCUTS

KS_UK1

NEW

TABLE

UNIQUE

M_INDEX

VALID

MLOG$_M_MS_TRANSACTIONS

I_MLOG$_M_MS_TRANSACTIONS

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

MLOG$_M_MS_TRANSACTIONS

I_MLOG$_M_MS_TRANSACTIONS

U

TABLE

NONUNIQUE

MARIAN

VALID

M_OPC_SPMAT_MENUS

OSM_AM_FK_I

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_OPC_SPMAT_MENUS

OSM_UK1

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_OPC_SPMAT_PRIVS

OSP_PRIV_FK_I

U

TABLE

NONUNIQUE

M_INDEX

VALID

M_OPC_SPMAT_PRIVS

OSP_UK1

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_PDMS_EXP_DATA

PED_PED_UK_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_PDMS_EXP_DATA

PED_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_PDS_PROJWIDE_LISTS

PPWL_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_SCHEDULED_MAILS

SMAIL_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_SCHEDULED_MAILS

SMAIL_SME_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_SCH_MAIL_ATTACHMENTS

SMA_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_SCH_MAIL_ATTACHMENTS

SMA_SMAIL_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_SCH_MAIL_ATTACHMENTS

SMA_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_SCH_MAIL_EVENTS

SME_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_SCH_MAIL_EVENTS

SME_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_SCH_MAIL_TO_USERS

SMTU_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_SCH_MAIL_TO_USERS

SMTU_SMAIL_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_SCH_MAIL_TO_USERS

SMTU_USR_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_SCH_MAIL_TRIGGER_DETAILS

SMTD_SMAIL_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_SPEC_COPY_PREVIEW_INFO_TMP

UNQ_KEY

NEW

TABLE

UNIQUE

VALID

M_SP3D_EXP_JOB_BLK_FDBKS

EJBF_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_SP3D_EXP_JOB_BLK_FDBKS

EJBF_SP3D_EJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_TMP_FOUND_IDENTS

TFI_UK

NEW

TABLE

UNIQUE

VALID

M_TRIGGER_NOMINAL_VERSIONS

TNV_TNV_UK_UK

U

TABLE

UNIQUE

M_INDEX

VALID

M_TRIGGER_NOMINAL_VERSIONS

TNV_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_UI_ESUP_MAPS

UIEM_CATEGORY_PT_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_UI_ESUP_MAPS

UIEM_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_UI_ESUP_MAPS

UIEM_PT_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_UI_ESUP_MAPS

UIEM_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_UPLOAD_LIMITS

MUL_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_UPLOAD_LIMITS

MUL_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_USER_KEYBOARD_SHORTCUTS

UKS_KS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_USER_KEYBOARD_SHORTCUTS

UKS_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_USER_KEYBOARD_SHORTCUTS

UKS_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_USER_KEYBOARD_SHORTCUTS

UKS_USR_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_VIEW_NLS

VN1_NLS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_VIEW_NLS

VN1_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_VIEW_NLS

VN1_VW_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_VIEWS

VW_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_VIEWS

VW_VW_UK_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_VIEW_WHITELIST_NLS

VWN_NLS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_VIEW_WHITELIST_NLS

VWN_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_VIEW_WHITELIST_NLS

VWN_VWH_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_VIEW_WHITELISTS

VWH_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_VIEW_WHITELISTS

VWH_VWH_UK_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

MW_API_BOM_QUEUE

ABQ_DP_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

MW_API_BOM_QUEUE

ABQ_NLS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

MW_API_BOM_QUEUE

ABQ_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

MW_API_BOM_QUEUE

ABQ_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

MW_API_OPEN_INTERFACES

AOI_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

MW_API_OPEN_INTERFACES

AOI_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

MW_API_OPEN_INTERFACES

AOI_UK1

NEW

TABLE

UNIQUE

M_INDEX

VALID

MW_API_OPEN_INTERFACES

AOI_UK2

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_WIDGET_FILTERS

WF_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_WIDGET_FILTERS

WF_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_WIDGET_FILTERS

WF_WGT_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGET_NLS

WN_NLS_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGET_NLS

WN_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_WIDGET_NLS

WN_WGT_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGET_ROLES

WGTR_AR_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGET_ROLES

WGTR_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_WIDGET_ROLES

WGTR_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_WIDGET_ROLES

WGTR_WGT_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGETS

WGT_AM_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGETS

WGT_AM_REFERENCES_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGETS

WGT_CSYM_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGETS

WGT_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_WIDGETS

WGT_PROJ_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

M_WIDGETS

WGT_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID

M_WIDGETS

WGT_VW_FK_I

NEW

TABLE

NONUNIQUE

M_INDEX

VALID

MW_INSTALL_INFOS

INSI_MW_PK

NEW

TABLE

UNIQUE

M_INDEX

VALID

MW_INSTALL_INFOS

INSI_MW_UK

NEW

TABLE

UNIQUE

M_INDEX

VALID