CSO_DISCUSSION_BOARD_RES

This table contains the localized resources for discussion board records.

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_DISCUSSION_BOARD_RES_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments
DATE_ADDED TIMESTAMP Yes This is the date that the record was added to the repository.
DATE_MODIFIED TIMESTAMP Yes Date record was last modified in repository.
DISCUSSION_ID VARCHAR2 32 Yes This is the GUID reference to the discussion board record.
LOCALE_ID VARCHAR2 32 Yes This is the GUID reference to the locale record.
NAME VARCHAR2 1000 This is the Localized discussion board name.
NEEDS_TRANSLATION CHAR 1 Flag indicating whether or not the resource needs translating to other supported locales in the repository.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
SEARCH_STRING VARCHAR2 255 String used as a reference key in the source code to match a resource request with a locale specific resource.

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_DISCUSSION_BOARD_RES cso_locale LOCALE_ID
CSO_DISCUSSION_BOARD_RES cso_discussion_board DISCUSSION_ID

Indexes

Index Uniqueness Columns
CSO_DISCUSSION_BOARD_RES_U1 Unique RECORD_ID
CSO_DISCUSSION_BOARD_RES_N1 Non Unique LOCALE_ID
CSO_DISCUSSION_BOARD_RES_N2 Non Unique DISCUSSION_ID