Maximo table learning summary)

Document directory

• Maximo table learning Summary

Maximo table learning Summary

Table Structure:
ID of each table. If the sequence is generated, the sequence name is basically table name + seq
Table Name: A _ table name, which is the audit table of the table
Autokey automatic number field Definition
Language language table, which defines the languages of different countries
Maxvars Maximo system variable default value table
Synonymdomain system synonym domain
Definition of maxdomain domain or value set
Alndomain letter/digit type Domain value definition
Maxtabledomain table domain Type Definition
Numrangedomain value range field
Numericdomain numeric domain
Maxvartype identifies the maxvar domain
Multi-key foreign key property ing used by maxlookupmap for query
Table of crossoverdomain user database cross Fields
Sequence definitions used in maxsequence tables

Organization definition
Address: Organization address list
Site organization location Definition
Maxuser Maximo User table
Person personnel table
Labor employee table
Laborauth employee authorization table
Maxapps Maximo module definition
Maxobject Maximo object, table or attempt
Operation Function list of the sigoption Module
Bookmark bookmarks
Locations location table
Sctemplate launch center Template
Groupuser defines the group to which the user belongs

Query query saved by the user
Defaultquery
User session records logged on to maxsession System
Siteauth user group location authorization
Applicationauth user group application authorization
Grouprestriction user group data authorization (Restrictions)
Maxgroup user permission Group
Passwordhistory user password change history
Maxuserstatus user status table
Logintracking User Logon tracking table
Sets record

Failurecode fault code table
Locationspec location technical parameter Template
Lochierarchy location hierarchy, which records the father of each location
Locstatus Location status table
The locancestor location ancestor table, which records all the ancestors of each location.
Locsystem location system definition
Locations location table
Locoper Functional Location Information table

Assetattribute device public technical parameter field Definition
Classspec technical parameters for each type of device
Doctypes attachment Document Type
Docinfo
Doclinks
Dmsapisetting
Appdoctype application contains document types
Companies company table
Failurecode fault code list (including symptoms, causes, and measures)
Failurelist fault code hierarchy
Maxservice System Service
Maxobject System Object
Maxobjectcfg System Object configuration, Business Objects and services corresponding to objects
Maxattribute System Object field Definition
Field definitions of maxattributecfg System Objects
Maxtable system table object
Maxtablecfg system table object
Maxview system view object
Maxviewcolumn system view object field
Maxviewcolumncfg system view object field
Maxviewcfg System View Definition
Maxsysindexes system index Definition
Maxsyskeys system keyword segment Definition
Maxrelationship system table Association Registration
Maxdomain System domain registration

Status definition in action Workflow
Actiongroup
Maxmodules system module table
Maxmenu System menu structure
Paletteitem System Control Element Definition

Assethierarchy device level (seems useless)
Assethistory Device history
The instrument associated with the assetmeter Device
Assetstatus device status
Measurepoint