Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
308
Primary key: None
Tablespace: BASE_DATA_TABLESPACE
Table 1-244: User_NE_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
UserID
NUMBER(4)
—
ID of the user.
Grouporneid
NUMBER(10)
—
Group ID or NEDBaccessid.
1.1.256
User_Preference_Table
The User_Preference_Table stores information about user preferences.
Primary key: USER_PREFERENCE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-245: User_Preference_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
UserName
VARCHAR2(64)
NOT NULL
Prime Optical username.
ClientModule
NUMBER(4)
—
Client module ID. Values are:
0: Network Map
1: Control Panel
0: Network Map
1: Control Panel
AutoRefresh
NUMBER(1)
—
Whether autorefresh is on or off. Values
are:
1: On
0: Off
are:
1: On
0: Off
1.1.257
User_Table
The User_Table contains information about all Prime Optical users.
Primary key: USER_TABLE_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-246: User_Table
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
UserID
NUMBER(4)
NOT NULL
User ID. Link to the User_Map_Table.
Each user has a unique ID.
Each user has a unique ID.
UserName
VARCHAR2(64)
UNIQUE,
Unique name of the user.