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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034936470 | FORUM_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_352 | FORUM_ID | FORUMMSG | FORUM_ID | Cascade |