
VMware, Inc. 37
Chapter 4 ADM ERD Schema
Switch_Address_Forwarding
Switch_Address_Forwardingtablecontainsaddressforwardinginformationofaswitch(layer2).Table 4‐16
liststhecontentsoftheSwitch_Address_Forwardingtable.
Time
Timetablecontainsthetimeinformation.Table 4‐17liststhecontentsoftheTimetable.
LABEL VARCHAR2(256) Labelassignedtothevolume
DESCRIPTION VARCHAR2(256) Descriptionofthestoragedevice
DEVICE_TYPE VARCHAR2(256) Typeofstoragedevice(forexample,CD‐ROM,
removabledisc,andsoon)
CAPACITY NUMBER(19) SizeofthestoragedeviceinBytes
FILE_SYSTEM VARCHAR2(256) Filesystemtype(forexample,NTFS,CDFS,
andsoon)
MOUNT_DESTINATION VARCHAR2(256) Nameofthemountdestinationmachine
MOUNT_POINT VARCHAR2(256) Pathofthemountmachine
Table 4-15. Storage_Device Table (Continued)
Name Datatype Description
Table 4-16. Switch_Address_Forwarding Table
Name Datatype Description
ID NUMBER(19) Uniqueidentifierforeachrecordofthe
Switch_Address_Forwardingtable(primarykey)
NE_ID NUMBER(19) Networkelementidentifier
(foreignkey)
NIC_ID NUMBER(19) Networkinterfaceidentifier(foreignkey)
MODULE VARCHAR2(256) Switchmodule
PORT VARCHAR2(256) Switchport
MAC VARCHAR2(100) ForwardMACaddress
V_LAN NUMBER(10) VirtualLAN
TRG_NE_ID NUMBER(19) Forwardnetworkelementidentifier
(foreignkey)
Table 4-17. Time Table
Name Datatype Description
TIME_ID NUMBER(19) Humanreadablenumber:YYYYMMDDHH
(primarykey)
YEAR NUMBER(10) Year(YYYY)
QUARTER NUMBER(10) Quarter(1‐4)
QUARTER_NAME VARCHAR2(50) Quartername(Q1‐2008)
MONTH NUMBER(10) Monthnumber(1‐12)
MONTH_NAME VARCHAR2(50) Monthname(January‐December)
DAY_OF_MONTH NUMBER(10) Dayofthemonth(1‐31)
DAY_OF_WEEK NUMBER(10) Dayoftheweek(1‐7)
DAY_OF_WEEK_NAME VARCHAR2(50) Day(Sunday‐Saturday)
WEEK_OF_YEAR NUMBER(10) Weekoftheyear(1‐52)
HOUR NUMBER(10) Houroftheday(0‐23)
Kommentare zu diesen Handbüchern