Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMEXPFAMILY
The set of related marketing activities.
Column Name Column Type Description DMACTIVITY_ID INTEGER NOT NULL The identifier of a marketing activity. FAMILY_ID INTEGER NOT NULL The ID of the activity which is the first activity from a set of activity versions. All versions of the same activity will have the same name and family_id, but will have different sequence numbers. SEQUENCE SMALLINT NOT NULL DEFAULT 0 The sequence number of the activity. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030327940 DMACTIVITY_ID Primary Key I0001200 FAMILY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3550 DMACTIVITY_ID DMACTIVITY DMACTIVITY_ID Cascade _vcc_freeselect_bottom_