
VMware, Inc. 37
Chapter 4 ADM ERD Schema
Where:
IDisaPrimarykey
NE_IDandSERVICE_IDareForeignkeys
Property
Thistablecontainsgeneralpurposeproperties(name‐valuepairs),suchasURLsonhttp‐serversandtableson
database‐relateddependencies.Table 4‐13liststhecontentsofthePropertytable.
Where:
IDisaPrimarykey
ENTITY_IDisaForeignkey
Service
Thistablecontainsinformationofasoftwareservicerunningonthenetworkelement(usuallyexposed
throughanetworkport).Table 4‐14liststhecontentsoftheServicetable.
Table 4-13. Property Table
Name Datatype Description
ID NUMBER(19) UniqueIdentifier
ENTITY_ID NUMBER(19) Networkelement,service,dependency
NAME VARCHAR2(256)
VALUE VARCHAR2(1028)
Table 4-14. Service Table
Name Datatype Description
ID NUMBER(19) Uniqueidentifier.
NAME VARCHAR2(1024) Servicenameifknown(nullifunknown).
NE_ID NUMBER(19) Foreignkeytothenetwork‐elementcontaining
theservice.
PRIMARY_HOSTNAME VARCHAR2(1024) Primaryhostnameofthecontaininghost(see
networkelement).
PRIMARY_HOST_IP VARCHAR2(100) PrimaryIPaddressofthecontaininghost(see
networkelement).
HOSTNAMES VARCHAR2(4000) Hostnameslistofthecontaininghost(see
networkelement).
HOST_IPS VARCHAR2(4000) IPlistofthecontaining
host(seenetwork
element).
PORTS VARCHAR2(4000) Portswhichtheserviceisconsumedby
GROUPS VARCHAR2(4000) Comma‐separatedlistofallgroupstheelement
belongsto.
DISCOVERY_TIME TIMESTAMP Timetheelementwasfirstintroducedtothe
system.
VENDOR VARCHAR2(1024) Vendoroftheservice.
VERSION VARCHAR2(1024) Versionoftheservice.
CATEGORY VARCHAR2(100) Categoryoftheservice.
TIER VARCHAR2(100) T ieroftheservice.
INSTALL_PATH VARCHAR2(512) Installationpath.
Comentários a estes Manuais