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

1186 Brocade Network Advisor SAN User Manual
53-1002167-01
Views
E
-- Name: address_spec; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE address_spec (
address_spec_id integer NOT NULL,
table_subtype character varying(32) NOT NULL
);
-- Name: alert; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE alert (
alert_id integer NOT NULL,
name character varying(32) NOT NULL,
user_id integer NOT NULL,
description character varying(255),
status character(1),
props_str character varying(2048),
last_updated bigint,
severity smallint,
event_type character(2),
messages character varying(255),
actions integer
);
-- Name: ap; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE ap (
device_id integer NOT NULL,
is_rogue numeric(1,0),
is_known numeric(1,0),
is_managed numeric(1,0),
is_online numeric(1,0),
is_relief numeric(1,0),
nearby_sensor_device_id integer,
ap_relief_status character varying(20),
rssi integer,
num_clients integer,
is_suppressing numeric(1,0)
);
-- Name: ap_adc_config_per_fes; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE ap_adc_config_per_fes (
ap_adc_config_per_fes_id integer NOT NULL,
device_id integer NOT NULL,
scenario_id integer DEFAULT 2 NOT NULL,
ip_address_pool character varying(4096),
other character varying(1024)
);
-- Name: ap_block_mac_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE ap_block_mac_entry (
ap_block_mac_entry_id integer NOT NULL,
block_mac_list_id integer,
device_id integer
);
-- Name: ap_ids; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE ap_ids (
sqnum integer NOT NULL,
time_stamp bigint,
device_id integer NOT NULL,