PON_THREAD_MESSAGE_RECIPIENTS
PON_THREAD_MESSAGE_RECIPIENTS table stores the recipients for a message initiated through the online discussion feature. Each row in this table corresponds to an individual recipient for a message. The table also maintains the message status (Unread/Read/Replied) in context of a recipient for a message.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PON_THRD_MSG_RECIPIENTS_PK |
RECIPIENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECIPIENT_ID | NUMBER | 18 | Yes | System-generated unique number to identify a message recipient in the thread | |
| MESSAGE_ID | NUMBER | 18 | Yes | Identifier of the message | |
| TO_PERSON_ID | NUMBER | 18 | Person Id if the recipient is a buyer. Value will be null if supplier is the recipient | ||
| TO_PARTY_ID | NUMBER | 18 | Party Id if the recipient is a supplier contact. Value will be null if buyer is the recipient | ||
| MESSAGE_FLAG | VARCHAR2 | 20 | Yes | Flag to indicate if the message is Unread, Read or Replied. The corresponding codes are UNREAD, READ and REPLIED | |
| TO_TRADING_PARTNER_ID | NUMBER | 18 | Supplier company party id if the recipient is a supplier contact. Value will be null if buyer is the recipient | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PON_THREAD_MESSAGE_RECIPIENTS | pon_thread_messages | MESSAGE_ID |
| PON_THREAD_MESSAGE_RECIPIENTS | per_persons | TO_PERSON_ID |
| PON_THREAD_MESSAGE_RECIPIENTS | hz_parties | TO_PARTY_ID |
| PON_THREAD_MESSAGE_RECIPIENTS | hz_parties | TO_TRADING_PARTNER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_THRD_MSG_RECIPIENTS_U1 | Unique | Default | RECIPIENT_ID |
| PON_THRD_MSG_RECIPIENTS_U2 | Unique | Default | MESSAGE_ID, TO_PERSON_ID, TO_PARTY_ID, TO_TRADING_PARTNER_ID |