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

Brocade Network Advisor IP User Manual 1533
53-1002947-01
Database tables and fields
I
SMART_CARD_ID Foreign key reference to the SMART_CARD that is
registered as a recovery card for the encryption
group. int
POSITION_ The position of the card within the recovery card set.
1 = first card, 2 = second card, etc. int
TABLE 363 REPORT_TYPE
Field Definition Format Size
ID* Meta Data for available reports. int
NAME Report name. varchar 128
DESCRIPTION Report type description. varchar 256
TABLE 364 REPORT_TEMPLATE
Field Definition Format Size
ID The primary key of the table. int
NAME Name of the report and the report names must be
descriptive. For example, Wired Device Report. varchar 256
TITLE The title of the report that briefly describes the report
contents. This title will also be used for the report
header and menu item. Title should be unique. For
example, Wired Products List. varchar 256
CREATED_TIME Timestamp of when the report was created. timestamp
CREATED_BY Foreign key to the user table, to identify which user
created the report. int
REPORT_TYPE 0 = Precanned template which will not be deleted or
edited, 1 = Editable report which can be deleted as
well, 2 = Not Editable report but can be deleted. int
REPORT_DEFINITION XML representation of the report. text
TABLE 365 REPORT_DRILLDOWN_TEMPLATE
Field Definition Format Size
ID* The primary key of the table. int
REPORT_TEMPLATE_ID References the ID column in the REPORT_TEMPLATE
table. int
NAME Name of the report. Names should be descriptive so
users will know exactly what kind of report they will be
running or scheduling. E.g. Wired Device Report. varchar 256
REPORT_DRILLDOWN_DEFI
NITION XML representation of the report. text
TABLE 362 RECOVERY_CARD_GROUP_MAPPING (Continued)
Field Definition Format Size