WebSphere Commerce database table: FORUM

This table contains a list of valid forums. Forums are used to exchange messages between administrators and customers.


Column Description(s):
Column NameColumn TypeDescription
FORUM_ID BIGINT NOT NULL Forum ID. Primary key to the table.
OWNER_ID BIGINT NOT NULL Owner of the forum.
NAME VARCHAR(254) Name of the forum.
MBRGRP_ID BIGINT Member group ID.
DESCRIPTION VARCHAR(4000) A description of the forum.
CREATETIME TIMESTAMP The date and time the forum was created.
SUBJTYPE CHAR(32) Subject type. Type of subjects to be discussed in the forum.
BANNERURL CHAR(254) The URL used as a banner for the forum.
STATUS CHAR(4) The status of this forum. Valid values are as follows:
  • A=active
  • D=deleted
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031229580 FORUM_ID Primary Key
I0000576 OWNER_ID Non-Unique Index
I0000577 MBRGRP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_349 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_348 OWNER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_352 FORUM_ID FORUMMSG FORUM_ID Cascade

Feedback