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

Brocade Network Advisor SAN User Manual 1219
53-1002167-01
Views
E
);
-- Name: service_group_spec; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE service_group_spec (
port_spec_id integer NOT NULL,
service_group_id integer
);
-- Name: service_name_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE service_name_entry (
service_name_entry_id integer NOT NULL,
service_group_id integer NOT NULL,
service_port_definition_id integer NOT NULL,
name character varying(32)
);
-- Name: service_port_definition; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE service_port_definition (
service_port_definition_id integer NOT NULL,
port_num numeric(6,0),
name character varying(32) NOT NULL,
protocol numeric(4,0) DEFAULT 0 NOT NULL,
is_user_defined numeric(1,0)
);
-- Name: service_port_range_entry; Type: TABLE; Schema: dcm; Owner: dcmadmin;
Tablespace:
CREATE TABLE service_port_range_entry (
service_port_range_entry_id integer NOT NULL,
service_group_id integer NOT NULL,
port_num_low numeric(6,0),
port_num_high numeric(6,0)
);
create table SFLOW_STAGING
(
SLNUM bigserial not null,
TIME_IN_SECONDS integer not null,
DEVICE_ID integer not null,
IN_UNIT smallint default 0,
IN_SLOT smallint,
IN_PORT smallint,
OUT_UNIT smallint default 0,
OUT_SLOT smallint,
OUT_PORT smallint,
IN_VLAN smallint,
OUT_VLAN smallint,
IN_PRIORITY smallint,
OUT_PRIORITY smallint,
SRC_MAC bytea,
DEST_MAC bytea,
L3_SRC_ADDR bytea,
L3_DEST_ADDR bytea,
L3_PROTOCOL integer not null,
IP_TOS smallint,
L4_PROTOCOL smallint,
L4_SRC_PORT integer,