Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
34
Tablespace: BASE_DATA_TABLESPACE
Table 1-16: Bridge_Group_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
TopoNodeID
NUMBER(10)
NOT NULL
Node ID of the circuit’s source node.
TopoUniqueId
NUMBER(10)
NOT NULL
Unique number within the node.
Vlan_Number
NUMBER(10)
NOT NULL
Unique number to identify the VLAN.
NEID
NUMBER(10)
NOT NULL
NE ID.
Slot_Number
NUMBER(3)
NOT NULL
Slot number.
Bridge_Group_Number NUMBER(3)
NOT NULL
Bridge group number.
BRIDGE_PROTOCOL
VARCHAR2(30) —
—
1.1.18 Cerent_NE_Group_Table
The Cerent_NE_Group_Table indicates how the CTC-based NEs' discovered NEs are
grouped based on the grouping rule.
grouped based on the grouping rule.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-17: Cerent_NE_Group_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
NE database access ID.
GroupOption
NUMBER(4)
DEFAULT 0
Values are:
0: Default grouping
1: Group by discovered NE
2: Group by subnet
0: Default grouping
1: Group by discovered NE
2: Group by subnet
1.1.19 Circuit_BS_Tbl
The Circuit_BS_Tbl stores basic information about the circuit. .
Primary key: CIRCUIT_BS_TBL_PK
Tablespace: BASE_DATA_TABLESPACE
For medium, large, and high-end configurations, this table is partitioned.