WebSphere Commerce database table: ROLE

This table stores the roles defined in WebSphere Commerce. Once a role is created, you cannot change the name or description of a role using a graphical user interface tool.


Column Description(s):
Column NameColumn TypeDescription
ROLE_ID INTEGER NOT NULL Primary key for the role.
NAME VARCHAR(254) NOT NULL Name of the role. For example, "Customer Service Representative".
DESCRIPTION VARCHAR(4000) Description of the role.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000217 NAME Unique Index
SQL050212031307350 ROLE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_453 ROLE_ID MBRROLE ROLE_ID Cascade
F_1216 ASSIGNABLE_ROLE_ID ROLEASNPRM ROLE_ID Cascade
F_1215 ASSIGNING_ROLE_ID ROLEASNPRM ROLE_ID Cascade
F_1028 ROLE_ID ROLEDESC ROLE_ID Cascade
F_1217 RESPONSIBLEROLE TICKLER ROLE_ID Cascade
F_1218 ASSIGNTOROLE TKLRREASON ROLE_ID Cascade

Feedback