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

1196 Brocade Network Advisor SAN User Manual
53-1002167-01
Views
E
start_time numeric(20,0) NOT NULL,
duration integer
);
-- Name: discovery_log; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE discovery_log (
discovery_log_id integer NOT NULL,
discovery_cycle_id integer NOT NULL,
"timestamp" numeric(20,0),
category smallint,
device_ip character varying(40),
messages character varying(4096)
);
-- Name: discovery_profile; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE discovery_profile (
discovery_profile_id integer NOT NULL,
discovery_profile_name character varying(255) NOT NULL
);
-- Name: discovery_profile_detail; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE discovery_profile_detail (
discovery_profile_detail_id integer NOT NULL,
discovery_profile_id integer NOT NULL,
property_key character varying(255) NOT NULL,
property_value character varying(512) NOT NULL
);
-- Name: ethernet_interface; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE ethernet_interface (
interface_id integer NOT NULL
);
-- Name: events_main; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE events_main (
messages_id integer,
trap_log_id integer NOT NULL,
trap_sender character varying(40) NOT NULL,
"timestamp" bigint,
severity smallint,
is_ack numeric(1,0),
log_type character(1),
slot smallint,
port smallint,
device_id integer,
event_action_id integer,
device_group_id integer,
port_group_id integer,
trap_device_ip character varying(40),
log_sub_type character(1),
unit smallint
);
-- Name: events_messages; Type: TABLE; Schema: dcm; Owner: dcmadmin; Tablespace:
CREATE TABLE events_messages (
messages character varying(512) NOT NULL,
messages_id integer NOT NULL
);