CSO_DISCUSSION_BOARD
This table contains the discussion board records.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_DISCUSSION_BOARD_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ABUSE_THRESHOLD | NUMBER | Number of abuse reports before taking action on the abusive message. | |||
| BAN_IF_ABUSE | NUMBER | Flag that indicates that the author should be banned if abuse threshold reached. | |||
| BAN_USER_DAYS | NUMBER | Number of days a user should be banned from the site. | |||
| DATE_ADDED | TIMESTAMP | Yes | This is the datetime that the record was added to the repository. | ||
| DATE_MODIFIED | TIMESTAMP | Yes | Datetime record was last modified in repository. | ||
| ENABLE_ABUSE | NUMBER | Flag that indicates if the report abuse functionality is turned on or not. Values 0-Disabled, 1-Enabled. | |||
| HELPFUL_POINTS | NUMBER | Number of points awarded to the message author for a helpful answer. | |||
| HELPFUL_QUANTITY | NUMBER | Number of helpful answers allowed for a topic question. | |||
| MESSAGE_RATING_ID | VARCHAR2 | 32 | This is the GUID reference to the survey record that represents the rating used for message records. | ||
| OWNER_SITE_ID | VARCHAR2 | 32 | Yes | This is the GUID reference to the site record that owns the discussion board. | |
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. | |
| REFERENCE_KEY | VARCHAR2 | 255 | Yes | Locale independent name used to uniquely identify a discussion board. | |
| SOLVED_POINTS | NUMBER | Number of points awarded to the message author for a solved answer. | |||
| SOLVED_QUANTITY | NUMBER | Number of solved answers allowed for a topic question. | |||
| TOPIC_RATING_ID | VARCHAR2 | 32 | This is the GUID reference to the survey record that represents the rating used for topic records. | ||
| UNPUBLISH_IF_ABUSE | NUMBER | Flag that indicates that the messages should be unpublished if abuse threshold reached. | |||
| MODERATE_IF_ABUSE | NUMBER | Flag that indicates that the messages should be flagged for moderation if abuse threshold reached. | |||
| USER_ID | VARCHAR2 | 32 | This is the obsolete GUID reference to the user that created the record. | ||
| USER_NAME | VARCHAR2 | 100 | Yes | Full name of user record that created the record. | |
| USER_PARTY_ID | NUMBER | 18 | This is the ID of the user that created the record. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CSO_DISCUSSION_BOARD | cso_site | OWNER_SITE_ID |
| CSO_DISCUSSION_BOARD | cso_survey | TOPIC_RATING_ID |
| CSO_DISCUSSION_BOARD | cso_survey | MESSAGE_RATING_ID |
| cso_db_locale | cso_discussion_board | DISCUSSION_ID |
| cso_db_privilege | cso_discussion_board | DISCUSSION_BOARD_ID |
| cso_db_metrics | cso_discussion_board | DISCUSSION_BOARD_ID |
| cso_discussion_board_res | cso_discussion_board | DISCUSSION_ID |
| cso_db_forum | cso_discussion_board | DISCUSSION_BOARD_ID |
| cso_db_user_grps | cso_discussion_board | DISCUSSION_ID |
| cso_db_site | cso_discussion_board | DISCUSSION_ID |
| cso_db_tag | cso_discussion_board | DISCUSSION_ID |
| cso_db_message_filter | cso_discussion_board | DISCUSSION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_DISCUSSION_BOARD_N1 | Non Unique | Default | OWNER_SITE_ID |
| CSO_DISCUSSION_BOARD_N2 | Non Unique | Default | MESSAGE_RATING_ID |
| CSO_DISCUSSION_BOARD_N3 | Non Unique | Default | TOPIC_RATING_ID |
| CSO_DISCUSSION_BOARD_U1 | Unique | Default | RECORD_ID |