Table Index - Intergraph Smart Materials - Version 2020 (10.0) - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
2020 (10.0)

The changes in database table index are listed in this section.

TABLE_NAME

INDEX_NAME

TYPE

UNIQUENESS

TABLESPACE_NAME

STATUS

Change

M_APPL_LANGUAGES

AL_UK2

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_BUSINESS_FUNCTIONS

BF_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_CLASS_SYSTEMS

CLS_UK1

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_CMS_COMMTEMPLT_DTLS

CCDL_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_CMSXML_MAP_CONFIGS

CMCF_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_COMMODITY_CODE_INTERFACES

CCI_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_COMPANY_PRICE_TYPES

CPRT_UK1

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_ECO_ACT_STAGING_RAW

ECOACTRAW_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_ECO_ACT_STAGING_RAW

ECOACTRAW_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_ECO_ACT_STAGINGS

ECOAST_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_ECO_ACT_STAGINGS

ECOAST_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_ECO_IVC_STAGINGS

ECOIVC_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_ECO_IVC_STAGINGS

ECOIVC_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_ECO_PO_HEADER_STAGINGS

ECOPOHDR_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_ECO_PO_HEADER_STAGINGS

ECOPOHDR_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_ECO_PO_LI_STAGINGS

ECOPOLI_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_ECO_PO_LI_STAGINGS

ECOPOLI_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_ECO_REQ_HEADER_STAGINGS

ECOREQHDR_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_ECO_REQ_HEADER_STAGINGS

ECOREQHDR_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_ECO_REQ_LI_STAGINGS

ECOREQLI_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_ECO_REQ_LI_STAGINGS

ECOREQLI_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_GEOM_DETAILS

GD_IND2

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_INSPECTION_LEVEL_DETAILS

ILD_ILD_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_INV_ITEMS_SUMS

IVIS_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_INV_TRANSFERS

ITR_APOLI_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANIES

NCP_C_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANIES

NCP_CST_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANIES

NCP_N_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANIES

NCP_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANIES

NCP_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANIES

NCP_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANY_NLS

NCPN_NCP_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANY_NLS

NCPN_NLS_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_COMPANY_NLS

NCPN_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACE_NLS

NIN_NI_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACE_NLS

NIN_NLS_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACE_NLS

NIN_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACES

NI_CST_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACES

NI_INTF_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACES

NI_N_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACES

NI_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACES

NI_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_NOTE_INTERFACES

NI_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_OPC_SPMAT_MENUS

OSM_UK1

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_OPC_SPMAT_PRIVS

OSP_UK1

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_PACKAGE_ITEM_INVOICES

PII_PCKI_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_PACKAGE_ITEM_INVOICES

PII_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_PACKAGE_ITEM_INVOICES

PII_PLIN_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_PDS_PROJWIDE_LISTS

PPWL_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_SCHEDULED_MAILS

SMAIL_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_TRIGGER_NOMINAL_VERSIONS

TNV_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_USED_FILES

UF_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_VENDOR_PROGRESS

VP_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_VENDOR_PROGRESS

VP_POH_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

M_VENDOR_PROGRESS

VP_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW

M_VENDOR_PROGRESS

VP_USR_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

MW_API_OPEN_INTERFACES

AOI_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

MW_API_OPEN_INTERFACES

AOI_PROJ_FK_I

TABLE

NONUNIQUE

M_INDEX

VALID

NEW

MW_API_OPEN_INTERFACES

AOI_UK1

TABLE

UNIQUE

M_INDEX

VALID

NEW

MW_API_OPEN_INTERFACES

AOI_UK2

TABLE

UNIQUE

M_INDEX

VALID

NEW

MW_INSTALL_INFOS

INSI_MW_PK

TABLE

UNIQUE

M_INDEX

VALID

NEW

MW_INSTALL_INFOS

INSI_MW_UK

TABLE

UNIQUE

M_INDEX

VALID

NEW