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 Related reference
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_352 FORUM_ID FORUMMSG FORUM_ID Cascade