//$Id: DatabaseAliases.conf,v 1.8 2007/01/03 11:00:43 zhoubin Exp $
# This file is to specify the aliases used in the particular databases for the
# column names . The column names of the various tables by default are the same
# as the field name in the respective object . But in databases which may treat
# some of these columnNames as reserved words or where there does not exist
# support for case sensitivity in column Names it becomes necessary to replace them
# with other words . This file helps specify those changes if any . It is to be noted
# that specifying in this file should be accompanied by the appropriate changes in
# the DatabaseSchema.conf file too . To illustrate this point see the two example
# files  DatabaseAliases.conf.example1  and DatabaseSchema.conf.example1 .
# You will notice that both these conf files are in agreement . That is when
# a column Name is given an alias it is taken care to specify the alias in the
# schema file while creating the database .

# The syntax of the file is as follows
# column name( as orginally designed       alias (the name which is assigned
# Note that in this file the quotes should not be specified but in DatabaseSchema.conf
# it is insisted that all columnNames be specified inside quotes

# For ease of use all the column Names which are used are given with details of
# which all tables they appear in .Note that no aliases have been assigned .
# Unless it is required to change to suit your database please do not assign
# any aliases .
# Please be very careful in editing this file as a wrong alias assigned here
# without appropriate changes in the Schema file will lead to a host of errors


# In Tables  ObjectTypes , ALERTUSERPROPS ,MAPUSERPROPS ,TOPOUSERPROPS and POLLUSERPROPS
objkey   OBJKEY  

# In Tables  ALERTUSERPROPS ,MAPUSERPROPS ,TOPOUSERPROPS and POLLUSERPROPS
propName     PROPNAME    
propVal   PROPVAL  

# In Tables  ObjectTypes, Reports and ManagedObject
classname  CLASSNAME 

# In Tables ManagedObject , TopoObject, Node, Network, IpAddress, SnmpInterface
# SnmpNode, GroupTable, MapSymbol, MapGroup, MapLink, PolledData, PollingObjects,PollingAttributes,ThresholdObjects, DataCollectionAttributes  and any other table
# that is created to store a user written sub-class of ManagedObject
name NAME

# ownerName is also in tables Event, Alert (in addition to the above tables).
ownerName OWNERNAME

# that is created to store a user written sub-class of ManagedObject
displayName DISPLAYNAME

# In the Tables ManagedObject 
managed MANAGED

# In the Table ManagedObject
type  TYPE 
failureThreshold FAILURETHRESHOLD
failureCount FAILURECOUNT
pollInterval POLLINTERVAL
statusChangeTime STATUSCHANGETIME
statusUpdateTime STATUSUPDATETIME
tester TESTER
uClass UCLASS
statusPollEnabled STATUSPOLLENABLED
isContainer ISCONTAINER
isGroup ISGROUP

# In the Tables ManagedObject and MapLink
status STATUS


# In the Tables ManagedObject, MapSymbol, MapGroup,  MapLink, Alert,  Event 
# and PolledData
webNMS WEBNMS
groupName GROUPNAME
parentName PARENTNAME
parentKey PARENTKEY



# In the table TopoObject
ipAddress  IPADDRESS 
netmask  NETMASK 
writeCommunity  WRITECOMMUNITY 
snmpport  SNMPPORT 
baseMibs  BASEMIBS 
isDHCP  ISDHCP 
version VERSION
userName USERNAME
contextName CONTEXTNAME
isSNMP ISSNMP
isNode ISNODE
isNetwork ISNETWORK
isInterface ISINTERFACE

# In the Tables TopoObject  and PolledData
community  COMMUNITY 

# In the Table Node
isRouter ISROUTER

# In the Table Network
discoveryStatus DISCOVERYSTATUS
parentNetwork PARENTNETWORK
parentNetmask PARENTNETMASK
# In the Tables Network
discover  DISCOVER 

# In the Table IpAddress
parentNode  PARENTNODE 
parentNet  PARENTNET 

# In the Table SnmpNode 
sysDescr  SYSDESCR 
sysName  SYSNAME 


# In the Tables SnmpNode and SnmpInterface
hostNetmask  HOSTNETMASK 
sysOID  SYSOID 

# In the Table SnmpInterface 
ifIndex  IFINDEX 
physMedia  PHYSMEDIA 
physAddr  PHYSADDR 
ifSpeed  IFSPEED 
ifDescr  IFDESCR 

#In Table TL1Node
loginCommand  LOGINCOMMAND
initCommand  INITCOMMAND
connectionHandler  CONNECTIONHANDLER
infoCommand  INFOCOMMAND
dictionary  DICTIONARY
sessionId  SESSIONID
tl1port  TL1PORT
notifyId  NOTIFYID

#In Table TL1Interface
statpollCommand  STATPOLLCOMMAND
connectionHandler  CONNECTIONHANDLER
dictionary  DICTIONARY
sessionId  SESSIONID
tl1port  TL1PORT

# In the Table GroupTable
memberName MEMBERNAME
memberOwnerName MEMBEROWNERNAME

# In the Tables ANNOTATION and Alert
who  WHO 
modTime      MODTIME     
notes  NOTES 

# In the Tables Alert ,PolledData and Event
id ID

# In the Tables Alert and Event
entity  ENTITY 
severity  SEVERITY 

# In the Tables Alert,MapLink, and Event
source SOURCE

# In the Tables Alert ,Event and ThresholdEvents
category  CATEGORY 

# In the Tables Alert and PolledData
previousSeverity  PREVIOUSSEVERITY 
message  MMESSAGE 

# In the Table Alert
createTime  CREATETIME 
stage  STAGE 
priority PRIORITY

# In the Tables MapGroup, MapSymbol and MapLink
label  LABEL 
menuName  MENUNAME

# In the Tables  MapGroup, MapSymbol and MapLink
mapName MAPNAME
x X
y Y
anchored ANCHORED

# In the Tables MapGroup, MapSymbol and MapLink
objName   OBJNAME  

# In the Table  MapGroup, MapSymbol
iconName  ICONNAME 
width  WIDTH 
height  HEIGHT 

# In the Table MapSymbol,MapGroup
objType 	 OBJTYPE 	

# In the Table MapLink 
dest  DEST 
thickness  THICKNESS 
linkType  LINKTYPE 
nx  NX 
ny  NY 

# In the Tables Event and StatsData
time  TTIME 

# In the Table Event
text  TEXT 
domain  DDOMAIN 
network  NETWORK 
node  NODE 
helpURL  HELPURL 


# In the Table PolledData
agent  AGENT 
period  PERIOD 
active  ACTIVE 
oid  OID 
logDirectly  LOGDIRECTLY 
logFile  LOGFILE 
save  SSAVE 
threshold  THRESHOLD 
isMultiplePolledData  ISMULTIPLEPOLLEDDATA 
numericType  NUMERICTYPE 
saveAbsolutes  SAVEABSOLUTES 
timeAvg  TIMEAVG 
port  PORT 
lastCounterValue LASTCOUNTERVALUE
lastTimeValue LASTTIMEVALUE
timeVal TIMEVAL
policyName POLICYNAME
dnsName DNSNAME
statsDataTableName STATSDATATABLENAME
suffix SUFFIX
thresholdList THRESHOLDLIST
pollerName POLLERNAME
failureCount FAILURECOUNT
failureThreshold FAILURETHRESHOLD
parentObj PARENTOBJ
protocol PROTOCOL
savePollCount SAVEPOLLCOUNT
currentSaveCount CURRENTSAVECOUNT
saveOnThreshold SAVEONTHRESHOLD
snmpVersion SNMPVERSION
userName USERNAME
contextName CONTEXTNAME

# In the Table MapContainer

currentTopology CURRENTTOPOLOGY
topology TOPOLOGY
containment	CONTAINMENT		


# In the Table MapDB

parentMapKey PARENT
mapListener MAPLISTENER
mapSymbolRenderer MAPSYMBOLRENDERER
mapLinkRenderer MAPLINKRENDERER
helpDoc HELPDOC
treeIconFileName TREEICONFILENAME
autoPlacement AUTOPLACEMENT
imageName IMAGENAME


# In the table PollingAttributes

type TYPE
condition CONDITION
property PROPERTY 
value VALUE


# In the table ThresholdObjects

kind KIND
severity SEVERITY
triggerSeverity TRIGGERSEVERITY
resetSeverity RESETSEVERITY
thresholdType THRESHOLDTYPE
category CATEGORY
thresholdValue THRESHOLDVALUE
rearmValue REARMVALUE
message MMESSAGE
clrMessage CLEARMESSAGE
sendClear SENDCLEAR
allowed ALLOWED
disallowed DISALLOWED
oid OID
oidType OIDTYPE

# In the table Providers

providerName PROVIDERNAME
value VALUE

# In the Tables TrapFilter
enterpriseOID ENTERPRISEOID
gt GT
st ST
trapOID TRAPOID
state STATE

# In the Tables TrapParser ,EventParser ,EventAlertFilter, DateCollectionAttributes
propKey PROPKEY
propValue PROPVALUE

# In the Tables EventAlertFilter
filterName FILTERNAME
actionName ACTIONNAME

#In the table Reports
daily DAILY
weekly WEEKLY
monthDays MONTHDAYS
weekDays WEEKDAYS
hour HOUR
timeVal TIMEVAL

# In the Table PolicyObject
groupName	GROUPNAME
status	STATUS
policyObjectCustomizer	POLICYOBJECTCUSTOMIZER
helpURL	HELPURL

#In Table SwitchObject
rootPort  ROOTPORT
rootCost  ROOTCOST
numPorts  NUMPORTS

#In Table PortObject
portIfIndex  PORTIFINDEX
portIfDescr  PORTIFDESCR
portState  PORTSTATE
portIfSpeed  PORTIFSPEED

#In Table Printer
deviceStatus  DEVICESTATUS
printerStatus  PRINTERSTATUS
printerDetectedErrStatus  PRINTERDETECTEDERRSTATUS
consoleDispBufferText  CONSOLEDISPBUFFERTEXT

#In Table AgentDefValObject
name NAME
value  VALUE 

#In Table PolicyScheduleTime
timeKey  TIMEKEY

#In Table TaskAudit
executionID  EXECUTIONID

taskName  TASKNAME

deviceList  DEVICELIST

datasource  DATASOURCE

executedTime  EXECUTEDTIME

subTaskName  SUBTASKNAME

deviceName  DEVICENAME

timeOfStart  TIMEOFSTART

timeOfFinish  TIMEOFFINISH

rollbackStatus  ROLLBACKSTATUS

#In Table AttributeAudit
identifier  IDENTIFIER

retries  RETRIES

#In Table CORBANode
orbClassName  ORBCLASSNAME

#In Table CORBANode
nameServiceHost  NAMESERVICEHOST

nameServicePort  NAMESERVICEPORT

nameRef  NAMEREF

interfaceName  INTERFACENAME

statusPollCommand  STATUSPOLLCOMMAND

statusPollIOR  STATUSPOLLIOR

dataPollIOR  DATAPOLLIOR

#In Table NotificationLog
notiIndex  NOTIINDEX

#In Table NotificationLog
logTime  LOGTIME

#In Table NotificationLog
noVarBinds  NOVARBINDS

#In Table NotificationLog
notiOID  NOTIOID

#In Table VarBindLog
varIndex  VARINDEX

#In Table VarBindLog
varType  VARTYPE

#In Table VarBindLog
varValue  VARVALUE

lastModifiedTime  LASTMODIFIEDTIME

model  MODEL

contact  CONTACT

managedObjectName  MANAGEDOBJECTNAME

operationalStatus  OPERATIONALSTATUS

location  LOCATION

adminStatus  ADMINSTATUS

vendor  VENDOR

description  DESCRIPTION

variantId  VARIANTID

mapName   MAPNAME
#In Table AuthAuditExt
authAuditId AUTHAUDITID
module MODULE
auditTime AUDITTIME
auditedObj AUDITEDOBJ
operation OPERATION

#In Table MapLocation
fullLocationName  FULLLOCATIONNAME
contactPersonTelephone  CONTACTPERSONTELEPHONE
contactPersonName  CONTACTPERSONNAME
contactPersonEmail  CONTACTPERSONEMAIL
comment  COMMENT
contactPersonMobile  CONTACTPERSONMOBILE

#In Table IPDSLAMDevice
deviceType  DEVICETYPE

#In Table DslamAlarm
alarmSeverity  ALARMSEVERITY
portIndex  PORTINDEX
plannedVenderType  PLANNEDVENDERTYPE
alarmList  ALARMLIST
onlineVenderType  ONLINEVENDERTYPE
shelfIndex  SHELFINDEX
physicalIndex  PHYSICALINDEX
alarmLastChange  ALARMLASTCHANGE
slotIndex  SLOTINDEX



#In Table NEBackup
bkNEName  BKNENAME
fileName  FILENAME
moduleName  MODULENAME
backupTime  BACKUPTIME
parameters  PARAMETERS
description  DESCRIPTION

#In Table AlarmDefinition
name  NAME
venderType  VENDERTYPE
alarmType  ALARMTYPE
alarmName  ALARMNAME
alarmDescription  ALARMDESCRIPTION
alarmSeverity  ALARMSEVERITY
alarmFiltered  ALARMFILTERED
alarmSuppressedby  ALARMSUPPRESSEDBY

#In Table IPTrafficProfileTemplate
profileName  PROFILENAME
profileDsBcastFilter  PROFILEDSBCASTFILTER
profileUsRateLimit  PROFILEUSRATELIMIT
profileDsPriority  PROFILEDSPRIORITY
profileMaxDsRate  PROFILEMAXDSRATE

#In Table LineProfileTemplate
atucConfRateChanRatio  ATUCCONFRATECHANRATIO
aturConfMinUpshiftTime  ATURCONFMINUPSHIFTTIME
aturConfUpshiftSnrMgn  ATURCONFUPSHIFTSNRMGN
aturChanConfMaxInterleaveDelay  ATURCHANCONFMAXINTERLEAVEDELAY
atucConfMinUpshiftTime  ATUCCONFMINUPSHIFTTIME
cpeL3State  CPEL3STATE
aturChanConfInterleaveMinTxRate  ATURCHANCONFINTERLEAVEMINTXRATE
atucConfRateMode  ATUCCONFRATEMODE
aturConfTargetSnrMgn  ATURCONFTARGETSNRMGN
atucConfDownshiftSnrMgn  ATUCCONFDOWNSHIFTSNRMGN
aturChanConfInterleaveMaxTxRate  ATURCHANCONFINTERLEAVEMAXTXRATE
aturConfDownshiftSnrMgn  ATURCONFDOWNSHIFTSNRMGN
aturConfMinDownshiftTime  ATURCONFMINDOWNSHIFTTIME
aturConfMaxNominalPSD  ATURCONFMAXNOMINALPSD
aturMinINP  ATURMININP
atucChanConfFastMinTxRate  ATUCCHANCONFFASTMINTXRATE
profileName  PROFILENAME
aturConfRateMode  ATURCONFRATEMODE
aturChanConfFastMaxTxRate  ATURCHANCONFFASTMAXTXRATE
aturChanConfFastMinTxRate  ATURCHANCONFFASTMINTXRATE
atucConfUpshiftSnrMgn  ATUCCONFUPSHIFTSNRMGN
atucConfTargetSnrMgn  ATUCCONFTARGETSNRMGN
atucChanConfFastMaxTxRate  ATUCCHANCONFFASTMAXTXRATE
atucChanConfInterleaveMinTxRate  ATUCCHANCONFINTERLEAVEMINTXRATE
powerL2Time  POWERL2TIME
aturConfMaxSnrMgn  ATURCONFMAXSNRMGN
aturConfMinSnrMgn  ATURCONFMINSNRMGN
atucChanConfInterleaveMaxTxRate  ATUCCHANCONFINTERLEAVEMAXTXRATE
atucConfMinSnrMgn  ATUCCONFMINSNRMGN
atucConfMaxNominalPSD  ATUCCONFMAXNOMINALPSD
powerL2MaxRate  POWERL2MAXRATE
atucConfMaxSnrMgn  ATUCCONFMAXSNRMGN
atucChanConfMaxInterleaveDelay  ATUCCHANCONFMAXINTERLEAVEDELAY
confProfileLineType  CONFPROFILELINETYPE
powerMode  POWERMODE
aturConfRateChanRatio  ATURCONFRATECHANRATIO
powerL0Time  POWERL0TIME
atucConfMinDownshiftTime  ATUCCONFMINDOWNSHIFTTIME
atucMinINP  ATUCMININP
powerL2MinRate  POWERL2MINRATE

#In Table TrafficPolicingProfileTemplate
profileName  PROFILENAME
PIR  PIR
CIR  CIR
action  ACTION

#In Table MulticastProfileTemplate
profileID  PROFILEID
profileName  PROFILENAME
profileIPAddress  PROFILEIPADDRESS
profileRate  PROFILERATE
profilePriority  PROFILEPRIORITY

#In Table MulticastServiceProfileTemplate
profileName  PROFILENAME
profileBitMap  PROFILEBITMAP

#In Table PMProfileTemplate
profileName  PROFILENAME
atuc15MinES  ATUC15MINES
atuc15MinSES  ATUC15MINSES
atuc15MinUAS  ATUC15MINUAS
atuc1DayES  ATUC1DAYES
atuc1DaySES  ATUC1DAYSES
atuc1DayUAS  ATUC1DAYUAS
atur15MinES  ATUR15MINES
atur15MinSES  ATUR15MINSES
atur15MinUAS  ATUR15MINUAS
atur1DayES  ATUR1DAYES
atur1DaySES  ATUR1DAYSES
atur1DayUAS  ATUR1DAYUAS

#In Table AlarmDefinitionTemplate
deviceType  DEVICETYPE
venderType  VENDERTYPE
alarmType  ALARMTYPE
alarmName  ALARMNAME
alarmDescription  ALARMDESCRIPTION
alarmSeverity  ALARMSEVERITY
alarmFiltered  ALARMFILTERED
alarmSuppressedby  ALARMSUPPRESSEDBY

#In Table Subscriber
subsriberIP  SUBSRIBERIP
shelf  SHELF
slot  SLOT
port  PORT
subID  SUBID
subClass  SUBCLASS
email  EMAIL
tel  TEL
mobile  MOBILE
serviceType  SERVICETYPE
address  ADDRESS

#In Table SubscriberManagement
subID  SUBID
subName  SUBNAME
subTel  SUBTEL
subNEIP  SUBNEIP
subShelf  SUBSHELF
subSlot  SUBSLOT
subPort  SUBPORT

#In Table AutoSchedule
NEName  NENAME
module  MODULE
weekDay  WEEKDAY
hours  HOURS
minute  MINUTE
latestBackupTime  LATESTBACKUPTIME

#In Table SHDSLLineProfileTemplate
profileName  PROFILENAME
rateMode  RATEMODE
minRate  MINRATE
maxRate  MAXRATE
currentTargetMarginUp  CURRENTTARGETMARGINUP
worstTargetMarinUp  WORSTTARGETMARINUP
currentTargetMarginDown  CURRENTTARGETMARGINDOWN
worstTargetMarinDown  WORSTTARGETMARINDOWN
txMode  TXMODE
lineProbe  LINEPROBE
usedTargetMargins  USEDTARGETMARGINS
PSDMask  PSDMASK

#In Table SHDSLPMProfileTemplate
profileName  PROFILENAME
minSNRMargin  MINSNRMARGIN
maxLoopAttenuation  MAXLOOPATTENUATION
ES  ES
SES  SES
UAS  UAS
LOSWS  LOSWS
CRC  CRC

#In Table InventoryInserviceManagement
NEIP  NEIP
slot  SLOT
planCardType  PLANCARDTYPE
assginCardType  ASSGINCARDTYPE
status  STATUS
assginFrom  ASSGINFROM
assignCardNo  ASSIGNCARDNO
NEName  NENAME
location  LOCATION
deviceType  DEVICETYPE
onlineCardType  ONLINECARDTYPE
onlineCardNo  ONLINECARDNO

#In Table InventoryInstorageManagement
serialNo  SERIALNO
cardType  CARDTYPE
location  LOCATION
status  STATUS

#In Table AMAACL
deviceType  DEVICETYPE
name  NAME
bridgeId  BRIDGEID
macAddress  MACADDRESS

#In Table AMAIGMPSnooping
deviceType  DEVICETYPE
deviceName  DEVICENAME
bridgeId  BRIDGEID
leaveMode  LEAVEMODE
vpi  VPI
portIndex  PORTINDEX
vci  VCI
igmpStatus  IGMPSTATUS

#In Table AMAIndexEntry
neType  NETYPE
neName  NENAME
eoaAllIndex  EOAALLINDEX
aal5AllIndex  AAL5ALLINDEX
bridgeAllIndex  BRIDGEALLINDEX

#In Table AMAProfileTemplate
profileName  PROFILENAME
l2EntryRateMinTime  L2ENTRYRATEMINTIME
standard  STANDARD
aturDownTime  ATURDOWNTIME
lineType  LINETYPE
atucMinMargin  ATUCMINMARGIN
atucDownMargin  ATUCDOWNMARGIN
atucMaxMargin  ATUCMAXMARGIN
l2ATPR  L2ATPR
aturUpMargin  ATURUPMARGIN
atucMaxDelay  ATUCMAXDELAY
profileDescription  PROFILEDESCRIPTION
atucUpTime  ATUCUPTIME
dmtTrellisOp  DMTTRELLISOP
l2EntryThresholdRate  L2ENTRYTHRESHOLDRATE
atucDownTime  ATUCDOWNTIME
rateMode  RATEMODE
psdMaskType  PSDMASKTYPE
atucUpMargin  ATUCUPMARGIN
l2Time  L2TIME
aturMinTXRate  ATURMINTXRATE
dmtCfgMode  DMTCFGMODE
aturMaxTXRate  ATURMAXTXRATE
l2MinRate  L2MINRATE
aturMaxMargin  ATURMAXMARGIN
aturMinMargin  ATURMINMARGIN
aturDownMargin  ATURDOWNMARGIN
aturUpTime  ATURUPTIME
atucTargetMargin  ATUCTARGETMARGIN
aturTargetMargin  ATURTARGETMARGIN
atucMinTXRate  ATUCMINTXRATE
pmState  PMSTATE
aturMaxDelay  ATURMAXDELAY
l2ExitThresholdRate  L2EXITTHRESHOLDRATE
l0Time  L0TIME
atucMaxTXRate  ATUCMAXTXRATE

#In Table AMAPVC
neType  NETYPE
neName  NENAME
aal5IfIndex  AAL5IFINDEX
bridgeIndex  BRIDGEINDEX
status  STATUS
eoaIfIndex  EOAIFINDEX
vpi  VPI
portIndex  PORTINDEX
vci  VCI
encapType  ENCAPTYPE

#In Table AMAStaticVlan
deviceType  DEVICETYPE
deviceName  DEVICENAME
vlanIndex  VLANINDEX
vlanName  VLANNAME
forbiddenPorts  FORBIDDENPORTS
fullBridgeStatus  FULLBRIDGESTATUS
egressPorts  EGRESSPORTS
bcastSupportStatus  BCASTSUPPORTSTATUS
untaggedPorts  UNTAGGEDPORTS
floodSupportStatus  FLOODSUPPORTSTATUS

#In Table AMASystemTrap
deviceType  DEVICETYPE
deviceName  DEVICENAME
portId  PORTID
failTrap  FAILTRAP
linkTrap  LINKTRAP
powerTrap  POWERTRAP
opTrap  OPTRAP

#In Table AMAVlanGvrp
deviceType  DEVICETYPE
deviceName  DEVICENAME
bridgeId  BRIDGEID
portId  PORTID
vci  VCI
vpi  VPI
gvrpState  GVRPSTATE
lastPduOrigin  LASTPDUORIGIN
failedRegistrations  FAILEDREGISTRATIONS

#In Table AMAVlanPorts
deviceType  DEVICETYPE
deviceName  DEVICENAME
bridgeId  BRIDGEID
portId  PORTID
ingressFilter  INGRESSFILTER
frameType  FRAMETYPE
vpi  VPI
vci  VCI
pvid  PVID

#In Table AMAPVCRefresh
neType  NETYPE
neName  NENAME
tableName  TABLENAME
needRefresh  NEEDREFRESH

#In Table AMA1021SDProxyPort
neType  NETYPE
neName  NENAME
snmptftpProxy  SNMPTFTPPROXY
port  PORT

#In Table UserClientObject
clientSessionID  CLIENTSESSIONID
clientUserName  CLIENTUSERNAME
clientIPAddress  CLIENTIPADDRESS
clientLoginTime  CLIENTLOGINTIME