beautypg.com

Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2363

background image

Brocade Network Advisor SAN + IP User Manual

2291

53-1003155-01

Database tables and fields

I

PRODUCT_ID

This record will be per product. Hence this will
have the id of the product.

int

PRODUCT_TYPE_ID

Foreign Key references TARGET_TYPE(id). This
identifies the PRODUCT_ID. (Whether it is
switch, device, etc).

int

STATUS

Indicated the product deployment status
1-Aborted
2-Succesful
3-Partial Failure
4-Failed

smallint

MESSAGE

Message to be displayed in the report.

txt

ERROR_CODE

Error code, can be used for i18n

int

TABLE 91

DEPLOYMENT_REPORT_TEMPLATE

Field

Definition

Format

Size

DEPLOYMENT_HANDLER_ID

Foreign Key references
DEPLOYMENT_HANDLER(id).

int

HEADER

Stores header content of deployment report. This
could be plain text or HTML or XML

text

FOOTER

Stores the footer content of deployment report.
This could be plain text or HTML or XML.

text

TABLE 92

DEPLOYMENT_STATUS

Field

Definition

Format

Size

ID

Unique generated database identifier.

serial

DEPLOYMENT_CONFIGU
RATION_ID

Foreign Key References
DEPLOYMENT_CONFIGURATION(id).
Identifies the deployment configuration

int

DEPLOYMENT_TIME

Start Time of the deployment (UTC)

timestamp with time zone

STATUS

Overall status of the deployment.
1-In Progress
2-Success
3-Failure
4-Partially failed

smallint

DEPLOYED_BY

User who deployed the configuration

varchar

255

STATUS_MESSAGE

Overall Success/Failure status description

txt

TRIGGER_SOURCE

Maintains the source from which this
deployment was triggered such as Event Action
, Manual and Scheduled
etc.

varchar

128

TABLE 90

DEPLOYMENT_PRODUCT_STATUS (Continued)

Field

Definition

Format

Size