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:

NameTypeDescription
ROLE_IDINTEGER NOT NULLPrimary key for the role.
NAMEVARCHAR (254) NOT NULLName of the role. For example, "Customer Service Representative".
DESCRIPTIONVARCHAR (4000)Description of the role.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ROLE_IDPrimary Key
I0000217NAMEUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1028ROLE_IDROLEDESCROLE_IDCascade
F_1215ROLE_IDROLEASNPRMASSIGNING_ROLE_IDCascade
F_1216ROLE_IDROLEASNPRMASSIGNABLE_ROLE_IDCascade
F_1217ROLE_IDTICKLERRESPONSIBLEROLECascade
F_1218ROLE_IDTKLRREASONASSIGNTOROLECascade
F_453ROLE_IDMBRROLEROLE_IDCascade