WebSphere Commerce database table: MBRGRPTYPE
This table stores intended usages that can be associated with member groups.
Column Descriptions Column Name Column Type Description MBRGRPTYPE_ID INTEGER NOT NULL Primary key, internally generated. DESCRIPTION VARCHAR(254) Description of the member group type. NAME VARCHAR(254) NOT NULL The type of member group. For example, AccessGroup or CustomerGroup. PROPERTIES VARCHAR(254) Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000153 NAME Unique Index SQL060903235213320 MBRGRPTYPE_ID Primary Key
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_449 MBRGRPTYPE_ID MBRGRPUSG MBRGRPTYPE_ID Cascade