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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000217 | NAME | Unique Index |
SQL030416035056360 | ROLE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |