Database Table: FORUM

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

Column Name Column Type Column Description
BANNERURL CHARACTER (254)
NULL
The URL used as a banner for the forum.
CREATETIME TIMESTAMP
NULL
The date and time the forum was created.
DESCRIPTION VARCHAR (4000)
NULL
A description of the forum.
FORUM_ID BIGINT
NOT NULL
Forum ID. Primary key to the table.
MBRGRP_ID BIGINT
NULL
Member group ID.
NAME VARCHAR (254)
NULL
Name of the forum.
OWNER_ID BIGINT
NOT NULL
Owner of the forum.
STATUS CHARACTER (4)
NULL
Valid values: A=active, D=deleted.
SUBJTYPE CHARACTER (32)
NULL
Subject type. Type of subjects to be discussed in the forum.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034936470 FORUM_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_348 OWNER_ID MEMBER MEMBER_ID Cascade
F_349 MBRGRP_ID MBRGRP MBRGRP_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_352 FORUM_ID FORUMMSG FORUM_ID Cascade