WebSphere Commerce database table: FORUM

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235201150 FORUM_ID Primary Key
I0000576 OWNER_ID Non-Unique Index
I0000577 MBRGRP_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_349 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_348 OWNER_ID MEMBER MEMBER_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_352 FORUM_ID FORUMMSG FORUM_ID Cascade
Related reference