Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
136
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
FWVersion
VARCHAR2(32)
—
Firmware version.
FWUpdateDate
VARCHAR2(32)
—
Date of firmware update.
WaveLength
VARCHAR2(64)
—
Wavelength.
ModuleNumber
NUMBER(20)
—
Module number.
MacAddress
VARCHAR2(17)
—
MAC address of the module.
1.1.127
ONS15216_Privilege_Table
The ONS15216_Privilege_Table contains information on privilege levels allowed for the
ONS 15216 NE.
ONS 15216 NE.
Primary key: PK_ONS15216_PRIV_ID
Tablespace: ONS152xx_DATA_TABLESPACE
Table 1-123 : ONS15216_Privilege_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
PrivilegeID
NUMBER(10)
NOT NULL
ID to access this table.
Privilege
VARCHAR2(30)
NOT NULL
Privilege level.
Description
VARCHAR(64)
—
Description.
1.1.128
ONS15216_User_Table
The ONS15216_User_Table contains information about ONS 15216 users.
Primary key: ONS15216_USER_TABLE_PK
Tablespace: ONS152xx_DATA_TABLESPACE
Table 1-124: ONS15216_User Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
NEDBAccessID
NUMBER(10)
NOT NULL
ID to access an NE in this table.
UserID
VARCHAR2(64)
NOT NULL
ONS 15216 username.
Password
VARCHAR2(64)
—
ONS 15216 password.
PrivilegeID
NUMBER(10)
—
Privilege level.
LastLoginTime
DATE
—
Time stamp of the last login.
Timeout
NUMBER(3)
DEFAULT 0
Change password on next login status.