Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
33
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-14: BLSR_Span
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
BLSRID
NUMBER(8)
NOT NULL
BLSR ID.
RINGID
VARCHAR(8)
NOT NULL
Ring ID.
LINKID
NUMBER(8)
NOT NULL
Link ID.
WORKINGSPAN
NUMBER(1)
NOT NULL
Working span.
WESTNODEID
NUMBER(10)
NOT NULL
Node ID of the BLSR (west line).
EASTNODEID
NUMBER(10)
NOT NULL
Node ID of the BLSR (east line).
1.1.16 BLSR_Table
The BLSR_Table contains information about BLSRs.
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-15: BLSR_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
BLSRID
NUMBER(8)
NOT NULL
BLSR ID.
RINGID
VARCHAR(8)
NOT NULL
Ring ID.
RINGTYPE
NUMBER(2)
NOT NULL
Ring type.
LINERATE
NUMBER(2)
NOT NULL
Line rate.
STATUS
VARCHAR2(12)
NOT NULL
Ring status.
RINGREVERSION
NUMBER(8, 2)
NOT NULL
Ring reversion time.
SPANREVERSION
NUMBER(8, 2)
NOT NULL
Span reversion time.
NODES
VARCHAR2(512)
NOT NULL
Nodes associated with the ring.
1.1.17 Bridge_Group_Table
The Bridge_Group_Table contains information about the bridge group table.
Primary key: None