Brocade Communications Systems IP250 user manual Availableflyoverproperty, Birtreportparameter

				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			varchar	40
		flyover display.
TYPE		Indicates the flyover property type. Product property			smallint
		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.
DEFAULT_SELECTION		Value 1 in the column indicates default selected			smallint
		product/connection property and 0 indicates not
		included in the default list.
TABLE 34	BIRTREPORT_PARAMETER
Field		Definition			Format	Size
ID		The primary key of the table.			int
RUN_ID		References the ID column in the			int
		BIRTREPORT_RUN_TEMPLATE table.
PARAMETER-TYPE		Control type of the parameter.			int
		•	1	- Text Box
		•	2	- List Box
		•	3	- Radio Button
PARAMETER_NAME		Name of the parameter in the report template design.			varchar	128
PROMPT_TEXT		Text Label for the parameter. This value will be			varchar	256
		displayed on the GUI.
DATA_TYPE		Data type of the parameter. Possible values are:			int
		•	1	- String
		•	2	- Float
		•	3	- Decimal
		•	4	- Date and Time
		•	5	- Boolean
		•	6	- Integer
		•	7	- Date
		•	8	- Time
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			int
		BIRTREPORT_SCHEDULE_CONFIG table.

Brocade Network Advisor IP User Manual	1375
53-1003056-01