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 Column Description
DESCRIPTION VARCHAR (4000)
NULL
Description of the role.
NAME VARCHAR (254)
NOT NULL
Name of the role. For example, "Customer Service Representative".
ROLE_ID INTEGER
NOT NULL
Primary key for the role.
Indexes:
Index Name Indexed Column Names Index Type
I0000217 NAME Unique Index
SQL030416035056360 ROLE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1028 ROLE_ID ROLEDESC ROLE_ID Cascade
F_453 ROLE_ID MBRROLE ROLE_ID Cascade