Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

Brocade Network Advisor SAN User Manual 1195
53-1002167-01
Views
E
name_key character varying(64) NOT NULL,
device_config_id integer NOT NULL,
value_str bytea NOT NULL,
line_num smallint NOT NULL,
key1 smallint,
key2 smallint,
ref_table_name character varying(64),
table_id integer,
table_subtype character varying(32) NOT NULL,
type_key character varying(32)
);
-- Name: device_deployment_job; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE device_deployment_job (
device_config_id integer NOT NULL,
device_deployment_job_id integer NOT NULL,
deployment_execution_id integer NOT NULL,
device_id integer NOT NULL,
status character(1) NOT NULL,
error_code numeric(6,0),
error_msg character varying(8192)
);
-- Name: device_group; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE device_group (
device_group_id integer NOT NULL,
name character varying(128) NOT NULL,
user_id integer NOT NULL,
description character varying(255),
is_public numeric(1,0),
is_internal numeric(1,0),
table_subtype character varying(32) NOT NULL,
is_ap_group numeric(1,0) DEFAULT 0 NOT NULL,
is_sensor_group numeric(1,0) DEFAULT 0 NOT NULL,
view_mask numeric(1,0),
GROUP_TYPE integer default 0 not null
);
-- Name: device_group_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE device_group_entry (
device_group_id integer NOT NULL,
device_group_entry_id integer NOT NULL,
device_id integer NOT NULL
);
-- Name: device_status; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE device_status (
device_status_id integer NOT NULL,
device_id integer NOT NULL,
group_id integer,
state_id integer NOT NULL,
last_updated bigint NOT NULL
);
-- Name: discovery_cycle; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE discovery_cycle (
discovery_cycle_id integer NOT NULL,
discovery_profile_id integer NOT NULL,