[Home] [Help] [Dependency Information]
Object Name: | OTA_FORUM_MESSAGES |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_FORUM_MESSAGES |
Subobject Name: | |
Status: | VALID |
This a child of forum thread. This hold the messages which have been posted to the forum thread by external or internal learner.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_FORUM_MESSAGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | FORUM_MESSAGE_ID |
OTA_FORUM_MESSAGES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FORUM_ID |
OTA_FORUM_MESSAGES_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FORUM_THREAD_ID |
OTA_FORUM_MESSAGES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORUM_MESSAGE_ID | NUMBER | (15) | Yes | The system generated surrogatekey for this entry. |
FORUM_ID | NUMBER | (15) | Yes | Foreign Key to OTA_FORUMS_B |
FORUM_THREAD_ID | NUMBER | (15) | Yes | Foreign Key to OTA_FORUM_THREADS |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ALL_OGANIZATION_UNITS |
MESSAGE_BODY | VARCHAR2 | (4000) | User specified message | |
MESSAGE_SCOPE | VARCHAR2 | (1) | Yes | Indicates who can see this message. Default 'P' ,indicating a public message, all subscribed to the forum can view the messages. When a learner/instructor posts a new message, scope is set to 'T'. When a private learner/instructor replies to a message, scope is set to 'U'. |
PARENT_MESSAGE_ID | NUMBER | (15) | This is set when new messages are posted as replies to an earlier message. | |
PERSON_ID | NUMBER | (10) | Foreign key to PER_ALL_PEOPLE_F. Indicates internal learner creates a new message | |
CONTACT_ID | NUMBER | (15) | Foreign key HZ_CUST_ACCOUNT_ROLES. Indicates internal learner creates a new message | |
TARGET_PERSON_ID | NUMBER | (10) | Foreign key to PER_ALL_PEOPLE_F. When an internal learner/instructor reply to a private message, this is set to the id of the user you are replying to. | |
TARGET_CONTACT_ID | NUMBER | (15) | Foreign key HZ_CUST_ACCOUNT_ROLES. When an external learner/instructor reply to a private message, this is set to the id of the user you are replying to. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version control parameter |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT FORUM_MESSAGE_ID
, FORUM_ID
, FORUM_THREAD_ID
, BUSINESS_GROUP_ID
, MESSAGE_BODY
, MESSAGE_SCOPE
, PARENT_MESSAGE_ID
, PERSON_ID
, CONTACT_ID
, TARGET_PERSON_ID
, TARGET_CONTACT_ID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM OTA.OTA_FORUM_MESSAGES;
OTA.OTA_FORUM_MESSAGES does not reference any database object
OTA.OTA_FORUM_MESSAGES is referenced by following:
|
|
|