Cisco Cisco Prime Optical 9.6 Technical References
Cisco Prime Optical 9.6.3 Database Schema
OL-28045-01
311
Column Name
Oracle Data
Type
Type
Integrity
Constraints
Constraints
Description
UserTypeID
NUMBER(4)
NOT NULL
User type ID that is unique for each
user. Values are:
1: SuperUser
2: SysAdmin
3: NetworkAdmin
4: Operator
5: Provisioner
user. Values are:
1: SuperUser
2: SysAdmin
3: NetworkAdmin
4: Operator
5: Provisioner
UserTypeName
VARCHAR2(64)
NOT NULL
Name of the user type.
Properties
NUMBER(1)
—
Defines whether the user has NEs
assigned to him/her or not. Values are:
0: Assign no NEs
1: Assign all NEs
2: Assign Nes
assigned to him/her or not. Values are:
0: Assign no NEs
1: Assign all NEs
2: Assign Nes
Description
VARCHAR2(256)
—
Description of the user type.
isDefault
NUMBER(1)
DEFAULT 1
Defines if a user is a default user. Values
are:
0: Custom user profile
1: Default user profile
are:
0: Custom user profile
1: Default user profile
AllowedSession
NUMBER(2)
DEFAULT 1
Defines if a user is allowed single or
multiple user logins. Values are:
0: Allow multiuser login
1: Allow 1 user login
2: Allow 2 user login
3: Allow 3 user login
4: Allow 4 user login
5: Allow 5 user login
6: Allow 6 user login
7: Allow 7 user login
8: Allow 8 user login
9: Allow 9 user login
10: Allow 10 user login
multiple user logins. Values are:
0: Allow multiuser login
1: Allow 1 user login
2: Allow 2 user login
3: Allow 3 user login
4: Allow 4 user login
5: Allow 5 user login
6: Allow 6 user login
7: Allow 7 user login
8: Allow 8 user login
9: Allow 9 user login
10: Allow 10 user login
1.1.259
Version_Table
The Version_Table contains version information about the NEs supported by
Prime Optical.
Prime Optical.
Primary key: VERSION_PK
Tablespace: BASE_DATA_TABLESPACE
Table 1-248: Version_Table