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 Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
I0000217 NAME Unique Index
SQL060903235245890 ROLE_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names 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
Related reference