
VMware, Inc. 33
Chapter 4 ADM ERD Schema
Where:
ENTITY_IDisaForeignkey(network_element,service,dependency(id))
Installed_Software
Thistablecontainstheinformationofsoftwaresinstalledonanetworkelement.Thesoftwareinformation
mightalsoexistintheservicetable(installedsoftwarecanappearasbothinstalledsoftwareandasaservice
onthenetwork).Table 4‐7liststhecontentsoftheInstalled_Softwaretable.
.
Where:
IDisaPrimarykey
NE_IDisaForeignkey
IP_Route
ThistablecontainsIP(layer3)routinginformationofanetworkelement.Table 4‐8liststhecontentsofthe
IP_Routetable.
GROUP_DESCRIPTION VARCHAR2(1024) Groupdescription
GROUP_CREATION_TIME TIMESTAMP Creationtime
GROUP_CREATOR VARCHAR2(255) groupcreatorusername
GROUP_MODIFICATION_TIME TIMESTAMP Grouplastmodificationtime
GROUP_MODIFIER VARCHAR2(255) Grouplastmodifierusername
ENTITY_ID NUMBER(19) Memberentity
Table 4-6. Group_Membership Table (Continued)
Name Datatype Description
Table 4-7. Installed_Software Table
Name Datatype Description
ID NUMBER(19) Uniqueidentifier
NE_ID NUMBER(19) NetworkElement
NAME VARCHAR2(256) Softwarename
VERSION VARCHAR2(256)
RELEASE VARCHAR2(256)
VENDOR VARCHAR2(256)
INSTALL_PATH VARCHAR2(1024)
SHARED_INSTALL_PATH VARCHAR2(1024)
INSTALL_DATE TIMESTAMP
TYPE VARCHAR2(256) Typeofsoftware(application,driver,
patch)
Table 4-8. IP_Route Table
Name Datatype Description
ID NUMBER(19) UniqueIdentifier
NE_ID NUMBER(19) NetworkElement
NIC_ID NUMBER(19) NetworkInterface
DEST_IP VARCHAR2(100) DestinationIP
Comentários a estes Manuais