
VMware, Inc. 31
Chapter 4 ADM ERD Schema
Group_Membership
ThegroupswithinADMcontainentitiesasmembers.Group_Membershiptableidentifiesanentity(network
element,service,dependency)asamemberofagroup.Table 4‐6liststhecontentsoftheGroup_Membership
table.
SRC_NE_ID NUMBER(19) Sourcenetworkelementidentifier(foreignkey)
SRC_SERVICE_ID NUMBER(19) Sourceserviceidentifier(foreignkey)
SRC_MODULE_ID NUMBER(19) Sourcemoduleidentifier(java_ee,database),usually
ofadocumenteddependency
(foreignkey)
TRG_IP VARCHAR2(100) TargetIPaddressofthedependency
TRG_PORT NUMBER(19) Targetportofthedependency
TRG_SERVICE_NAME VARCHAR2(1024) Targetservicename
TRG_PRIMARY_HOSTNAME VARCHAR2(1024) Targetprimaryhostname(seeNetworkElement
table)
TRG_PRIMARY_HOST_IP VARCHAR2(100) TargetprimaryIPaddress(seeNetworkElement
table)
TRG_HOSTNAMES VARCHAR2(4000) Targethostnames(seeNetworkElementtable)
TRG_HOST_IPS VARCHAR2(4000) TargetIPaddresses(seeNetworkElementtable)
TRG_NE_ID NUMBER(19) Targetnetworkelementidentifier
TRG_SERVICE_ID NUMBER(19) Targetserviceidentifier
TRG_MODULE_ID NUMBER(19) Targetmodule(java_ee,database),
usuallyofa
documenteddependency
GROUPS VARCHAR2(4000) Comma‐separatedlistofallgroupstheelement
belongsto
DISCOVERY_TIME TIMESTAMP(6) Timetheelementwasfirstaddedtothesystem
KNOWLEDGE_LEVEL NUMBER(10) Indicatesthelevelofknowledgeofthedependency.
Valueofzeroindicatesspeculativeinformationonly
(usedtofilteroutspeculativeinformation)
Table 4-5. Dependency Table (Continued)
Name Datatype Description
Table 4-6. Group_Membership Table
Name Datatype Description
ID NUMBER(19) Groupidentifierisuniquetogroupsbutnot
toentitymemberships(primarykey)
GROUP_TYPE VARCHAR2(255) Grouptype
GROUP_NAME VARCHAR2(255) Groupname
GROUP_DESCRIPTION VARCHAR2(1024) Groupdescription
GROUP_CREATION_TIME TIMESTAMP(6) Groupcreationtime
GROUP_CREATOR VARCHAR2(255) Groupcreatorusername
GROUP_MODIFICATION_TIME TIMESTAMP(6) Grouplastmodificationtime
GROUP_MODIFIER VARCHAR2(255) Grouplastmodifierusername
ENTITY_ID NUMBER(19) Thedatacontainsforeignkeytoentitytypes:
NetworkElement,Service,Dependency
Komentáře k této Příručce