
VMware, Inc. 29
Chapter 4 ADM ERD Schema
Address
Addresstablecontainsinformationaboutanetworkelementconsistingofthehostname,IPaddress,and
MACaddress.Table 4‐1liststhecontentsoftheAddresstable.
Change_Log
Change_Logtablecapturesthechangestoentitydata.Table 4‐2liststhecontentsoftheChange_Logtable.
CPU
CPUtablecontainstheprocessorinformationforanetworkelement.Theinformationisidenticaltothe
informationinthenetworkelementtableunlessthemachinehasmultipletypesofprocessors.Table 4‐3lists
thecontentsoftheCPUtable.
Table 4-1. Address Table
Name Datatype Description
ID NUMBER(19) Uniqueidentifier
foreachrecordofthe
Addresstable(primarykey)
NE_ID NUMBER(19) Networkelementidentifier(foreignkey)
NIC_ID NUMBER(19) Networkinterfaceidentifier(foreignkey)
MAC VARCHAR2(100) MACaddress
IP VARCHAR2(100) IPaddress
HOSTNAME VARCHAR2(1024) Hostname
Table 4-2. Change_Log Table
Name Datatype Description
ID NUMBER(19) Uniqueidentifier
foreachrecordofthe
Change_Logtable(primarykey)
ENTITY_ID NUMBER(19) Networkelementidentifier(foreignkey)
CHANGE_TIME TIMESTAMP(6) Timeofchange
CHANGE_TYPE VARCHAR2(10) Typeofchange(Added,Modified,Removed)
PATH VARCHAR(22048) Pathtothechangeddata
DISPLAY_NAME VARCHAR2(255) Nameofthedatapropertychanged
OLD_VALUE VARCHAR2(1024) Oldvalue
NEW_VALUE VARCHAR2(1024) Newvalue
Table 4-3. CPU Table
Name Datatype Description
ID NUMBER(19) Uniqueidentifier
foreachrecordoftheCPU
table(primarykey)
NE_ID NUMBER(19) Networkelementidentifier(foreignkey)
MODEL VARCHAR2(256) Processormodel
VENDOR VARCHAR2(256) Processorvendor
FAMILY VARCHAR2(256) Processorfamily
CLOCK_SPEED_HZ NUMBER(19) MaxclockspeedinHertz
CACHE_SIZE NUMBER(19) CachesizeinBytes
STEPPING VARCHAR2(256) Processorversion
Commentaires sur ces manuels