Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1466)

1412 Brocade Network Advisor IP User Manual
53-1002947-01
Database tables and fields
I
TABLE 110 AOR_HOST_MAP
Field Definition Format Size
AOR_ID ID of AOR int
HOST_ID HOST ID which is in the AOR int
TABLE 111 AOR_INM_PORT_GROUP_MAP
Field Definition Format Size
AOR_ID ID of AOR int
PORT_GROUP_ID IP of port group int
TABLE 112 AOR_VIP_SERVER_MAP
Field Definition Format Size
AOR_ID The column holds ID of an AOR. It is Foreign Key and
refers to ID column of AOR table int
VIP_SERVER_ID The column holds ID of VIP Server. It is Foreign Key
and refers to ID column of VIP_SERVER table int
TABLE 113 AVAILABLE_FLYOVER_PROPERTY
Field Definition Format Size
ID* Unique generated database identifier. int
NAME Name of the available property to be included in the
flyover display. varchar 40
TYPE Indicates the flyover property type. Product property
is 0, Connection property is 1, User Defined property
is 2, Cee Product property is 3, Cee Connection
property is 4, Host property is 5. smallint
DEFAULT_SELECTION Value 1 in the column indicates default selected
product/connection property and 0 indicates not
included in the default list. smallint
TABLE 114 BIRTREPORT_PARAMETER
Field Definition Format Size
ID The primary key of the table. int
RUN_ID References the ID column in the
BIRTREPORT_RUN_TEMPLATE table. int
PARAMETER-TYPE Control type of the parameter.
•
1 - Text Box
•
2 - List Box
•
3 - Radio Button
int
PARAMETER_NAME Name of the parameter in the report template design. varchar 128
PROMPT_TEXT Text Label for the parameter. This value will be
displayed on the GUI. varchar 256