Reference > Database > WebSphere Commerce database tables > R
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 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 SQL100520030424850 ROLE_ID Primary Key
Referenced By 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
_vcc_freeselect_bottom_