User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1517
53-1003153-01
Database tables and fields
I
TABLE 33 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 34 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
DATA_TYPE Data type of the parameter. Possible values are:
• 1 - String
• 2 - Float
• 3 - Decimal
• 4 - Date and Time
• 5 - Boolean
• 6 - Integer
• 7 - Date
• 8 - Time
int
PARAMETER_VALUE Value of the Parameter. varchar 256
TABLE 35 BIRTREPORT_RUN_TEMPLATE
Field Definition Format Size
ID The primary key of the table. int
SCHEDULE_ID References the ID column in the
BIRTREPORT_SCHEDULE_CONFIG table.
int